private const string SQL_INSERT_ORDER = "Declare @ID int; Declare @ERR int; INSERT INTO Orders VALUES(....); SELECT @ID=@@IDENTITY; INSERT INTO OrderStatus VALUES(.......); SELECT @ERR=@@ERROR;";
.
.
.
.
rdr=cmd.ExecuteReader(CommandBehavior.CloseConnection);rdr.read();if(rdr.GetInt32(1)!=0){............}能一次执行多条SQL语句啊???????????
.
.
.
.
rdr=cmd.ExecuteReader(CommandBehavior.CloseConnection);rdr.read();if(rdr.GetInt32(1)!=0){............}能一次执行多条SQL语句啊???????????
ExecuteReader
ExecuteScalar