请帮忙看看下面这段c#sql事务代码，它不能正确执行？
protected void LinkButton2_click(object sender, EventArgs e)
{
......
ArrayList sqllist = new ArrayList();
SqlStr = "insert into TJCJG001(VZSBH,VWTDW,DJCRQ,VSBMC,VSBXH,NWD,NXDSD,NSL,VBZ,VKS) values( ' " + VZSBH + " ', ' " + VWTDW + " ', ' " + DJCRQ + " ', ' " + VSBMC + " ', ' " + VSBXH + " ', ' " + NWD + " ', ' " + NXDSD + " ', ' " + NSL + " ', ' " + VBZ + " ', ' " + zzjgbh + " ') ";
//Response.Write(SqlStr);
//myCommand = new SqlCommand(SqlStr, conn);
//myCommand.ExecuteNonQuery();
sqllist.Add(SqlStr);
string sqltemp = " ";
for (int i = 0; i < 36; i++)
{
if (VFXJG[i].Equals( " "))
{ }
else
{
sqltemp = "insert into TJCJG001_ds(VZSBH,DCYSJ,CCYDD,VCYRY,CYPZT,CFXXM,VNDDW,VFXFF,VFXJG) values( ' " + VZSBH + " ', ' " + DCYSJ + " ', ' " + CCYDD + " ', ' " + VCYRY + " ', ' " + CYPZT + " ', ' " + CFXXM[i] + " ', ' " + VNDDW[i] + " ', ' " + VFXFF[i] + " ', ' " + VFXJG[i] + " ') ";
//Response.Write(sqltemp);
sqllist.Add(sqltemp);
}
}
//Response.Write(sqllist.Count);
//Response.End();
bool b=ExecuteSqlTran(sqllist);
......
}
public bool ExecuteSqlTran(ArrayList SQLStringList)
{
bool rValue;
string connStr = ConfigurationManager.ConnectionStrings[connstring].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
SqlCommand cmd = new SqlCommand();
try
{
///////(在这个循环里不好使)/////
for (int i = 0; i < SQLStringList.Count; i++)
{
string cmdText = SQLStringList[0].ToString();
cmd.CommandText = cmdText;
int val = cmd.ExecuteNonQuery();
trans.Commit();
}
rValue = true;
}
catch
{
trans.Rollback();
rValue = false;
// throw;
}
}
}
return rValue;
}
[解决办法]
你看是不是得看看val的值是多少？
[解决办法]
sf..
for (int i = 0; i < SQLStringList.Count; i++)
{
string cmdText = SQLStringList[0].ToString();
cmd.CommandText = cmdText;
//增加这行代码
cmd.Transaction = trans;
int val = cmd.ExecuteNonQuery();
trans.Commit();
}
[解决办法]
。。。。。。。。。
看到这个代码就昏了
是不是从asp转学C#哦，多看看论坛大家怎么操作数据库的吧
