SqlDataAdapter da = new SqlDataAdapter(null,一个新的连接);da.SelectCommand.CommandText = "Select * from yourtable";SqlCommandBuilder builder = new SqlCommandBuilder(da);da.Update( dataSet );
command builder 有时并不能解决问题,最好是新建一个sqldataadapter,再设置它的select和update command,就可以用这个来更新数据库了,SqlDataAdapter da = new SqlDataAdapter(null,一个新的连接);da.SelectCommand = new SqlCommand("Select * from yourtable"); da.UpdateCommand = new SqlCommand("ur command");da.Update( dataSet );
da.UpdateCommand = new SqlCommand("ur command");da.Update( dataSet );