#region
string zx = "";
SqlConnection myConnection = new SqlConnection("server=.;database=QQHR;uid=sa;pwd=123");
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
// 为事务创建一个命令
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
try
{
sql操作语句
//例子
string[] cyr = Request["join"].ToString().Split(',');
for (int i = 1; i < cyr.Count(); i++)
{
string zxs = "INSERT INTO dbo.JoinPel VALUES ((SELECT uRealName FROM dbo.sysUserInfo WHERE uid=" + cyr[i] + "), CONVERT(int,(SELECT TOP 1 tId FROM syxTaskInfo ORDER BY tId DESC)),'" + cyr[i] + "')";
myCommand.CommandText = zxs;
myCommand.ExecuteNonQuery();
}
myTrans.Commit();
zx = "成功";
// Response.Write("成功写入记录!");
}
catch (Exception Ex)
{
myTrans.Rollback();
Response.Write(Ex.ToString());
zx = "失败";
// Response.Write("写入数据库失败!");
}
finally
{
myConnection.Close();
}
#endregion
string zx = "";
SqlConnection myConnection = new SqlConnection("server=.;database=QQHR;uid=sa;pwd=123");
myConnection.Open();
// 启动一个事务
SqlTransaction myTrans = myConnection.BeginTransaction();
// 为事务创建一个命令
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
try
{
sql操作语句
//例子
string[] cyr = Request["join"].ToString().Split(',');
for (int i = 1; i < cyr.Count(); i++)
{
string zxs = "INSERT INTO dbo.JoinPel VALUES ((SELECT uRealName FROM dbo.sysUserInfo WHERE uid=" + cyr[i] + "), CONVERT(int,(SELECT TOP 1 tId FROM syxTaskInfo ORDER BY tId DESC)),'" + cyr[i] + "')";
myCommand.CommandText = zxs;
myCommand.ExecuteNonQuery();
}
myTrans.Commit();
zx = "成功";
// Response.Write("成功写入记录!");
}
catch (Exception Ex)
{
myTrans.Rollback();
Response.Write(Ex.ToString());
zx = "失败";
// Response.Write("写入数据库失败!");
}
finally
{
myConnection.Close();
}
#endregion