datagrid 分页问题！在线等解决以后马上给分
我的分页点了以后不管用。不显示下一页。还在本页。
代码如下：
BindGrid类代码：
using System;
using System.Data;
using System.Configuration;
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;
/// <summary>
/// BindGrid 的摘要说明
/// </summary>
public class BindGrid
{
public SqlConnection con;
public SqlDataAdapter sda;
public DataSet ds;
//public BindGrid(string sql_select)
//{
// con = new SqlConnection(ConfigurationSettings.AppSettings[ "Str_sql "]);
// con.Open();
// sda = new SqlDataAdapter(sql_select, con);
// ds = new DataSet();
// sda.Fill(ds);
// //
// // TODO: 在此处添加构造函数逻辑
// //
//}
public BindGrid()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public void Opencon(string sql_select)
{
con = new SqlConnection(ConfigurationSettings.AppSettings[ "Str_sql "]);
con.Open();
sda = new SqlDataAdapter(sql_select, con);
BindGrid1(sda);
}
public void BindGrid1(SqlDataAdapter sda)
{
ds = new DataSet();
sda.Fill(ds);
}
public void NextGrid1(DataSet ds)
{
}
}
cs代码：
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 admin_cus_manage_invete_ratify : System.Web.UI.Page
{
protected string sql_select, str_where;
protected SqlCommand cmd_updata;
protected BindGrid Bgrid;
protected void Page_Load(object sender, EventArgs e)
{
sql_select = "select business_id,[User_name],Business_name,Business_company,Business_issuance from business where Business_authentication= 'n ' ";
Bgrid = new BindGrid();
Bgrid.Opencon(sql_select);
if (!IsPostBack) // 第一个加载的时候绑订datagrid
{
Bgrid.BindGrid1(Bgrid.sda);
DataGrid1.DataSource = Bgrid.ds.Tables[0];
DataGrid1.DataBind();
}
ShowStats();
Bgrid.con.Close();
}
protected void Button1_Click1(object sender, EventArgs e)
{
str_where = Request.Form.Get( "titxt_gjz ").ToString(); // 按查询条件绑订datagrid
if (str_where != " ")
{
str_where = "select business_id,[User_name],Business_name,Business_company,Business_issuance from business where Business_authentication= 'n ' and " + Request.Form.Get( "class_select ").ToString() + " like '% " + str_where + "% ' ";
BindGrid Bgrid = new BindGrid();
Bgrid.Opencon(str_where);
Bgrid.BindGrid1(Bgrid.sda);
DataGrid1.DataSource = Bgrid.ds.Tables[0];
DataGrid1.DataBind();
Bgrid.con.Close();
}
else
{
str_where = "select business_id,[User_name],Business_name,Business_company,Business_issuance from business where Business_authentication= 'n ' ";
BindGrid Bgrid = new BindGrid();
Bgrid.Opencon(str_where);
Bgrid.BindGrid1(Bgrid.sda);
DataGrid1.DataSource = Bgrid.ds.Tables[0];
DataGrid1.DataBind();
Bgrid.con.Close();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
// 认证信息
Authentication Action = new Authentication(DataGrid1); //调用Authencication类，更新所选择中的类
str_where = "select business_id,[User_name],Business_name,Business_company,Business_issuance from business where Business_authentication= 'n ' ";
BindGrid Bgrid = new BindGrid();
Bgrid.Opencon(str_where);
Bgrid.BindGrid1(Bgrid.sda);
DataGrid1.DataSource = Bgrid.ds.Tables[0];
DataGrid1.DataBind();
Bgrid.con.Close();
}
private void ShowStats()
{
Label1.Text = "共 " + DataGrid1.PageCount.ToString() + "页 ";
Label2.Text = "第 " + (DataGrid1.CurrentPageIndex + 1).ToString() + "页 ";
}
protected void lbt_first_Click(object sender, EventArgs e)
{
DataGrid1.CurrentPageIndex = 0;
}
protected void lbt_flont_Click(object sender, EventArgs e)
{
if (DataGrid1.CurrentPageIndex > 0)
{
DataGrid1.CurrentPageIndex -= 1;
}
}
protected void lbt_next_Click(object sender, EventArgs e)
{
if (DataGrid1.CurrentPageIndex < (DataGrid1.PageCount - 1))
{
DataGrid1.CurrentPageIndex += 1;
}
Bgrid.BindGrid1(Bgrid.sda);
DataGrid1.DataSource = Bgrid.ds.Tables[0];
DataGrid1.DataBind();
}
protected void lbt_finally_Click(object sender, EventArgs e)
{
DataGrid1.CurrentPageIndex = (DataGrid1.PageCount - 1);
}
}
[解决办法]
还有一个事件才能分页
protected void DataGrid1_PageIndexChanged1(object source, DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
this.binddate();
}
[解决办法]
同意楼上
[解决办法]
我也是这样做的
[解决办法]
protected void DataGrid1_PageIndexChanged1(object source, DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex = e.NewPageIndex;//设置新页数
this.binddate();//重新绑定数据源
}
