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 {
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[\].ToString() == sPage) {
if (ViewState[\].ToString() == \) ViewState[\] = \; else
ViewState[\] = \; } else {
ViewState[\] = e.SortExpression; } 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[\飞狐工作室\].DefaultView;
string sort = (string)ViewState[\] + \ + (string)ViewState[\]; view.Sort = sort;
GridView1.DataSource = view; GridView1.DataBind(); sqlcon.Close(); } }
前台主要代码:
CellPadding=\ Font-Size=\ OnSorting=\idView1_Sorting\ BackColor=\ BorderColor=\ BorderStyle=\ BorderWidth=\
4.GridView和下拉菜单DropDownList结合: 效果图:

