调用存储过程返回字条串

 private void loadGrv()
    {
        string pr = "", strsql = "";int reqstr = 0;
        if (Request.QueryString["id"] != null)
        {
            reqstr = Convert.ToInt32(Request.QueryString["id"]);
            pr = "pr_get_flids";
       }
        else if (Request.QueryString["bid"] != null)
        {
            reqstr = Convert.ToInt32(Request.QueryString["bid"]);
            pr = "pr_get_deptids";
        }
        SqlConnection sqlconnection = new SqlConnection("server=.;database=gcnet;uid=sa;pwd=lzly;");
        sqlconnection.Open();
        SqlCommand com = new SqlCommand(pr, sqlconnection);
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.Add(new SqlParameter("@fid", SqlDbType.Int, 4));
        com.Parameters["@fid"].Value = reqstr;
        com.Parameters.Add(new SqlParameter("@returns", SqlDbType.VarChar, 200));
        com.Parameters["@returns"].Direction = ParameterDirection.Output;
        string aa = com.CommandText;
        com.ExecuteNonQuery();
        string getStr = com.Parameters["@returns"].Value.ToString();
        if (Request.QueryString["id"] != null)
        {
            strsql = "select 资产编号,资产名称,mc,建卡日期,dwmc,deptmc,原值,净值,数量,标志,xm,录入日期,id from gdzc_sx where 标志=0 and 分类编号 in (" + getStr + ") order by 分类编号,录入日期";
        }
        else if (Request.QueryString["bid"] != null)
        {
            strsql = "select 资产编号,资产名称,mc,建卡日期,dwmc,deptmc,原值,净值,数量,标志,xm,录入日期,id from gdzc_sx where 标志=0 and 部门编号 in (" + getStr + ") order by 部门编号,录入日期";
        }
        sqlconnection.Close();
        ViewState["sql"] = strsql;
        DataTable dt = sqlhelp.getDataTableBySql(strsql);
        this.RepeaterPaping1.RepeaterDataBinds(dt, GridView1, 20);
        if (GridView1.Rows.Count <= 0)
            this.RepeaterPaping1.Visible = false;
        else
            this.RepeaterPaping1.Visible = true;
    }