带传入参数与输出参数及返回值的存储过程在使用时的注意事项总结:
1.传入参数的参数名需与存储过程中定义的参数名一直,且区分大小写
3.输出参数需指定其参数类型(Direction)为传入参数类型(output)
4.输出参数需指定输出参数长度(size)
5.输出参数的参数名需与存储过程中定义的参数名一直,且区分大小写
6.返回值参数需指定其参数类型(Direction)为返回值参数类型(ReturnValue)
7.返回值参数不需指定返回值参数名以及长度
8.在存储过程中返回值参数为int型
protected void Button3_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txbName.Text))
{
if (!string.IsNullOrEmpty(txbPwd.Text))
{
string name = txbName.Text;
string pwd = txbPwd.Text;
SqlParameter p_username = new SqlParameter();
p_username.Value = name;
p_username.DbType = System.Data.DbType.String;
p_username.ParameterName = "@username";
SqlParameter p_userpassword = new SqlParameter();
p_userpassword.Value = pwd;
p_userpassword.DbType = System.Data.DbType.String;
p_userpassword.ParameterName = "@userpassword";
SqlParameter p_isallow = new SqlParameter();
p_isallow.Value = false;