for (int x = 0; x < List.Count; x++)
{ ......
sql=INSERT INTO aaa(a_id) values ("+id+") SELECT SCOPE_IDENTITY();
for (int y = 0; y < List_1.Count; y++)
{
........
sql_1=insert into bbb (b_id) VALUES ("+getid+"); //此处要取上面sql语句插入时的自动增量ID
}
for (int z=0; z<list_2.Count; z++))
{
........
sql_2=insert into ccc (c_id) values ("+getid+"); //此处要取上面sql语句插入时的自动增量ID }
}事务处理部分我是这样写的
public bool ExeSqlTrans(string[] sqlArr)
{
string strChSql;
SqlConnection conn = new SqlConnection(Cnnect)
{ conn.Open();
SqlTransaction SqlTrans=conn.BeginTransaction();
SqlCommand cmd=conn.CreateCommand();
cmd.Transaction=SqlTrans;
try
{
for(int i=0;i<sqlArr.Length;i++)
{
strChSql=sqlArr[i];
cmd.CommandText =strChSql;
cmd.ExecuteNonQuery();
}
SqlTrans.Commit();
return true;
}
catch
{
SqlTrans.Rollback();
return false;
}
finally
{
}
}}
那么我如何把上面的的for循环的sql语句全填到string[] 中应该怎么写呢?怎么初始化数组的大小? 另外sql_1和sql_2怎么取得sql中的自动增量ID?
{ ......
sql=INSERT INTO aaa(a_id) values ("+id+") SELECT SCOPE_IDENTITY();
for (int y = 0; y < List_1.Count; y++)
{
........
sql_1=insert into bbb (b_id) VALUES ("+getid+"); //此处要取上面sql语句插入时的自动增量ID
}
for (int z=0; z<list_2.Count; z++))
{
........
sql_2=insert into ccc (c_id) values ("+getid+"); //此处要取上面sql语句插入时的自动增量ID }
}事务处理部分我是这样写的
public bool ExeSqlTrans(string[] sqlArr)
{
string strChSql;
SqlConnection conn = new SqlConnection(Cnnect)
{ conn.Open();
SqlTransaction SqlTrans=conn.BeginTransaction();
SqlCommand cmd=conn.CreateCommand();
cmd.Transaction=SqlTrans;
try
{
for(int i=0;i<sqlArr.Length;i++)
{
strChSql=sqlArr[i];
cmd.CommandText =strChSql;
cmd.ExecuteNonQuery();
}
SqlTrans.Commit();
return true;
}
catch
{
SqlTrans.Rollback();
return false;
}
finally
{
}
}}
那么我如何把上面的的for循环的sql语句全填到string[] 中应该怎么写呢?怎么初始化数组的大小? 另外sql_1和sql_2怎么取得sql中的自动增量ID?
http://community.csdn.net/Expert/topic/4191/4191899.xml?temp=.7712671
那么
sql_1=insert into bbb (b_id) VALUES ("+?????+");这个地方怎么写?
http://community.csdn.net/Expert/topic/4143/4143279.xml?temp=.7899591