c# 调用mysql存储过程 返回值_C#中使用存储过程返回值的问题

1.存储过程返回SqlDataReader

public SqlDataReader getaqiyyuy(string qiy)

{

SqlConnection userConnection = Connection.getConnection();

SqlCommand userCommand = new SqlCommand("MVC_getaqiyluy", userConnection);

userCommand.CommandType = CommandType.StoredProcedure;//采用存储过程

userCommand.Parameters.Add("@qiy", SqlDbType.VarChar, 50);//存储过程参数

userCommand.Parameters["@qiy"].Value = qiy;//给参数赋值

userCommand.Connection.Open();//打开连接

SqlDataReader datareader;

datareader = userCommand.ExecuteReader();

return datareader;

}

返回一个SqlDataReader类型的值

2.返回单个字符

存储过程

ALTER  procedure MVC_getqiym

@yonghm varchar(50),

@qiy    varchar(50)  OUTPUT

as

set @qiy=(select Q.MingC From T_QiYXXB Q,T_YongHXXB Y

where Q.QiYBH=Y.QiYBH)

select @qiy

程序

public string getqiym(string yonghm)

{

string qiy;

SqlConnection userConnection = Connection.getConnection();

SqlCommand userCommand = new SqlCommand("MVC_getqiym", userConnection);

userCommand.CommandType = CommandType.StoredProcedure;//采用存储过程

userCommand.Parameters.Add("@yonghm", SqlDbType.VarChar, 50);//存储过程参数

userCommand.Parameters["@yonghm"].Value = yonghm;//给参数赋值

userCommand.Parameters.Add("@qiy",SqlDbType.VarChar,50);

userCommand.Parameters["@qiy"].Direction =ParameterDirection.Output;

userCommand.Connection.Open();//打开连接

try

{

userCommand.ExecuteScalar();

}

catch (SqlException ee)

{

throw(ee);

}

finally

{

userCommand.Connection.Close();

}

qiy = Convert.ToString(userCommand.Parameters["@qiy"].Value);

return qiy;

}

建议在存储过程使用output

return只能返回int类型的