不会出现的吧,你要重新绑定,绑定代码方在
if (!Page.Ispostback)
{
bindnew();//绑定datagrid的函数;
}private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
bindnew();//重新绑定
}
if (!Page.Ispostback)
{
bindnew();//绑定datagrid的函数;
}private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
bindnew();//重新绑定
}
解决方案 »
- 怎么在一个地方插入另一页
- 点击一个按钮,会关闭本页面的函数
- 帮忙看一下这个问题出错在哪儿
- panel中控件位置的问题.搞了很长时间,还是弄不了啊!!!!!!!!!!!!
- 做网站的时候,用什么字体,字体选择问题? 高手帮忙!
- sqldatasource里面的参数,怎样将它的值设置为页面的一个属性,如我定义了一个属性;property abc as string,怎样将它参数的值设为abc?
- 请各位看看关于asp.net 页面刷新的问题!!!!!!!!!!!50分
- 急,请教高手这样的数据怎样倒入的数据库中??
- 高分求教
- [Crystal Report]安装补丁时,发生如下错误:fail to read/update registry...
- 如何通過HTML協議上傳多個文件至網址?
- 我在安装。NET PetShop 3。0 碰到问题
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;
using System.Configuration;namespace itsytu01.itadmin
{
/// <summary>
/// delnews 的摘要说明。
/// </summary>
public class delnews : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid shownews;
protected System.Data.SqlClient.SqlCommand cm;
protected System.Data.SqlClient.SqlConnection cn;
protected System.Data.SqlClient.SqlDataAdapter da;
protected System.Data.DataSet ds;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
bindgrid();
} } #region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.shownews.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.shownews_PageIndexChanged);
this.shownews.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.shownews_DeleteCommand);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion public void bindgrid()
{
cn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
string strSQL="SELECT newsid, newstitle, newsuptime, newsclick, newstype, newsfrom FROM news WHERE (newstype = '最新新闻') ORDER BY newsuptime DESC";
da=new SqlDataAdapter(strSQL,cn);
cn.Open();
ds=new DataSet();
da.Fill(ds);
shownews.DataSource=ds;
shownews.DataBind();
} private void shownews_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
shownews.CurrentPageIndex=e.NewPageIndex;
bindgrid();
} private void shownews_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
cn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
string strSQL="delete from news where newsid=@newsid";
cm=new SqlCommand(strSQL,cn);
cm.Parameters.Add(new SqlParameter("@newsid",SqlDbType.BigInt,8));
cm.Parameters["@newsid"].Value=shownews.DataKeys[(int)e.Item.ItemIndex];
cm.Connection.Open();
cm.ExecuteNonQuery();
cm.Connection.Close();
bindgrid();
}
}
}
{
shownews.CurrentPageIndex=e.NewPageIndex;
bindgrid();//重新绑定数据到DataGrid
}
其中得bindgrid()即:
public void bindgrid()
{
cn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
string strSQL="SELECT newsid, newstitle, newsuptime, newsclick, newstype, newsfrom FROM news WHERE (newstype = '最新新闻') ORDER BY newsuptime DESC";
da=new SqlDataAdapter(strSQL,cn);
cn.Open();
ds=new DataSet();
da.Fill(ds);
shownews.DataSource=ds;
shownews.DataBind();
}
DataGrid1.CurrentPageIndex = e.NewPageIndex
'重新帮定
DataBind()
End Sub
该用
int index =e.Item.ItemIndex+DataGrid.PageSize*DataGrid.CurrentPageIndex