/// <summary> /// Updates the given table with data from the given <see cref="DataSet"/> /// </summary> /// <param name="connectionString">Settings to use for the update</param> /// <param name="commandText">Command text to use for the update</param> /// <param name="ds"><see cref="DataSet"/> containing the new data to use in the update</param> /// <param name="tablename">Tablename in the dataset to update</param> public static void UpdateDataSet(string connectionString, string commandText, DataSet ds, string tablename) { MySqlConnection cn = new MySqlConnection(connectionString); cn.Open(); MySqlDataAdapter da = new MySqlDataAdapter(commandText, cn); MySqlCommandBuilder cb = new MySqlCommandBuilder(da); cb.ToString(); da.Update(ds, tablename); cn.Close(); }