let it be
行到水穷处 坐看云起时

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

posted on 2007-06-11 11:26  流浪浪  阅读(2091)  评论(1编辑  收藏  举报