listview中的分页和排序

问题描述

嗨..

我设计了一个产品展示网页，如电子商务网站所示。我决定在google搜索之后使用listview控件来了解我能展示产品的最佳方式。

在我的页面中使用4个radiobutton列表控件和listview控件与数据控件。

如果没有分页，则可以根据radiobutton列表中的选定项目获取已排序的产品列表。但是现在面临的问题是当我试图在listview中实现分页时，如果从其他
radiobutton列表控件中选择项目，则无法获得产品列表。

PLz找到下面的代码。

代码背后：

       

使用System;

使用System.Collections.Generic;

使用System.Linq;

使用System.Web ;
$
使用System.Web.UI;

使用System.Web.UI.WebControls;

使用System.Data;

使用System.Data.SqlClient;

使用System.Configuration;



公共部分类demolistview5：System.Web.UI .Page

{

    SqlConnection cn = new SqlConnection（ConfigurationManager.ConnectionStrings [" DatabasedemoConnectionString2"]。ConnectionString）;

    protected void Page_Load（object sender，EventArgs e）

    {

        if（！IsPostBack）

        {

$
            RadioButtonList1.SelectedValue =" 1";

            DataTable dt = new DataTable（）;

            string fetch =" select prod_id，prod_name，image，price，weight，rating from tb_product where animal_id ='" + RadioButtonList1.SelectedValue +"'" ;;

            ListView1.DataSource = dt;

            ListView1.DataBind（）;

        }


    }

protected void DataPager1_PreRender1（object sender，EventArgs e）

    {

        string fetch =" select prod_id，prod_name，price，weight，rating from tb_product where animal_id ='" + RadioButtonList1.SelectedValue +"'和brand_id ='" + RadioButtonList2.SelectedValue +"'，breed_id ='" + RadioButtonList3.SelectedValue
+"'" ;;

        SqlCommand cmd = new SqlCommand（fetch，cn）;

        SqlDataAdapter adp = new SqlDataAdapter（cmd）;

        DataTable dt = new DataTable（）;

        adp.Fill（dt）;

        ListView1.DataSource = dt;

        ListView1.DataBind（）;
$


    }¥b $ b    protected void ListView1_PagePropertiesChanging1（object sender，PagePropertiesChangingEventArgs e）

    {

        DataPager1.SetPageProperties（e.StartRowIndex，e.MaximumRows，false）;

    }

.aspx代码：

<％@ Page Language =" C＃" AutoEventWireup = QUOT;真"的CodeFile = QUOT; testingnew.aspx.cs"继承= QUOT; demolistview5" ％>



<！DOCTYPE html PUBLIC" - // W3C // DTD XHTML 1.0 Transitional // EN" "http：//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">



< html xmlns =" http ：//www.w3.org/1999/xhtml">

< head runat =" server">

  &NBSP; < title>< / title>

  &NBSP; < link href =" sampleStyleSheet.css"的rel ="样式表"类型= QUOT;文本/ CSS" />

  &NBSP; &NBSP;  <％ - < style type =" text / css">

  &NBSP; &NBSP; .productitem

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP;  宽度：140px;

  &NBSP; &NBSP; &NBSP; &NBSP;   float：left;

  &NBSP; &NBSP; &NBSP; &NBSP;  填充：5px;

  &NBSP; &NBSP; &NBSP; &NBSP;保证金：5px;

  &NBSP; &NBSP; &NBSP; &NBSP;   text-align：center;

  &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP;   

  &NBSP; &NBSP; &NBSP; .groupseparator

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; border-top：1px点缀灰色;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;身高：1px;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;清除：两者;

  &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP;   

  &NBSP; &NBSP; &NBSP; .itemseparator

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;身高：180px;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;宽度：1px;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; margin-top：5px;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; margin-bottom：5px;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; float：left;

  &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP;  < / style> - ％>

  &NBSP; < style type =" text / css">

  &NBSP; &NBSP; &NBSP; .style1

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;宽度：100％;

  &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; < / style>

< / head>

< body>

  &NBSP; < form id =" form1" runat =" server">

  &NBSP; < div>

  &NBSP; < div class =" sidebarnew">



  &NBSP; &NBSP; &NBSP; < table class =" style1">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; & nbsp;< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; & nbsp;< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; & nbsp;< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;动物类型< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：RadioButtonList ID =" RadioButtonList1" RUNAT = QUOT;服务器" AutoPostBack ="True" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;的DataSourceID = QUOT; SqlDataSource2" DataTextField = QUOT;名称" DataValueField = QUOT; A_ID"  

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; >

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：RadioButtonList>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：SqlDataSource ID =" SqlDataSource2" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ConnectionString ="<％$ ConnectionStrings：DatabasedemoConnectionString2％>" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; SelectCommand =" SELECT [A_id]，[name] FROM [tb_animal]">< / asp：SqlDataSource>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;品牌名称< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：RadioButtonList ID =" RadioButtonList2" RUNAT = QUOT;服务器" AutoPostBack ="True" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;的DataSourceID = QUOT; SqlDataSource3" DataTextField =" brand_name" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; DataValueField = QUOT; brand_id" onselectedindexchanged =" RadioButtonList2_SelectedIndexChanged" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; >

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：RadioButtonList>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：SqlDataSource ID =" SqlDataSource3" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ConnectionString ="<％$ ConnectionStrings：DatabasedemoConnectionString2％>" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; SelectCommand =" SELECT brand_name，brand_id FROM tb_brand WHERE（a_id = @a_id）">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < SelectParameters>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：ControlParameter ControlID =" RadioButtonList1"姓名=" a_id" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;属性名= QUOT;&的SelectedValue QUOT;类型="&的Int32 QUOT;默认值= QUOT;" />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / SelectParameters>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：SqlDataSource>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;品种尺寸< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：RadioButtonList ID =" RadioButtonList3" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;的DataSourceID = QUOT; SqlDataSource4" DataTextField =" breed_size" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; DataValueField = QUOT; breed_id" AutoPostBack ="True" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; >

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：RadioButtonList>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：SqlDataSource ID =" SqlDataSource4" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ConnectionString ="<％$ ConnectionStrings：DatabasedemoConnectionString2％>" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; SelectCommand =" SELECT [breed_id]，[breed_size] FROM [tb_breed] WHERE（[a_id] = @a_id）">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < SelectParameters>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：ControlParameter ControlID =" RadioButtonList1"姓名=" a_id" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;属性名= QUOT;&的SelectedValue QUOT;类型="&的Int32 QUOT; />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / SelectParameters>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：SqlDataSource>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;生命阶段< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：RadioButtonList ID =" RadioButtonList4" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;的DataSourceID = QUOT; SqlDataSource5" DataTextField =" stage_name" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; DataValueField = QUOT; stage_id" AutoPostBack ="True" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; >

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：RadioButtonList>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：SqlDataSource ID =" SqlDataSource5" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ConnectionString ="<％$ ConnectionStrings：DatabasedemoConnectionString2％>" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; SelectCommand =" SELECT [stage_id]，[stage_name] FROM [tb_lifestage] WHERE（[a_id] = @a_id）">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < SelectParameters>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：ControlParameter ControlID =" RadioButtonList1"姓名=" a_id" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;属性名= QUOT;&的SelectedValue QUOT;类型="&的Int32 QUOT; />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / SelectParameters>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：SqlDataSource>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; & nbsp;< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < tr>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; & nbsp;< / td>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / tr>

  &NBSP; &NBSP; &NBSP; < / table>



  &NBSP; < / div> 

   < div class =" sidebarnew1">

  &NBSP; &NBSP; &NBSP; & nbsp;

  &NBSP; &NBSP; &NBSP; < asp：DataPager ID =" DataPager1" RUNAT = QUOT;服务器" PagedControlID =" ListView1" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;每页= QUOT; 2英寸onprerender =" DataPager1_PreRender1">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; <字段>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：NumericPagerField />

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / Fields>

  &NBSP; &NBSP; &NBSP; < / asp：DataPager>

  &NBSP; &NBSP; &NBSP; < br />

  &NBSP; &NBSP; &NBSP; < asp：ListView ID =" ListView1" runat =" server" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; onpagepropertieschanging =" ListView1_PagePropertiesChanging1" 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ViewStateMode =" Enabled">

  &NBSP; &NBSP; &NBSP; < ItemTemplate>

  &NBSP; &NBSP; &NBSP; < div>< img src =" pictureHandler.ashx？prod_id =<％＃Eval（" prod_id"）。ToString（）％>" ALT ="喜"宽度= QUOT; 120"高度= QUOT; 120" />< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;< DIV> < b>名称：<％＃Eval（" prod_name"）％>< / b>< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < div>价格：$<％＃Eval（" price"）％>< / div> 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < div> KG中的重量：<％＃Eval（" weight"）％>< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < div>评分：<％＃Eval（" rating"）％>< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; < / ItemTemplate>

  &NBSP; &NBSP; &NBSP; &NBSP; < AlternatingItemTemplate>

  &NBSP; &NBSP; &NBSP; &NBSP; < div>< img src =" pictureHandler.ashx？prod_id =<％＃Eval（" prod_id"）。ToString（）％>" ALT ="喜"宽度= QUOT; 120"高度= QUOT; 120" />< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;< DIV> < b>名称：<％＃Eval（" prod_name"）％>< / b>< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < div>价格：$<％＃Eval（" price"）％>< / div> 

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < div> KG中的重量：<％＃Eval（" weight"）％>< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < div>评分：<％＃Eval（" rating"）％>< / div>

  &NBSP; &NBSP; &NBSP; &NBSP; < / AlternatingItemTemplate>

  &NBSP; &NBSP; &NBSP; < / asp：ListView>

  &NBSP; &NBSP; &NBSP; < br />



  &NBSP; &NBSP; &NBSP; < / div>

  &NBSP; &NBSP;   

  &NBSP; < / div>

    

  &NBSP; < / form>

< / body>

< / html>

如果我的方法是正确的，可以Any1提供一些指导吗？

感谢您的帮助。

谢谢，

Smitha。

解决方案

Hi..

I have designed a product display  web page as seen in ecommerce sites. I have decided to use listview control after some google search about the best way wher i can display products.

In my page m using a 4 radiobutton list controls and listview control with datapaer control.

Without paging m able to get the sorted product list depending on the selected item in the radiobutton list. But the problem m facing now is when m trying to implement paging in the listview m not able to get the products list if m selecting items from other radiobutton list controls.

PLz find the code below.

code behind:

       

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class demolistview5 : System.Web.UI.Page
{
    SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabasedemoConnectionString2"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            RadioButtonList1.SelectedValue = "1";
            DataTable dt = new DataTable();
            string fetch = "select prod_id,prod_name,image,price,weight,rating from tb_product where animal_id='" + RadioButtonList1.SelectedValue +"'";
            ListView1.DataSource = dt;
            ListView1.DataBind();
        }

    }

protected void DataPager1_PreRender1(object sender, EventArgs e)
    {
        string fetch = "select prod_id,prod_name,price,weight,rating from tb_product where animal_id='" + RadioButtonList1.SelectedValue + "' and brand_id='" + RadioButtonList2.SelectedValue + "', breed_id='" + RadioButtonList3.SelectedValue + "'";
        SqlCommand cmd = new SqlCommand(fetch, cn);
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        ListView1.DataSource = dt;
        ListView1.DataBind();

    }
    protected void ListView1_PagePropertiesChanging1(object sender, PagePropertiesChangingEventArgs e)
    {
        DataPager1.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
    }

.aspx code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testingnew.aspx.cs" Inherits="demolistview5" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="sampleStyleSheet.css" rel="stylesheet" type="text/css" />
       <%--<style type="text/css">
      .productitem
        {
           width:140px;
           float:left;
           padding:5px;
           margin:5px;
           text-align:center;
        }
        
        .groupseparator
        {
            border-top:1px dotted gray;
            height:1px;
            clear:both;
        }
        
        .itemseparator
        {
            height: 180px;
            width: 1px;
            margin-top: 5px;
            margin-bottom: 5px;
            float: left;
        }
       </style>--%>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <div class="sidebarnew">

        <table class="style1">
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    Animal Type</td>
            </tr>
            <tr>
                <td>
                    <asp:RadioButtonList ID="RadioButtonList1" runat="server" AutoPostBack="True" 
                        DataSourceID="SqlDataSource2" DataTextField="name" DataValueField="A_id"  
                        >
                      
                    </asp:RadioButtonList>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:DatabasedemoConnectionString2 %>" 
                        SelectCommand="SELECT [A_id], [name] FROM [tb_animal]"></asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>
                    Brand Name</td>
            </tr>
            <tr>
                <td>
                    <asp:RadioButtonList ID="RadioButtonList2" runat="server" AutoPostBack="True" 
                        DataSourceID="SqlDataSource3" DataTextField="brand_name" 
                        DataValueField="brand_id" onselectedindexchanged="RadioButtonList2_SelectedIndexChanged" 
                        >
                    </asp:RadioButtonList>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:DatabasedemoConnectionString2 %>" 
                        
                        
                        SelectCommand="SELECT brand_name, brand_id FROM tb_brand WHERE (a_id = @a_id)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="RadioButtonList1" Name="a_id" 
                                PropertyName="SelectedValue" Type="Int32" DefaultValue="" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>
                    Breed Size</td>
            </tr>
            <tr>
                <td>
                    <asp:RadioButtonList ID="RadioButtonList3" runat="server" 
                        DataSourceID="SqlDataSource4" DataTextField="breed_size" 
                        DataValueField="breed_id" AutoPostBack="True" 
                        >
                    </asp:RadioButtonList>
                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:DatabasedemoConnectionString2 %>" 
                        SelectCommand="SELECT [breed_id], [breed_size] FROM [tb_breed] WHERE ([a_id] = @a_id)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="RadioButtonList1" Name="a_id" 
                                PropertyName="SelectedValue" Type="Int32" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>
                    Life Stage</td>
            </tr>
            <tr>
                <td>
                    <asp:RadioButtonList ID="RadioButtonList4" runat="server" 
                        DataSourceID="SqlDataSource5" DataTextField="stage_name" 
                        DataValueField="stage_id" AutoPostBack="True" 
                        >
                    </asp:RadioButtonList>
                    <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:DatabasedemoConnectionString2 %>" 
                        SelectCommand="SELECT [stage_id], [stage_name] FROM [tb_lifestage] WHERE ([a_id] = @a_id)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="RadioButtonList1" Name="a_id" 
                                PropertyName="SelectedValue" Type="Int32" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>
                    &nbsp;</td>
            </tr>
        </table>

    </div> 
   <div class="sidebarnew1">
        &nbsp;
        <asp:DataPager ID="DataPager1" runat="server" PagedControlID="ListView1" 
            PageSize="2" onprerender="DataPager1_PreRender1">
            <Fields>
                <asp:NumericPagerField />
            </Fields>
        </asp:DataPager>
        <br />
        <asp:ListView ID="ListView1" runat="server" 
            onpagepropertieschanging="ListView1_PagePropertiesChanging1" 
            ViewStateMode="Enabled">
        <ItemTemplate>
        <div><img src="pictureHandler.ashx?prod_id=<%# Eval("prod_id").ToString() %>" alt="hi" width="120" height="120" /></div>
             <div> <b>Name :<%# Eval("prod_name")%></b></div>
             <div>Price :$<%# Eval("price") %></div> 
             <div>Weight in KG :<%# Eval("weight")%></div>
             <div>Rating :<%#Eval("rating")%></div>
          </ItemTemplate>
          <AlternatingItemTemplate>
          <div><img src="pictureHandler.ashx?prod_id=<%# Eval("prod_id").ToString() %>" alt="hi" width="120" height="120" /></div>
             <div> <b>Name :<%# Eval("prod_name")%></b></div>
             <div>Price :$<%# Eval("price") %></div> 
             <div>Weight in KG :<%# Eval("weight")%></div>
             <div>Rating :<%#Eval("rating")%></div>
          </AlternatingItemTemplate>
        </asp:ListView>
        <br />

        </div>
        
    </div>
    
    </form>
</body>
</html>

Can Any1 provide some guidance if my approach is correct ?

Your help is appreciated.

Thanks,

Smitha.

解决方案

这篇关于listview中的分页和排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！