如何给这个存储过程（带参数的）传递参数

[coverallwangp]

CREATE PROCEDURE pro_allgoods_ss
@sf_name nvarchar(50),
@ss_name nvarchar(50)
 AS
select gi_id,bs_name,(case when len(gi_title)>= 25 then left(gi_title,25)+'...' else gi_title end) as gi_title,ss_name,gi_price,gi_click,convert(varchar(10),gi_date,120) as gi_date,gi_time
from vw_allgoods
where gs_id=2 and sf_name=@sf_name and ss_name=@ss_name

我在GridView绑定数据源时，使用了上述存储过程，请问该如何给这两个参数赋值呢？我想把别的页面传过来的参数值（querystring）赋给存储过程的那两个参数

[wuyq11]

SqlParameter[] paras= new SqlParameter[]{
new SqlParameter ("@sf_name",SqlDbType.NVarChar,50),
new SqlParameter ("@ss_name",SqlDbType.NVarChar,50)};
paras[0].Value = "";
paras[1].Value = "";

[Passage2011]

protected void Page_Load(object sender, EventArgs e)
    {
       if(!ispostback)
{
this.GV.DataSource=CreateDataSource('','')
this.GV.DataBind()
}
     }
protected DataSet CreateDataSource(string a string b)
    {
 //string strConn = ConfigurationManager.ConnectionStrings["PageConn"].ConnectionString.ToString();
        string strConn = @"Data Source=192.168.0.230;Initial Catalog=Poultry;UID=sa;PWD=atl";
        SqlConnection conn = new SqlConnection(strConn);
        //声明执行存储过程的SqlCommand     
        SqlCommand scd_sel = new SqlCommand("pro_allgoods_ss", conn);
        scd_sel.CommandType = CommandType.StoredProcedure;
        //给存储过程的参数赋值   
        SqlParameter spa;
        spa = scd_sel.Parameters.Add("@sf_name", SqlDbType.VarChar,50);
        spa.Direction = ParameterDirection.Input;
        spa.Value = a;
        spa = scd_sel.Parameters.Add("@ss_name", SqlDbType.VarChar,50);
        spa.Direction = ParameterDirection.Input;
        spa.Value = b;
        //执行存储过程   
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = scd_sel;
        if (conn.State == ConnectionState.Closed)
            conn.Open();
        DataSet ds = new DataSet();
        sda.Fill(ds, "tb1");
        return ds;
        conn.Close();
    }

[一切为了你]

[Quote=引用楼主 coverallwangp 的回复:]
SQL code

CREATE PROCEDURE pro_allgoods_ss
@sf_name nvarchar(50),
@ss_name nvarchar(50)
AS
select gi_id,bs_name,(case when len(gi_title)>= 25 then left(gi_title,25)+'...' else gi_title end) as ……
[/Quote] 这个够用了，！！！！！！！

[天下在我心]

SqlCommand cmd=new SqlCommand("pro_allgoods_ss", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sf_name", SqlDbType.VarChar,100).Value=Request.QueryString["a"].ToString();
cmd.Parameters.Add("@ss_name", SqlDbType.VarChar,100).Value=Request.QueryString["b"].ToString();
.....

这样就可以了

[xray2005]

SqlCommand cmd=new SqlCommand("pro_allgoods_ss", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sf_name", SqlDbType.VarChar,100).Value=Request.QueryString["a"].ToString();
cmd.Parameters.Add("@ss_name", SqlDbType.VarChar,100).Value=Request.QueryString["b"].ToString();

[coverallwangp]

Thank!

[coverallwangp]

Thank u all.