62,046
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn = new SqlConnection(STR_CONN);
SqlCommand cmd = new SqlCommand();
cmd.CommandTimeout = timeOut;
cmd.Connection = conn;
try
{
conn.Open();
cmd.Transaction = conn.BeginTransaction();
}
catch
{
conn.Close();
return false;
}
try
{
foreach(string str in sql)
{
if(str != null)
{
if(str.Trim() != "")
{
cmd.CommandText = str;
cmd.ExecuteNonQuery();
}
}
}
cmd.Transaction.Commit();
conn.Close();
return true;
}
catch
{
cmd.Transaction.Rollback();
conn.Close();
return false;
}