listview中的分页和排序 [英] paging and sorting in listview

查看：44 发布时间：2019/6/17 14:39:10 Offtopic

本文介绍了listview中的分页和排序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

嗨..

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

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

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

PLz找到下面的代码。

代码背后：

&NBSP; &NBSP; &NBSP;

使用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

{

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

&NBSP; protected void Page_Load（object sender，EventArgs e）

&NBSP; {

&NBSP; &NBSP; &NBSP; if（！IsPostBack）

&NBSP; &NBSP; &NBSP; {

$
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; RadioButtonList1.SelectedValue =" 1";

&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; DataTable dt = new DataTable（）;

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

&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ListView1.DataSource = dt;

&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; ListView1.DataBind（）;

&NBSP; &NBSP; &NBSP; }

&NBSP; }

protected void DataPager1_PreRender1（object sender，EventArgs e）

&NBSP; {

&NBSP; &NBSP; &NBSP; 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
+"'" ;;

&NBSP; &NBSP; &NBSP; SqlCommand cmd = new SqlCommand（fetch，cn）;

&NBSP; &NBSP; &NBSP; SqlDataAdapter adp = new SqlDataAdapter（cmd）;

&NBSP; &NBSP; &NBSP; DataTable dt = new DataTable（）;

&NBSP; &NBSP; &NBSP; adp.Fill（dt）;

&NBSP; &NBSP; &NBSP; ListView1.DataSource = dt;

&NBSP; &NBSP; &NBSP; ListView1.DataBind（）;
$

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

&NBSP; {

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

&NBSP; }

.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。

解决方案

感谢您的发帖。

根据您的说法，我了解您的问题是关于ASP.Net，所以我在移动您的主题时，您可以在
http://forums.asp.net/ 上询问ASP.Net相关问题，以便您可以获得更好的支持。

感谢您的理解和支持。

祝您有个愉快的一天。

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>
 </td>
</tr>
<tr>
<td>
 </td>
</tr>
<tr>
<td>
 </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>
 </td>
</tr>
<tr>
<td>
 </td>
</tr>
</table>

</div>
<div class="sidebarnew1">
 
<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.

解决方案

Hi Smitha,

Thank you for your post.

According to your descirption, I understand your issue is about ASP.Net, so I'm moving your thread, you can ask ASP.Net relative questions at http://forums.asp.net/, so that you can get a better support.

Thank you for your understanding and support.

Have a nice day.

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

查看全文

listview中的分页和排序 [英] paging and sorting in listview

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

listview中的分页和排序 [英] paging and sorting in listview

问题描述

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭