GridView无代码分页排序

1.GridView无代码分页排序：

效果图：

1.AllowSorting设为True，aspx代码中是AllowSorting=\； 2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize=\。 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 = \数据库名;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 = \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 = \表 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 = \表\ 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[] { \主键 GridView1.DataBind(); sqlcon.Close(); } }

前台主要代码：

... ...

3.GridView正反双向排序：

效果图：点姓名各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 {

//清清月儿的博客http://blog.csdn.net/21aspnet SqlConnection sqlcon;

string strCon = \北风贸易;Uid=sa;Pwd=\ protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

ViewState[\身份证号码\ ViewState[\ bind(); } }

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e) {

string sPage = e.SortExpression;

if (ViewState[\

{

if (ViewState[\ ViewState[\ else

ViewState[\ } else {

ViewState[\ }

bind(); }

public void bind() {

string sqlstr = \飞狐工作室\ sqlcon = new SqlConnection(strCon);

SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open();

myda.Fill(myds, \飞狐工作室\

DataView view = myds.Tables[\飞狐工作室\

string sort = (string)ViewState[\ view.Sort = sort;

GridView1.DataSource = view; GridView1.DataBind(); sqlcon.Close(); } }

前台主要代码：

CellPadding=\Font-Size=\OnSorting=\BackColor=\