60.
61.
//
使用存储过程
62.
/*
63.
*Create Procedure InsertProduts
64.
* (
65.
* @ProductName NVarchar(80),
66.
* @UnitPrice Money
67.
* ) as Insert Products(ProductName , UnitPrice)
68.
* Values (@ProuctName ,@UnitPrice)
69.
*/
70.
cmd = new SqlCommand("InsertProducts",con);
71.
//InsertProducts 为 SQL
数据库里的存储过程名称
72.
73.
cmd.CommandType = CommandType.StoredProcedure;
74.
cmd.Parameters.Add("@ProductName","Milk");
75.
cmd.Parameters.Add("@UnitPrice",12.45);
76.
cmd.ExecuteNonQuery();
77.
78.
//
获取返回值鹤输出参数
79.
80.
//
使用返回值
81.
/*
82.
Create Procedure GetAuthorCount
83.
* As
84.
* Return (Select Count(*) From Authors)
85.
*/
86.
cmd = new SqlCommand("GetAuthorcount",con);
87.
cmd.CommandType = CommandType.StoredProcedure;
88.
SqlParameter parmReturnVaule;
89.
parmReturnVaule = cmd.Parameters.Add("ReturnValue",SqlDbType.Int);
90.
parmReturnVaule.Direction = ParameterDirection.ReturnValue;
91.
cmd.ExecuteNonQuery();