62,046
社区成员
发帖
与我相关
我的任务
分享
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = SQL;
con.Open();
SqlTransaction tran = con.BeginTransaction();
cmd.Transaction = tran;
int Result = 0;
try
{
Result = cmd.ExecuteNonQuery();
tran.Commit();
}
catch
{
tran.Rollback();
}
finally
{
con.Close();
}
if (Result > 0)
{
lbState.Text = "更新数据成功!";
BindGridView();
}
else
{
lbState.Text = "更新数据失败!";
}
this.gvWageBase.EditIndex = -1;
this.BindGridView();
这是一条数据的修改 你加一个数据修改就是了