请帮忙看看下面这段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);
&n