gridview分页代码

最新推荐文章于 2019-08-06 06:23:07 发布

woshi1522wt

最新推荐文章于 2019-08-06 06:23:07 发布

阅读量296

点赞数

文章标签： button asp object server dataset session

本文链接：https://blog.csdn.net/woshi1522wt/article/details/6503444

版权

后台代码
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;

public   partial   class   pople_admin_newlist   :   System.Web.UI.Page
{
        public   Code   cal   =   new   Code();//这里是类   里面数据库连接等
        protected   void   Page_Load(object   sender,   EventArgs   e)
        {
                if   (Session[ "username "]   ==   null   ||   Session[ "username "]   ==   " ")
                {
                        Response.Redirect( "login.aspx ");
                }
                else
                {
                        if   (!Page.IsPostBack)
                        {
                                bind();
                        }
                }
        }

        public   void   bind()
        {
                DataSet   ds   =   cal.LoadNews(DropYa.SelectedValue.Trim(),DropFl.SelectedValue.Trim());
                DataColumn   mytable   =   ds.Tables[0].Columns.Add( "Number ",   System.Type.GetType( "System.String "));
                for   (int   i   =   0;   i   <   ds.Tables[0].Rows.Count;   i++)
                {
                        ds.Tables[0].Rows[i][ "Number "]   =   (i   +   1).ToString();
                        if(ds.Tables[0].Rows[i][ "fl "].ToString()== "1 ")
                        {
                                ds.Tables[0].Rows[i][ "fl "]   =   "企业动态 ";
                        }
                        else   if   (ds.Tables[0].Rows[i][ "fl "].ToString()   ==   "2 ")
                        {
                                ds.Tables[0].Rows[i][ "fl "]   =   "行业动态 ";
                        }
                }
                        GridView1.AllowPaging   =   true;
                GridView1.PageSize   =   20;
                GridView1.DataSource   =   ds.Tables[0];
                GridView1.DataBind();

                if   (GridView1.PageIndex   ==   0)
                {
                        Button1.Enabled   =   false;
                        Button2.Enabled   =   false;
                }
                else
                {
                        Button1.Enabled   =   true;
                        Button2.Enabled   =   true;
                }
                if   (GridView1.PageIndex   ==   GridView1.PageCount   -   1)
                {
                        Button3.Enabled   =   false;
                        Button4.Enabled   =   false;
                }
                else
                {
                        Button3.Enabled   =   true;
                        Button4.Enabled   =   true;
                }
        }
        protected   void   Button1_Click(object   sender,   EventArgs   e)
        {
                switch   (((Button)sender).CommandArgument.ToString())
                {
                        case   "first ":
                                GridView1.PageIndex   =   0;
                                break;
                        case   "last ":
                                GridView1.PageIndex   =   GridView1.PageCount   -   1;
                                break;
                        case   "prev ":
                                GridView1.PageIndex   =   GridView1.PageIndex   -   1;
                                break;
                        case   "next ":
                                GridView1.PageIndex   =   GridView1.PageIndex   +   1;
                                break;
                }
                bind();

        }
        protected   void   GridView1_RowCreated(object   sender,   GridViewRowEventArgs   e)
        {

                if   (e.Row.RowType   ==   DataControlRowType.DataRow)
                {//判断当前行是数据行，
                        e.Row.Attributes.Add( "onmouseover ",   "c=this.style.backgroundColor;this.style.backgroundColor= '#E0E0E0 '; ");
                        e.Row.Attributes.Add( "onmouseout ",   "this.style.backgroundColor=c; ");
                }

        }
        protected   void   GridView1_RowDeleting(object   sender,   GridViewDeleteEventArgs   e)
        {
                string   id   =   GridView1.DataKeys[e.RowIndex][ "id "].ToString();
                int   back   =   cal.DelNews(id);
                if   (back   >   0)
                {
                        Jscript.Show( "删除成功 ");
                        bind();
                }

        }
        protected   void   GridView1_RowUpdating(object   sender,   GridViewUpdateEventArgs   e)
        {
                string   id   =   GridView1.DataKeys[e.RowIndex][ "id "].ToString();
                Response.Redirect( "admin_newxg.aspx?id= "+id);
        }

        protected   void   DropFl_SelectedIndexChanged(object   sender,   EventArgs   e)
        {
                bind();
        }
        protected   void   DropYa_SelectedIndexChanged(object   sender,   EventArgs   e)
        {
                bind();
        }
}