ASP.NET中如何实现GridView双向排序

原创|其它|编辑:郝浩|2009-05-26 14:58:08.000|阅读 770 次

概述:本文通过代码举例说明了在ASP.NET中GridView的双向排序的方法。

# 界面/图表报表/文档/IDE等千款热门软控件火热销售中 >>

  效果图:点姓名各2次的排序,点其他也一样可以。

  后台代码:

  using System;
  using System.Data;
  using System.Configuration;
  using System.Collections;
  using System.Web;
  using System.Web.Security;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using System.Web.UI.WebControls.WebParts;
  using System.Web.UI.HtmlControls;
  using System.Data.SqlClient;
  public partial class Default3 : System.Web.UI.Page
  {
  SqlConnection sqlcon;
  string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=";
  protected void Page_Load(object sender, EventArgs e)
  {
  if (!IsPostBack)
  {
  ViewState["SortOrder"] = "身份证号码";
  ViewState["OrderDire"] = "ASC";
  bind();
  }
  }
  protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
  {
  string sPage = e.SortExpression;
  if (ViewState["SortOrder"].ToString() == sPage)
  {
  if (ViewState["OrderDire"].ToString() == "Desc")
  ViewState["OrderDire"] = "ASC";
  else
  ViewState["OrderDire"] = "Desc";
  }
  else
  {
  ViewState["SortOrder"] = e.SortExpression;
  }
  bind();
  }
  public void bind()
  {
  string sqlstr = "select top 5 * from 飞狐工作室";
  sqlcon = new SqlConnection(strCon);
  SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
  DataSet myds = new DataSet();
  sqlcon.Open();
  myda.Fill(myds, "飞狐工作室");
  DataView view = myds.Tables["飞狐工作室"].DefaultView;
  string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
  view.Sort = sort;
  GridView1.DataSource = view;
  GridView1.DataBind();
  sqlcon.Close();
  }
  }

   前台主要代码: 

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
                        CellPadding="3" Font-Size="9pt" OnSorting="GridView1_Sorting" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px">
                        <FooterStyle BackColor="White" ForeColor="#000066" />
                        <Columns>
                             <asp:BoundField DataField="身份证号码" HeaderText="用户ID" SortExpression="身份证号码" />
                            <asp:BoundField DataField="姓名" HeaderText="用户姓名

" SortExpression="姓名"/>
                            <asp:BoundField DataField="员工性别" HeaderText="性别" SortExpression="员工性别"/>
                            <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>
                               
                        </Columns>
                        <RowStyle ForeColor="#000066" />
                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                    </asp:GridView>


标签:

本站文章除注明转载外,均为本站原创或翻译。欢迎任何形式的转载,但请务必注明出处、不得修改原文相关链接,如果存在内容上的异议请邮件反馈至chenjj@evget.com

文章转载自:IT专家网论坛

为你推荐

  • 推荐视频
  • 推荐活动
  • 推荐产品
  • 推荐文章
  • 慧都慧问
扫码咨询


添加微信 立即咨询

电话咨询

客服热线
023-68661681

TOP