用sqldataadapter更新Dataset置事，出！
主要出以下：
在DataGridView中修改後，Button1行更新，如果正，可以更新。但出後(比如其中一列不能空，但是入空)再更改入信息，Button1行更新，此不能正更新。
代如下：
private string sqlconn = SqlHelper.ConnectionString;
SqlConnection conn;
SqlTransaction myTrans;
DataSet ds;
SqlDataAdapter sda;
SqlCommandBuilder cmd;
public frmTest()
{
InitializeComponent();
}

private void frmTest_Load(object sender, EventArgs e)
{
conn = new SqlConnection(sqlconn);
conn.Open();
sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("Select * From DataTableCollection", conn);
ds = new DataSet();
sda.Fill(ds, "DataTableCollection");
this.dataGridView1.DataSource = ds.Tables[0];
}

private void button1_Click(object sender, EventArgs e)
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd = new SqlCommandBuilder(sda);
myTrans = cmd.GetInsertCommand().Connection.BeginTransaction();
cmd.GetInsertCommand().Transaction = myTrans;
cmd.GetDeleteCommand().Transaction = myTrans;
cmd.GetUpdateCommand().Transaction = myTrans;

try
{
sda.Update(ds.Tables[0]);
myTrans.Commit();
MessageBox.Show("成功！");
}
catch(Exception ex)
{
myTrans.Rollback();
MessageBox.Show("失！"+ex.Message);
}
finally
{
conn.Close();
}
}

[解决办法]

C# code

myTrans = sda.SelectCommand().Connection.BeginTransaction(); sda.InsertCommand().Transaction = myTrans; sda.DeleteCommand().Transaction = myTrans; sda.UpdateCommand().Transaction = myTrans;
[解决办法]
SqlDataAdapter,更新数据时,遇到错误,就会退出Update方法.

可以用SqlCommand一笔一笔更新,如果执意要用SqlDataAdapter,可选择更新前检查datagridview数据的有效性,检查无误后,再调用Update方法.