22,210
社区成员
发帖
与我相关
我的任务
分享
begin transaction
[事务处理过程]
commit transaction
SqlConnection cn = new SqlConnection("[数据库连接串]");
cn.Open();
ArrayList list = new ArrayList();
list.Add(" if exists(select * from UserDetails where userid='zhanghao01') ");
list.Add(" Begin ");
list.Add(" insert UserDetails ...");
list.Add(" insert SalesDetails ...");
list.Add(" insert ProjectDetails...");
list.Add(" END ");
int i;
string tsql;
tsql = "";
for (i = 0; i <= list.Count-1; i++)
{ tsql = tsql + list[i] + " "; }
SqlCommand cm;
cm = new SqlCommand(tsql, cn);
cm.ExecuteNonQuery();