Repeater 双向排序

本文介绍如何为ASP.NET中的Repeater控件实现双向排序功能。通过使用LinkButton、ViewState及Cache等技术,实现在不更换控件的情况下增加排序功能。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

做项目的时候,DataGrid ,DataList,Repeater 三个控件都是很优秀的数据显示控件,DataGrid的方便,简单易用,功能强大,但对性能会有所影响,在loading页面的时候大量的Html会占用一些时间,DataList 较之DataGrid功能显然减少一些,经常在一些特殊的页面制作或需求中来用,经常简单的页面显示收据表格,使用Repeater+Table即方便又快捷,但是却没有DataGrid那样方便,最近做项目,全部使用Repeater,但是客户突然要求要对数据表格进行排序,惨了~~~~~,第一印象就是DataGrid控件有排序功能,要换控件吗?靠,那么多表单,全部换DataGrid会出人命,于是就想办法,来实现Repeater的排序。下面就是我做的一个Repeater实现双向排序的例子:主要使用LinkButton,Repeater,ViewState,Cache结合来完成的。
效果如下图:

下载原代码: /Files/vaiyanzi/Attch/RepeaterOrder.rar
前台Html代码:
<% @ Page language="c#" Codebehind="RepeaterOrderForm.aspx.cs" AutoEventWireup="false" Inherits="RepeaterOrder.RepeaterOrderForm"  %>
None.gif
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"  >
None.gif
< HTML >
None.gif    
< HEAD >
None.gif        
< title > RepeaterOrderForm </ title >
None.gif        
< meta  name ="GENERATOR"  Content ="Microsoft Visual Studio .NET 7.1" >
None.gif        
< meta  name ="CODE_LANGUAGE"  Content ="C#" >
None.gif        
< meta  name ="vs_defaultClientScript"  content ="JavaScript" >
None.gif        
< meta  name ="vs_targetSchema"  content ="http://schemas.microsoft.com/intellisense/ie5" >
None.gif    
</ HEAD >
None.gif    
< body  MS_POSITIONING ="GridLayout" >
None.gif        
< form  id ="Form1"  method ="post"  runat ="server" >
None.gif            
< table  border =1  bordercolor =#330033  bordercolordark =#999933  bordercolorlight =black >
None.gif            
< tr >
None.gif            
< td  colspan =5  align =center >< font  color =blue  size =12 > Repeater实现双向排序功能 </ font ></ td >
None.gif            
</ tr >
None.gif                
< asp:Repeater  id ="rpOrder"  runat ="server" >
None.gif                    
< HeaderTemplate >
None.gif                        
< tr  align =center  >
None.gif                            
< td >
None.gif                                
< asp:LinkButton  ID ="LastName"  Runat ="server"  text ="LastName"  CommandName ="LastName" ></ asp:LinkButton ></ td >
None.gif                            
< td >
None.gif                                
< asp:LinkButton  ID ="FirstName"  Runat ="server"  text ="FirstName"  CommandName ="FirstName" ></ asp:LinkButton ></ td >
None.gif                            
< td >
None.gif                                
< asp:LinkButton  ID ="Title"  Runat ="server"  text ="Title"  CommandName ="Title" ></ asp:LinkButton ></ td >
None.gif                            
< td >
None.gif                                
< asp:LinkButton  ID ="Address"  Runat ="server"  text ="Address"  CommandName ="Address" ></ asp:LinkButton ></ td >
None.gif                            
< td >
None.gif                                
< asp:LinkButton  ID ="City"  Runat ="server"  text ="City"  CommandName ="City" ></ asp:LinkButton ></ td >
None.gif                            
None.gif                        
</ tr >
None.gif                    
</ HeaderTemplate >
None.gif                    
< ItemTemplate >
None.gif                        
< tr >
ExpandedBlockStart.gifContractedBlock.gif                            
< td > <% dot.gif # DataBinder.Eval(Container.DataItem,"LastName") %> </ td >
ExpandedBlockStart.gifContractedBlock.gif                            
< td > <% dot.gif # DataBinder.Eval(Container.DataItem,"FirstName") %> </ td >
ExpandedBlockStart.gifContractedBlock.gif                            
< td > <% dot.gif # DataBinder.Eval(Container.DataItem,"Title") %> </ td >
ExpandedBlockStart.gifContractedBlock.gif                            
< td > <% dot.gif # DataBinder.Eval(Container.DataItem,"Address") %> </ td >
ExpandedBlockStart.gifContractedBlock.gif                            
< td > <% dot.gif # DataBinder.Eval(Container.DataItem,"City") %> </ td >                             
None.gif                        
</ tr >
None.gif                    
</ ItemTemplate >
None.gif                
</ asp:Repeater >
None.gif            
</ table >
None.gif        
</ form >
None.gif    
</ body >
None.gif
</ HTML >
None.gif
后台CS文件:
ContractedBlock.gif ExpandedBlockStart.gif
  1None.gifusing System;
  2None.gifusing System.Collections;
  3None.gifusing System.ComponentModel;
  4None.gifusing System.Data;
  5None.gifusing System.Drawing;
  6None.gifusing System.Web;
  7None.gifusing System.Web.SessionState;
  8None.gifusing System.Web.UI;
  9None.gifusing System.Web.UI.WebControls;
 10None.gifusing System.Web.UI.HtmlControls;
 11None.gifusing System.Data.SqlClient;
 12None.gifusing System.Configuration;
 13None.gif
 14None.gifnamespace RepeaterOrder
 15ExpandedBlockStart.gifContractedBlock.gifdot.gif{
 16ExpandedSubBlockStart.gifContractedSubBlock.gif    /**//// <summary>
 17InBlock.gif    /// RepeaterOrderForm 的摘要说明。
 18ExpandedSubBlockEnd.gif    /// </summary>

 19InBlock.gif    public class RepeaterOrderForm : System.Web.UI.Page
 20ExpandedSubBlockStart.gifContractedSubBlock.gif    dot.gif{
 21InBlock.gif        protected System.Web.UI.WebControls.Repeater rpOrder;
 22InBlock.gif        private readonly string CONNECTIONSTRING=ConfigurationSettings.AppSettings["ConnectionString"];
 23InBlock.gif        private void Page_Load(object sender, System.EventArgs e)
 24ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
 25InBlock.gif            if(!IsPostBack)
 26ExpandedSubBlockStart.gifContractedSubBlock.gif            dot.gif{
 27InBlock.gif                BindRepeater();
 28ExpandedSubBlockEnd.gif            }

 29ExpandedSubBlockEnd.gif        }

 30InBlock.gif        private DataView GetData
 31ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
 32InBlock.gif            get
 33ExpandedSubBlockStart.gifContractedSubBlock.gif            dot.gif
 34InBlock.gif                return Cache["_data"as DataView;
 35ExpandedSubBlockEnd.gif            }

 36InBlock.gif            set
 37ExpandedSubBlockStart.gifContractedSubBlock.gif            dot.gif{
 38InBlock.gif                if( Cache["_data"]==null)
 39InBlock.gif                    Cache["_data"]=value;
 40ExpandedSubBlockEnd.gif            }

 41ExpandedSubBlockEnd.gif        }

 42ContractedSubBlock.gifExpandedSubBlockStart.gif        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 43InBlock.gif        override protected void OnInit(EventArgs e)
 44ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
 45InBlock.gif            //
 46InBlock.gif            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 47InBlock.gif            //
 48InBlock.gif            InitializeComponent();
 49InBlock.gif            base.OnInit(e);
 50ExpandedSubBlockEnd.gif        }

 51InBlock.gif        
 52ExpandedSubBlockStart.gifContractedSubBlock.gif        /**//// <summary>
 53InBlock.gif        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 54InBlock.gif        /// 此方法的内容。
 55ExpandedSubBlockEnd.gif        /// </summary>

 56InBlock.gif        private void InitializeComponent()
 57ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{    
 58InBlock.gif            this.Load += new System.EventHandler(this.Page_Load);
 59InBlock.gif            this.rpOrder.ItemCommand+=new RepeaterCommandEventHandler(rpOrder_ItemCommand);
 60InBlock.gif            this.rpOrder.ItemDataBound+=new RepeaterItemEventHandler(rpOrder_ItemDataBound);
 61InBlock.gif
 62ExpandedSubBlockEnd.gif        }

 63ExpandedSubBlockEnd.gif        #endregion

 64InBlock.gif
 65InBlock.gif        private SqlConnection Conn()
 66ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
 67InBlock.gif            return new SqlConnection(CONNECTIONSTRING);
 68ExpandedSubBlockEnd.gif        }

 69InBlock.gif
 70InBlock.gif        private void BindRepeater()
 71ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
 72InBlock.gif            DataSet ds=new DataSet();
 73InBlock.gif            SqlDataAdapter da=new SqlDataAdapter("Select * From Employees",Conn());
 74InBlock.gif            da.Fill(ds);
 75InBlock.gif            GetData=ds.Tables[0].DefaultView;
 76InBlock.gif            rpOrder.DataSource=ds.Tables[0];
 77InBlock.gif            rpOrder.DataBind();
 78ExpandedSubBlockEnd.gif        }

 79InBlock.gif
 80InBlock.gif        private void rpOrder_ItemCommand(object source, RepeaterCommandEventArgs e)
 81ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
 82InBlock.gif            if(e.Item.ItemType==ListItemType.Header)
 83ExpandedSubBlockStart.gifContractedSubBlock.gif            dot.gif{            
 84InBlock.gif                LinkButton lkbtnSort=(LinkButton)e.Item.FindControl(e.CommandName.Trim());                
 85InBlock.gif                if(ViewState[e.CommandName.Trim()]==null)
 86ExpandedSubBlockStart.gifContractedSubBlock.gif                dot.gif{
 87InBlock.gif                    ViewState[e.CommandName.Trim()]="ASC";                            
 88InBlock.gif                    lkbtnSort.Text=lkbtnSort.Text+"";
 89ExpandedSubBlockEnd.gif                }

 90InBlock.gif                else
 91ExpandedSubBlockStart.gifContractedSubBlock.gif                dot.gif{
 92InBlock.gif                    if(ViewState[e.CommandName.Trim()].ToString().Trim()=="ASC")
 93ExpandedSubBlockStart.gifContractedSubBlock.gif                    dot.gif{
 94InBlock.gif                        ViewState[e.CommandName.Trim()]="DESC";    
 95InBlock.gif                        if(lkbtnSort.Text.IndexOf("")!=-1)
 96InBlock.gif                            lkbtnSort.Text=lkbtnSort.Text.Replace("","");
 97InBlock.gif                        else
 98InBlock.gif                            lkbtnSort.Text=lkbtnSort.Text+"";
 99ExpandedSubBlockEnd.gif                    }

100InBlock.gif                    else
101ExpandedSubBlockStart.gifContractedSubBlock.gif                    dot.gif{
102InBlock.gif                        ViewState[e.CommandName.Trim()]="ASC";    
103InBlock.gif                        if(lkbtnSort.Text.IndexOf("")!=-1)
104InBlock.gif                            lkbtnSort.Text=lkbtnSort.Text.Trim().Replace("","");
105InBlock.gif                        else
106InBlock.gif                            lkbtnSort.Text=lkbtnSort.Text+"";
107ExpandedSubBlockEnd.gif                    }

108ExpandedSubBlockEnd.gif                }

109InBlock.gif                ViewState["text"]=lkbtnSort.Text;
110InBlock.gif                ViewState["id"]=e.CommandName.Trim();
111InBlock.gif                DataView dv=GetData;
112InBlock.gif                dv.Sort=e.CommandName.ToString().Trim()+" "+ViewState[e.CommandName.Trim()].ToString().Trim();
113InBlock.gif                rpOrder.DataSource=dv;
114InBlock.gif                rpOrder.DataBind();
115ExpandedSubBlockEnd.gif            }
            
116ExpandedSubBlockEnd.gif        }

117InBlock.gif
118InBlock.gif        private void rpOrder_ItemDataBound(object sender, RepeaterItemEventArgs e)
119ExpandedSubBlockStart.gifContractedSubBlock.gif        dot.gif{
120InBlock.gif            if(e.Item.ItemType==ListItemType.Header)
121ExpandedSubBlockStart.gifContractedSubBlock.gif            dot.gif{
122InBlock.gif                if(ViewState["id"]!=null)
123ExpandedSubBlockStart.gifContractedSubBlock.gif                dot.gif{                    
124InBlock.gif                    LinkButton lkbtnSort=(LinkButton)e.Item.FindControl(ViewState["id"].ToString().Trim());                        
125InBlock.gif                    lkbtnSort.Text=ViewState["text"].ToString();
126ExpandedSubBlockEnd.gif                }

127ExpandedSubBlockEnd.gif            }

128ExpandedSubBlockEnd.gif        }

129ExpandedSubBlockEnd.gif    }

130ExpandedBlockEnd.gif}

131None.gif

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值