C#用update方法更新数据库时,内存表为datatable,更新结果不是将数据库修改成datatable的值,而是保留数据库原值,同时将datatable中的值Insert进数据库了,求方法,更新数据库值而不是Insert
connection.Open();
MySqlCommand command = new MySqlCommand();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommandBuilder builder = new MySqlCommandBuilder(adapter);
command.CommandText = sqlString;
command.CommandType = CommandType.Text;
adapter.SelectCommand = command;
adapter.SelectCommand.Connection = connection;
adapter.Update(datatable);//关键语句,执行更新数据集,更新数据库语句
adapter.Dispose();
connection.Close();