namespace 通过ADO实现事务
{
class Program
{
static void Main(string[] args)
{
string constr = "Data Source=PC-20120604KNHD;Initial Catalog=Schools;Persist Security Info=True;User ID=sa;Password=910809";
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();//打开事务
string sql = "delete from Student where sId=2";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Transaction = tran;
int r = cmd.ExecuteNonQuery();
Console.WriteLine(r.ToString());
tran.Commit();
Console.WriteLine("删除成功了!" + "影响了" + r.ToString() + "条记录");
//tran.Rollback();
//Console.WriteLine("回滚了");
}
}
Console.ReadKey();
}
}
}