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類型的