比如简单的
SqlConnection conn=new SqlConnection("server=mySql;uid=sa;pwd=22;database=DATA");
SqlCommand cmd=new SqlCommand("insert into .....",conn);
conn.Open()
SqlTransaction tran=conn.BeginTransaction();
cmd.Transaction=tran
try
{
cmd.ExecuteNonQuery();
tran.Commit();}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
SqlConnection conn=new SqlConnection("server=mySql;uid=sa;pwd=22;database=DATA");
SqlCommand cmd=new SqlCommand("insert into .....",conn);
conn.Open()
SqlTransaction tran=conn.BeginTransaction();
cmd.Transaction=tran
try
{
cmd.ExecuteNonQuery();
tran.Commit();}
catch
{
tran.Rollback();
}
finally
{
conn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货