aspnetpage分页后对内容分类

[zhmjppp]

我是新手，首先我实现了对datalist通过aspnetpage分页，想在此基础上增加分类，通过DropDownList控件（值为数字），出现向对应分类，我弄了下后，类别是正确，相对应类别读取的数量是正确的，但显示的出的信息，只是在此数量里按原datalist列表里相对应类别的东西，并不是完全的。求帮助！





UI层

    protected void Page_Load(object sender, EventArgs e)
    {

            int totalProduct = (int)SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "P_GetProductNumber", new SqlParameter("@cid ", Convert.ToInt32( DropDownList1.Text)));
            AspNetPager1.RecordCount = totalProduct; 
            bindData();

       
    }
    void bindData()
    {
        DataList1.DataSource = SqlHelper.ExecuteReader(CommandType.StoredProcedure, ConfigurationManager.AppSettings["pagedSPName"],
                new SqlParameter("@startIndex", AspNetPager1.StartRecordIndex), 
                   new SqlParameter("@endIndex", AspNetPager1.EndRecordIndex),
                      new SqlParameter("@cid ", Convert.ToInt32(DropDownList1.Text)));
        DataList1.DataBind();
    }

    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        bindData(); 
    }

web.config : <add key="pagedSPName" value="P_GetPagedProduct"/>


两个存储过程

ALTER PROCEDURE P_GetPagedProduct
(@startIndex int,
@endIndex int,
@cid int
)
as
set nocount on
declare @indextable table(id int identity(1,1),nid int)  --定义一个table型的变量 
set rowcount @endIndex
if @cid=0
begin

insert into @indextable(nid) select Pid from Products  order by Pid desc
select Pid,Price,img,[Name]
from Products p
inner join @indextable t on 
p.Pid=t.nid
 where
 t.id between @startIndex and @endIndex    order by t.id 
set nocount off
end
else
begin

insert into @indextable(nid) select Pid from Products  order by Pid desc
select Pid,Price,img,[Name]
from Products p
inner join @indextable t on 
p.Pid=t.nid
 where cid=@cid and
 t.id between @startIndex and @endIndex    order by t.id 
set nocount off
end


	RETURN

ALTER PROCEDURE P_GetProductNumber
@cid int 
AS
if @cid = 0  	
	begin
	select count(Pid) from Products where 1=1  ;
	end
else 
begin
select count(Pid) from Products where 1=1 and cid=@cid ;
end
	RETURN

[zhmjppp]

求救a。。。

[generhappy]

我弄了下后，类别是正确，相对应类别读取的数量是正确的，但显示的出的信息，只是在此数量里按原datalist列表里相对应类别的东西，并不是完全的

没太懂，啥意思？？

[wuyq11]

根据类别参数查询数据
if(!IsPostBack)
{
BindData();
}
DropDownList1.SeletedValue==null?0:Convert.ToInt32(DropDownList1.Text);
if @cid>0
set @sql=@sql+' ...'

[happy664618843]

foreach(DataListItem item in DataList1.Items){
DropDownList drop=item.FindControl() as DropDownList;
}
//在droplist onchanged事件中:
DropDownList drop=sender as DropDownList;
DataListItem dlitem=drop.parent.parent as DataListItem;

[zhmjppp]

[Quote=引用 2 楼 generhappy 的回复:]
我弄了下后，类别是正确，相对应类别读取的数量是正确的，但显示的出的信息，只是在此数量里按原datalist列表里相对应类别的东西，并不是完全的

没太懂，啥意思？？
[/Quote]


Cid是一个产品表里的字段，通过Cid来分类

运行后，通过DropDownList选出来的类别，如果原来分页第一页有的，就有，第一页没有，那些产品就不会显示出来

[zhmjppp]

没人哦...