c# 事务中多表添加数据超时,请各位帮忙!可有100分酬谢
@信心 2011-10-25 11:48:43 c# 事务中多表添加数据超时,请各位帮忙!!!
//事务
string connetstrl .... ;
SqlConnection con = new SqlConnection(connetstrl);
con.Open();
//通过SqlConnection的BeginTransaction方法创建名为st的对象Transaction
SqlTransaction st =con.BeginTransaction();
SqlCommand com = con.CreateCommand();
//将SqlTransaction对象分配给SqlCommand对象的Transaction属性
com.Transaction = st;
try
{
//客户1
if (Client_Exit1 != "yes")
{ //生成流水号
createNum();//利用selet max(clientid +1 from client) 获取
com.CommandText= "insert into client...";
com.ExecuteNonQuery();
}
//客户
if (Client_Exit2 != "yes")
{
//生成流水号
createNum();
com.CommandText = "insert into clientinfo
com.ExecuteNonQuery();
}
//车辆
if (Vehicle_Exit != "yes")
{ //生成流水号
createaNum();
com.CommandText = "insert into Vehicle...)
com.ExecuteNonQuery();
}
//销售资料
com.CommandText = "insert into gy_Sal() ;
com.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{ MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}