asp.net创建事务的方法
1、建立List用于存放多条语句
///<summary>
///保存表单
///</summary>
///<paramname="context"></param>
protectedvoidsave()
{
List<string>list=newList<string>();
list.Add(string.Format("insertintopicsone(model,idser,idflg,lmuser,lmdate,lmtime)values('{0}','{1}','{2}','{3}',{4},{5})","T1002","Y","N","U001",20161103,140025));
list.Add(string.Format("insertintopicstwo(model,idser,idflg,lmuser,lmdate,lmtime)values('{0}','{1}','{2}','{3}',{4},{5})","T1002","Y","N","U001",20161103,140025));
boolbol=ExecuteTransaction(list);
if(bol)
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}
2、调用ExecuteTransaction方法，并返回返回值true为成功，false为失败，语句并回滚
///<summary>
///执行语句
///</summary>
///<paramname="list"></param>
///<returns></returns>
privateboolExecuteTransaction(List<string>list)
{
using(SqlConnectionconnection=newSqlConnection(ConfigurationManager.AppSettings["LocalConnectionString"].ToString()))
{
SqlCommandcommand=newSqlCommand();
SqlTransactiontransaction=null;
try
{
connection.Open();
transaction=connection.BeginTransaction();
command.Connection=connection;
command.Transaction=transaction;
for(inti=0;i<list.Count;i++)
{
command.CommandText=list[i];
command.ExecuteNonQuery();
}
transaction.Commit();
connection.Close();
returntrue;
}
catch
{
transaction.Rollback();
connection.Close();
returnfalse;
}
}
}
热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下