110,534
社区成员
发帖
与我相关
我的任务
分享
catch(Exception ex)
{
trans.Rollback();
}
private void button4_Click(object sender, EventArgs e)
{
try
{
con1.Open();
con1.RunProc(" begin tran ");
//程序执行数据库修改
con1.RunProc(" insert into 。。。");
。。。。
con1.RunProc(" commit ");
con1.Close();
}
catch (Exception ex)
{
con1.RunProc(" ROLLBACK ");
con1.Close();
}
}
public SqlCommand RunProc(string procName)
{
SqlConnection conn = this.getcon1();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = procName;
cmd.ExecuteNonQuery();
return cmd;
}
using (DbTransaction trans = con1.BeginTransaction())
{
try
{
//..
trans.Commit();
}
catch
{
trans.Rollback();
}
}