Community discussion forum

Getting warning while inserting values into database

• • Reply

  8 months ago

  by moaaz

  moaaz mohammed al garhi

  , Egypt

  Joined 10 months ago

  
  This is the code.
  error occured at "parameters.Add".
  Please help me by solving this problem
  
  pp = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=c:\\Form.mdb");
  pp.Open();
  ppc = new System.Data.OleDb.OleDbCommand("insert into Registration(Name,Id)values(@a,@b)",pp);
  ppc.Parameters.Add("@a",name.Text);
  ppc.Parameters.Add("@b",id.Text);
  ppc.ExecuteNonQuery();
  pp.Close();
  
  Thank you
  

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  8 months ago

  by jeevesh.rastogi

  Jeevesh Rastogi

  , India

  Joined 1 year ago

  try it after putting 

  ppc.Parameters.Add("@a",name.Text.toString());

  in place of 
   

  ppc.Parameters.Add("@a",name.Text);

   

  Jeevesh

  
  

  Report abuse