小学课件网,php多线程,排列五预测霸王福彩4368
1、建立list用于存放多条语句
/// <summary> /// 保存表单 /// </summary> /// <param name="context"></param> protected void save() { list<string> list = new list<string>(); list.add(string.format("insert into picsone(model,idser,idflg,lmuser,lmdate,lmtime) values('{0}','{1}','{2}','{3}',{4},{5})", "t1002", "y", "n", "u001", 20161103, 140025)); list.add(string.format("insert into picstwo(model,idser,idflg,lmuser,lmdate,lmtime) values('{0}','{1}','{2}','{3}',{4},{5})", "t1002", "y", "n", "u001", 20161103, 140025)); bool bol = executetransaction(list); if (bol) { messagebox.show("保存成功!"); } else { messagebox.show("保存失败!"); } }
2、调用executetransaction方法,并返回返回值true为成功,false为失败,语句并回滚
/// <summary> /// 执行语句 /// </summary> /// <param name="list"></param> /// <returns></returns> private bool executetransaction(list<string> list) { using (sqlconnection connection = new sqlconnection(configurationmanager.appsettings["localconnectionstring"].tostring())) { sqlcommand command = new sqlcommand(); sqltransaction transaction = null; try { connection.open(); transaction = connection.begintransaction(); command.connection = connection; command.transaction = transaction; for (int i = 0; i < list.count; i++) { command.commandtext = list[i]; command.executenonquery(); } transaction.commit(); connection.close(); return true; } catch { transaction.rollback(); connection.close(); return false; } } }
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Blazor server side 自家的一些开源的, 实用型项目的进度之 CEF客户端
.NET IoC模式依赖反转(DIP)、控制反转(Ioc)、依赖注入(DI)
vue+.netcore可支持业务代码扩展的开发框架 VOL.Vue 2.0版本发布
网友评论