.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(" <script language=javascript>alert(/"填加新钢种成功!/");
");
????Txt_Grade_Name.Text="";
????Txt_Grade_Code.Text="";
????
???}
???catch{
??? Response.Write("