asp.net 中Gridview

最新推荐文章于 2023-05-26 17:14:17 发布

peien3382

最新推荐文章于 2023-05-26 17:14:17 发布

阅读量371

点赞数

分类专栏： asp

本文链接：https://blog.csdn.net/peien3382/article/details/8940314

版权

asp 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

********************************aspx.cs************************

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace Gridview
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                bind();

}

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView1.PageIndex = e.NewPageIndex;
            bind();
        }

        protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
        {
            ViewState["SortExpression"] = e.SortExpression;// 获取控件的SortExpression

            if (ViewState["SortDirection"] == null)   //交替执行升降序
                ViewState["SortDirection"] = "DESC";
            else if (ViewState["SortDirection"].ToString() == "ASC")
                ViewState["SortDirection"] = "DESC";
            else
                ViewState["SortDirection"] = "ASC";

            bind();
        }

        public void bind()
        {
            string SQL = "SELECT * FROM USERS ";
            DataSet ds = new DataSet();
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString; //通过吧connection 字符串放在config 里面这样如果改了字符串也不需要重新编译这就是好处
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter(SQL, conn);
            da.Fill(ds);
            if (ViewState["SortDirection"] == null)
                GridView1.DataSource = ds.Tables[0];
            else
            {
                DataView dv = new DataView(ds.Tables[0]); //吧dataview 作为数据源进行绑定
                dv.Sort = ViewState["SortExpression"].ToString() + " " + ViewState["SortDirection"].ToString();
                GridView1.DataSource = dv;
            }
            GridView1.DataBind();
            conn.Close();

        }

}
}

***************************aspx****************************

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Gridview._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

*********************webconfig**************************

peien3382

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
asp.net 中Gridview

********************************aspx.cs************************using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using
复制链接

扫一扫

专栏目录