How to Update DataTable to MySql database Without loop

[C# Programming]

I have a DataTable MyDT like below:

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()//<span class="code-comment">