title: Update DataTable to MySql database C#
body: <p>I have a DataTable MyDT like below:</p>
  
  <pre><code>string MyConString = "SERVER=" + sConfig_hostname + ";" +
                  "DATABASE=" + sConfig_dbname + ";" +
                  "UID=" + sConfig_dbusername + ";" +
                  "PASSWORD=" + sConfig_dbpassword + ";Allow Zero Datetime=true;";
              MySqlConnection connection = new MySqlConnection(MyConString);
              string sQuery="Select * from Table";
              connection.Open();
              MySqlDataAdapter myDA = new MySqlDataAdapter(sQuery, connection);
              myDA.SelectCommand.ExecuteNonQuery();
              DataTable MyDT=new DataTable()// &lt;- My DataTable
              myDA.Fill(MyDT);
              connection.Close();
  ...
  ...
  // do something with MyDT
  ...
  ...
  </code></pre>
  
  <p>After do something with MyDT , I want to update it to the DataBase, how can I do it ?I have searched google for pages but almost update by looping the datatable. is there a way to update the whole datatable without loop?Please help! Thanks for reading</p>