title: Mysql dataadapter InsertCommand
body: <p>I have following code </p>
  
  <pre><code>MySqlConnection myCon = new MySqlConnection(System.Configuration.ConfigurationManager.AppSettings["mySQLCon"]);
  MySqlDataAdapter dAdap = new MySqlDataAdapter();
  dAdap.InsertCommand = new MySqlCommand("insert into PMduedates(eCId,ECClass,ddate,PMType) values(eCId,ECClass,ddate,PMType)", myCon);
  dAdap.InsertCommand.Parameters.Add("eCId", MySqlDbType.VarChar, 20, "eqpID");
  dAdap.InsertCommand.Parameters.Add("ECClass", MySqlDbType.VarChar, 100, "class");
  dAdap.InsertCommand.Parameters.Add("ddate", MySqlDbType.VarChar, 100, "MaintType");
  dAdap.InsertCommand.Parameters.Add("PMType", MySqlDbType.Date, 10, "Duedate");
  myCon.Open();
  dAdap.Update(dtDue);
  myCon.Close();
  </code></pre>
  
  <p>In the above code dtDue is a datatable and eqpID,class,MaintType and Duedate are datacolumns. when i am executing code it does n't gives any error but data is not updating in table PMduedates.</p>