paging of gridview

本文关键字:gridview of paging | 更新日期: 2023-09-27 18:01:04

我有一个允许分页的网格视图。但当我点击第二页时,网格视图消失了这是c#代码:

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        OdbcDataAdapter adpState = new OdbcDataAdapter("SELECT CALL_NO,TDATE,
        ID_NO,NAME,CONTACT,DEPARTMENT,ISSUE,STATUS FROM TBL_ITHELPDESK 
        WHERE (STATUS IS NULL OR STATUS <> 'CLOSED') AND  TDATE= TO_DATE('" +
          txtDate.Text.ToString().Trim() + "','MM-DD-YYYY')", con1);
        DataSet ds = new DataSet();
        adpState.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();    
    }

有人能帮我找出哪里出了问题吗

paging of gridview

您必须检查多个内容。

  1. 将查询与正在运行的查询进行核对,是否相同
  2. 检查con1变量是否在任何其他方法之外定义

在类中而不是在方法中定义con1,类似于

 odbcConnection con = new odbcConnection(ConectionString);