＋设为首页 ＋添加到收藏夹
用以下代码来增加一条记录，怎么进行事务处理？
有高手指点一下，先谢谢了！
//连接字符串
string strConn = "server=vod;database=voddb;uid=sa;pwd=sa";
//建立一个新的连接
SqlConnection cn = new SqlConnection(strConn);
//打开连接
cn.Open();
//构造SQL语句字符串
string strSQL = "insert into TCustomer(CustomerName,Password,Type,State,Account) values(";
strSQL += m_CustomerName;
strSQL += ",";
strSQL += m_Password;
strSQL += ",11,11,0)";
//构造Command对象
SqlCommand cmd = new SqlCommand(strSQL,cn);
//执行SQL命令
cmd.ExecuteNonQuery ();
//关闭连接
cn.Close();
...
//构造Command对象
SqlCommand cmd = new SqlCommand(strSQL,cn);
cmd.Transaction = cn.BeginTransaction();
try
{
//执行SQL命令
cmd.ExecuteNonQuery ();
cmd.Transaction.Commit();
}
catch {
cmd.Transaction.Rollback();
}
...
//构造Command对象
SqlTransaction myTrans;
SqlCommand cmd = new SqlCommand(strSQL,cn);
cmd.Transaction = cn.BeginTransaction();
try
{
//执行SQL命令
cmd.ExecuteNonQuery ();
cmd.Transaction.Commit();
}
catch {
cmd.Transaction.Rollback();
}
