string ConStr="…..";
SqlConnection Conn=new SqlConnection(ConStr);
Conn.Open();System.Data.SqlClient.SqlTransaction cmicTr=Conn.BeginTransaction();
try
{
//第一笔记录
string SqlCmd="insert into aaa Values('……..')";
SqlCommand SqlStr=new SqlCommand (SqlCmd,Conn);
SqlStr.Transaction=cmicTr;
SqlStr.ExecuteNonQuery();
//第二笔记录
string SqlCmd="insert into bbb Values('……..')";
SqlCommand SqlStr=new SqlCommand (SqlCmd,Conn);
SqlStr.Transaction=cmicTr;
SqlStr.ExecuteNonQuery();
//第三笔记录
string SqlCmd="insert into ccc Values('……..')";
SqlCommand SqlStr=new SqlCommand (SqlCmd,Conn);
SqlStr.Transaction=cmicTr;
SqlStr.ExecuteNonQuery();
cmicTr.Commit();
}
catch(Exception ex)
{
cmicTr.Rollback();
}
SqlConnection Conn=new SqlConnection(ConStr);
Conn.Open();System.Data.SqlClient.SqlTransaction cmicTr=Conn.BeginTransaction();
try
{
//第一笔记录
string SqlCmd="insert into aaa Values('……..')";
SqlCommand SqlStr=new SqlCommand (SqlCmd,Conn);
SqlStr.Transaction=cmicTr;
SqlStr.ExecuteNonQuery();
//第二笔记录
string SqlCmd="insert into bbb Values('……..')";
SqlCommand SqlStr=new SqlCommand (SqlCmd,Conn);
SqlStr.Transaction=cmicTr;
SqlStr.ExecuteNonQuery();
//第三笔记录
string SqlCmd="insert into ccc Values('……..')";
SqlCommand SqlStr=new SqlCommand (SqlCmd,Conn);
SqlStr.Transaction=cmicTr;
SqlStr.ExecuteNonQuery();
cmicTr.Commit();
}
catch(Exception ex)
{
cmicTr.Rollback();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货