如何在.NET中批量执行几个命令？

[dahroswell]

如我想创建几个存储过程：
string connStr="server=.;database=jytdb;uid=sa";
SqlConnection conn=new SqlConnection(connStr);
conn.Open();
SqlCommand cmd=new SqlCommand();
cmd.Connection=conn;
cmd.CommandType=CommandType.Text;
cmd.CommandText="create proc cc as select * from js_Pcard go create proc eb as select * from Js_pcard go create proc be as select * from js_Puser";
cmd.ExecuteNonQuery();

[752]

或者使用事务SqlTransaction，见msdn

[webserv2]

create proc cc as select * from js_Pcard go; create proc eb as select * from Js_pcard go; create proc be as select * from js_Puser";

里面不要有GO
执行回有问题的！
用分号;代替

create proc cc as select * from js_Pcard ;create proc eb as select * from Js_pcard;create proc be as select * from js_Puser
就OK了

[vzxq]

nod

[dahroswell]

还是不行哟，大侠们，请教了！

[dahroswell]

up！

[dahroswell]

救救我吧，真的好急呀！

[dahroswell]

在线等呀，请思归大侠急救！先谢过了。

[怕那没啦]

cmd.CommandText="create proc cc as select * from js_Pcard go; create proc eb as select * from Js_pcard go; create proc be as select * from js_Puser";
只要在你的每条语句后加个分号就行

[zhiri]

我都想知道，UP吧！

[dahroswell]

UP

[dahroswell]

没人回答我！