asp.net 调用存储过程有关问题.

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER procedure  [dbo].[Sel](@whereStr varchar(100),--根据那个字段查询@selStr varchar(100) --查询内容)as declare @sql varchar(100)if (@whereStr='' or @selStr='')beginset @sql='select * from bjx_zt order by id desc'endelsebeginset @sql='select * from bjx_Zt where '+@whereStr+' like ''%'+@selStr+'%'' order by id desc'endprint @sqlexec(@sql)

        SQLHelper.getConnection();        Hashtable hashtable = new Hashtable();        hashtable.Add("@whereStr", "title");        hashtable.Add("@selStr", "测试");        var test = SQLHelper.GetDTSP("Sel", hashtable);

 /// <summary>    /// 根据条件返回指定存储过程的DataTable    /// </summary>    /// <param name="spName">存储过程的名称</param>    /// <param name="ht">哈希表[存储过程中的变量名][value:值]</param>    /// <returns></returns>    public static DataTable GetDTSP(string spName, Hashtable ht)    {        DataTable datatable = new DataTable();        SqlDataAdapter da = new SqlDataAdapter();        try        {            using (SqlConnection connection = new SqlConnection(StrConn))            {                using (SqlCommand cmd = new SqlCommand(spName, connection))                {                    try                    {                        connection.Open();                        cmd.CommandType = CommandType.StoredProcedure;                        SqlParameter[] prams = new SqlParameter[ht.Count];                        int i = 0;                        foreach (DictionaryEntry objDe in ht)                        {                            prams[i] = new SqlParameter(objDe.Key.ToString(), objDe.Value.ToString());                            i++;                        }                        // 依次把参数传入命令文本                        foreach (SqlParameter parameter in prams)                        {                            cmd.Parameters.Add(parameter);                        }                        da.SelectCommand = cmd;                        da.Fill(datatable);                    }                    catch                    {                        connection.Close();                    }                }            }        }        catch { }        return datatable;    }