private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
Bind();
}
private void InitializeComponent()
{
this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
this.Load += new System.EventHandler(this.Page_Load); }
//装载数据到网格控件
private void LoadDataToGrid()
{
string sSql = "Select * From T_AfterServReceHarmDoc";
conn = new SqlConnection(sConn);
ds = new DataSet();
apt = new SqlDataAdapter(sSql,conn);
try
{
//填充数据集
apt.Fill(ds,"dtReceHarmDoc");
//创建数据表和数据视图
DataTable dtReceHarmDoc = ds.Tables[0];
DataView dv = dtReceHarmDoc.DefaultView;
//按指定的列排序
dv.Sort = sSortView;
lblCount.Text = dv.Count.ToString(); if(dv.Count > 0)
dgReceHarmDoc.Visible = true;
else
dgReceHarmDoc.Visible = false;
//绑定数据
dgReceHarmDoc.DataSource = dv;
dgReceHarmDoc.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
}
private void dgReceHarmDoc_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgReceHarmDoc.CurrentPageIndex = e.NewPageIndex;
LoadDataToGrid();
} //按指定的列排序
private void dgReceHarmDoc_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
sSortView = e.SortExpression;
LoadDataToGrid();
}
我加了下面的代码解决的
Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged DataGrid1.CurrentPageIndex = e.NewPageIndex '分页 End Sub
另外AutoGenerateColumns="False" 好像最好是“true'
我犯了一个错误SqlDataReader 对从 SQL 数据库检索的数据提供仅向前的只读指针。若要使用 SqlDataReader,请声明 SqlCommand 而不是 SqlDataAdapter。向前的只读指针是不是不能实现翻分功能啊?
在分页时属性enableViewState是不是必须为true啊?我试着设成false不就能分页了
[email protected]