CSDN博客

img zhangzs8896

一个功能齐全的DataGrid分页例子

发表于2004/9/19 16:16:00  677人阅读

分类: Vs.Net


.cs 文件如下:

using System;

using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace Pu1_Erp
{
 ///


 /// DataGridPaging 的摘要说明。
 ///

 public class DataGridPaging : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Label lblPageCount;
  protected System.Web.UI.WebControls.Label lblCurrentIndex;
  protected System.Web.UI.WebControls.LinkButton btnFirst;
  protected System.Web.UI.WebControls.LinkButton btnPrev;
  protected System.Web.UI.WebControls.LinkButton btnNext;
  protected System.Web.UI.WebControls.LinkButton btnLast;
  protected System.Web.UI.WebControls.DataGrid MyDataGrid;
  protected System.Web.UI.WebControls.Label Label1;
  protected System.Web.UI.WebControls.Label Label2;
  protected System.Web.UI.WebControls.Label Label3;
  protected System.Web.UI.WebControls.TextBox Txt_Grade_Code;
  protected System.Web.UI.WebControls.TextBox Txt_Grade_Name;
  protected System.Web.UI.WebControls.Button Btn_add;
  protected System.Web.UI.WebControls.Label Lab_Count;
  public System.Data.SqlClient.SqlConnection cn=new SqlConnection();
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   btnFirst.Text = "最首页";
   btnPrev.Text = "前一页";
   btnNext.Text = "下一页";
   btnLast.Text = "最后页";
   OpenDatabase();
   BindGrid(); 
  }

  private void BindGrid()
  {
   System.Data.SqlClient.SqlConnection con=cn;
   string str ="select * from SteelGrade order by 钢种代码";
   System.Data.DataSet ds=new DataSet();
   System.Data.SqlClient.SqlDataAdapter da=new SqlDataAdapter(str,con);
   da.Fill(ds,"JTQSpecStand");
   MyDataGrid.DataSource=ds.Tables["JTQSpecStand"].DefaultView;
            Lab_Count.Text="目前钢种总数 "+ds.Tables["JTQSpecStand"].Rows.Count.ToString();
   MyDataGrid.DataBind();
   ShowStats();
  
  }

  public  void MyDataGrid_Page(object sender,DataGridPageChangedEventArgs e)
  {
   int startIndex;
   startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
   MyDataGrid.CurrentPageIndex = e.NewPageIndex;
   BindGrid();
   ShowStats();

  }

  private void ShowStats()

  {
   lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页 ";
   lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页 ";

  }

  //  public void PagerButtonClick( object sender,System.EventArgs e)
  //  {
  //   string arg=((Button)sender).CommandArgument.ToString();
  ////   string arg=e.CommandArgument.ToString();
  //   switch(arg)
  //   {
  //    case "next":
  //     if(MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
  //     {
  //       MyDataGrid.CurrentPageIndex += 1;
  //     }
  //     break;
  //   
  //       case "prev":
  //     if(MyDataGrid.CurrentPageIndex > 0)
  //     {
  //      MyDataGrid.CurrentPageIndex -= 1;
  //     }
  //     break;
  //    case "last":
  //     MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
  //                    break;
  //
  //    default:
  //           MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
  //                
  //        break;
  //   
  //   }
  //
  //   BindGrid();
  //   ShowStats();
  //
  //           
  //  }

  
  //设置数据库连接串
  public void OpenDatabase()
  {
   cn.ConnectionString="server=172.16.2.2;database=movex12;uid=sa;pwd=tpcims";
   cn.Open();
  }
   
  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  ///


  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  ///

  private void InitializeComponent()
  {   
   this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
   this.btnPrev.Click += new System.EventHandler(this.btnPrev_Click);
   this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
   this.btnLast.Click += new System.EventHandler(this.btnLast_Click);
   this.Btn_add.Click += new System.EventHandler(this.Btn_add_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  
  //执行下一页
  private void btnNext_Click(object sender, System.EventArgs e)
  {
   if(MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
   {
    MyDataGrid.CurrentPageIndex += 1;
    BindGrid();
    ShowStats();

   }
  }
       
  
  //执行前一页
  private void btnPrev_Click(object sender, System.EventArgs e)
  {
   if(MyDataGrid.CurrentPageIndex >0)
   {
    MyDataGrid.CurrentPageIndex -= 1;
    BindGrid();
    ShowStats();

   }
  }

  //执行最首页
  private void btnFirst_Click(object sender, System.EventArgs e)
  {
   MyDataGrid.CurrentPageIndex = 0;
   BindGrid();
   ShowStats();

  }

  //执行最后一页
  private void btnLast_Click(object sender, System.EventArgs e)
  {
   MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
   BindGrid();
   ShowStats();

  }

  //增加新钢种
  private void Btn_add_Click(object sender, System.EventArgs e)
  {
   try
   {
        Market_Cost.Steel ss=new Pu1_Erp.Market_Cost.Steel();
    DataSet ds=ss.Grade(Txt_Grade_Name.Text.Trim(),Txt_Grade_Code.Text.Trim());
    Response.Write("

0 0

相关博文

我的热门文章

img
取 消
img