很多人会写存储过程,却不知道怎吗调用,今天就写了一个这样的小列子
string connStr = "server=.;uid=sa;pwd=*******;database=****";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("sp_outNume", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("bid", SqlDbType.Int);
cmd.Parameters["bid"].Value = 1;
cmd.Parameters.Add("@bname", SqlDbType.VarChar, 50);
cmd.Parameters["@bname"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string name = cmd.Parameters["@bname"].Value.ToString();
Response.Write(name);
}