GridView无代码分页排序

• 1.GridView无代码分页排序：
• 效果图：
• 
• 1.AllowSorting设为True，aspx代码中是AllowSorting="True"；
• 2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。
• 3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。
• 2.GridView选中，编辑，取消，删除：
• 效果图：
• 
• 后台代码：
• 你可以使用sqlhelper,本文没用。代码如下：
• using System;
  using System.Data;
  using System.Configuration;
  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 _Default : System.Web.UI.Page
• {
• //清清月儿http://blog.csdn.net/21aspnet
• SqlConnection sqlcon;
• SqlCommand sqlcom;
• string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";
• protected void Page_Load(object sender, EventArgs e)
• {
• if (!IsPostBack)
• {
• bind();
• }
• }
• protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
• {
• GridView1.EditIndex = e.NewEditIndex;
• bind();
• }
• //删除
• protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
• {
• string sqlstr = "delete from 表 where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString()
  + "'";
• sqlcon = new SqlConnection(strCon);
• sqlcom = new SqlCommand(sqlstr,sqlcon);
• sqlcon.Open();
• sqlcom.ExecuteNonQuery();
• sqlcon.Close();
• bind();
• }
• //更新
• protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
• {
• sqlcon = new SqlConnection(strCon);
• string sqlstr = "update 表 set 字段1='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',字段2='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',字段3='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
• sqlcom=new SqlCommand(sqlstr,sqlcon);
• sqlcon.Open();
• sqlcom.ExecuteNonQuery();
• sqlcon.Close();
• GridView1.EditIndex = -1;
• bind();
• }
• //取消
• protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
• {
• GridView1.EditIndex = -1;
• bind();
• }
• //绑定
• public void bind()
• {
• string sqlstr = "select * from 表";
• sqlcon = new SqlConnection(strCon);
• SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
• DataSet myds = new DataSet();
• sqlcon.Open();
• myda.Fill(myds, "表");
• GridView1.DataSource = myds;
• GridView1.DataKeyNames = new string[] { "id" };//主键
• GridView1.DataBind();
• sqlcon.Close();
• }
• }
• 前台主要代码：
• <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit">
• <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
• <Columns>
• <asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" />
• <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
• <asp:BoundField DataField="员工性别" HeaderText="性别" />
• <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
• <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
• <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
• <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
• </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>