AspnetPage 用存储过程分页 提示未找到存储过程

[Kevin_xun]

AspNetPage用存储过程分页但是提示找不到存储过程（数据库中有），下面是代码：
P_Table_Count、P_Tabel_List这两个是存储过程
能找到P_Table_Count,P_Table_List这里就跳异常了

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindData();
        }
    }

protected void BindData()
    {
        int totalOrders = (int)SqlHelp.ExecuteScalar(CommandType.StoredProcedure,"P_Table_Count",
        new SqlParameter("@tablename","SXWY_B_Stocks"),
        new SqlParameter("@where",sSql),
        new SqlParameter("@cell","Id"));
        AspNetPager1.RecordCount = totalOrders;

        repeater.DataSource = SqlHelp.ExecuteReader(CommandType.StoredProcedure, "P_Tabel_List",
        new SqlParameter("@startIndex", AspNetPager1.StartRecordIndex),
        new SqlParameter("@endIndex", AspNetPager1.StartRecordIndex + AspNetPager1.PageSize - 1),
        new SqlParameter("@where", sSql),
        new SqlParameter("@topnum", "0"),
        new SqlParameter("@tablename", "SXWY_B_Stocks"),
        new SqlParameter("@cell", "Id"),
        new SqlParameter("@OrderWay", "desc"));
        repeater.DataBind();
    }

    protected void AspNetPager1_PageChanged(object src, EventArgs e)
    {
        BindData();
    }

执行P_Table_List这个存储过程就跳到下面方法里的异常，提示未找到存储过程

        public static SqlDataReader ExecuteReader(CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
        {
            SqlCommand cmd = new SqlCommand();
            SqlConnection conn = new SqlConnection(ConString);

            // we use a try/catch here because if the method throws an exception we want to 
            // close the connection throw code, because no datareader will exist, hence the 
            // commandBehaviour.CloseConnection will not work
            try
            {
                PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
                SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                cmd.Parameters.Clear();
                return rdr;
            }
            catch
            {
                conn.Close();
                throw;//跳到这里了
            }
        }

[吴青峰]

那应该是你那个地方传参数错了。

[lspzengjing1989]

[Quote=引用 1 楼 qingfeng_wu 的回复:]

那应该是你那个地方传参数错了。
[/Quote]
先把存储过程到了T-SQL里执行下

[Kevin_xun]

[Quote=引用 2 楼 lspzengjing1989 的回复:]
引用 1 楼 qingfeng_wu 的回复:

那应该是你那个地方传参数错了。

先把存储过程到了T-SQL里执行下
[/Quote]

ALTER PROCEDURE [dbo].[P_Table_List]
(@startIndex INT,
@endIndex INT,
@where varchar(2000),
@topnum int,
@tablename varchar(50),
@cell varchar(20)
)
AS
begin

if @topnum<>0

exec ('SELECT top '+@topnum+' * from
(SELECT ROW_NUMBER() OVER (order by '+@cell+' desc) as Row,* from '+@tablename+' '+@where+') as orderList
WHERE Row between '+@startIndex+' and '+@endIndex+'')

else
exec ('SELECT * from
(SELECT ROW_NUMBER() OVER (order by '+@cell+' desc) as Row,* from '+@tablename+' '+@where+') as orderList
WHERE Row between '+@startIndex+' and '+@endIndex+'')

end

你看看这个存储过程有错吗

[lspzengjing1989]

你自己在T-SQL里面传参执行下

[hua_lanyu]

怎么这么麻烦啊，看不懂，学习！！！

[linsx1987]

"P_Tabel_List" == [dbo].[P_Table_List]？？？？？？？？

[zuoming120]

你用这个控件了，还用存储过程？，真是有才，

[linsx1987]

"P_Table_Count"== [dbo].[P_Table_List]？？？？？？？？

刚发错了~~

[自然框架]

分个页还这么麻烦，还弄存储过程，看看这个

http://topic.csdn.net/u/20101028/17/fafbba23-d5c3-47ef-8bfa-bac05634210a.html

http://topic.csdn.net/u/20101026/09/d7939d63-f02d-4dfa-a809-77d72f7b9537.html