调用存储过程与返回值
SqlConnection cn =
new
SqlConnection(
"server=.;uid=sa;pwd=;database=Northwind"
);
SqlCommand cmd =
new
SqlCommand(
"InsertCategory"
, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(
"@ReturnValue"
, SqlDbType.Int);
cmd.Parameters[
"@ReturnValue"
].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(
"@CategoryName"
, SqlDbType.NChar, 15).Value = TextBox1.Text;
cmd.Parameters.Add(
"@identity"
, SqlDbType.Int);
cmd.Parameters[
"@identity"
].Direction = ParameterDirection.Output;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
Label1.Text =
string
.Empty;
Label1.Text += cmd.Parameters[
"@identity"
].Value.ToString();
Label1.Text +=
" "
+ cmd.Parameters[
"@ReturnValue"
].Value.ToString();
CREATE
PROC InsertCategory
@CategoryName
nchar
(15),
@identity
int
OUT
AS
INSERT
INTO
Categories(CategoryName)
Values
(@CategoryName)
SET
@identity = @@identity
Return
@@RowCount