当前位置: 代码迷 >> ASP.NET >> Gridview分页后SelectedIndexChanging如何写
  详细解决方案

Gridview分页后SelectedIndexChanging如何写

热度:5068   发布时间:2013-02-25 00:00:00.0
Gridview分页后SelectedIndexChanging怎么写
如题,我的SelectedIndexChanging中该怎么写好?网上找了不少就是对不上号…
后台代码如下
C# code
    protected void Page_Load(object sender, EventArgs e)    {            this.type = "格式二";            this.sql = "select * from Hardware where " + this.Label1.Text.ToString().Trim() + " is not null or " + this.Label1.Text.ToString().Trim() + " <> ''";            InforReport nrr = new MISOA.SQLServerDAL.InforReport(sql, type);            GridView3.DataSource = nrr.GetDataSetByadminInfor();            GridView3.DataBind();}    protected void GridView3_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)    {    }

InforReport中 GetDatasetByadminInfor()如下:
C# code
        int i;        public DataSet GetDataSetByadminInfor()        {            string sqlname = "select name from syscolumns where id=object_id('Hardware')";            DataSet DB = SqlHelper.ExecuteReaderSelectToDataSet(SqlHelper.CreateConnection(), sqlname);            DataSet DBds = SqlHelper.ExecuteReaderSelectToDataSet(SqlHelper.CreateConnection(), sql);            DataSet ds = new DataSet();            DataTable dt = new DataTable("VIEW");            DataTable dt2 = new DataTable("Columns");            ds.Tables.Add(dt);            DataSet ds2 = new DataSet();            ds2.Tables.Add(dt2);            for (int k = 0; k < DB.Tables[0].Rows.Count; k++)            {                this.Name = DB.Tables[0].Rows[k][0].ToString().Trim();                dt.Columns.Add(Name, typeof(string));            }            try            {                for (int j = 0; j < DBds.Tables[0].Rows.Count; j++)                {                                        DataRow dr = ds.Tables["VIEW"].NewRow();                    for (i  = 0; i < DB.Tables[0].Rows.Count; i++)                    {                            Name = DB.Tables[0].Rows[i][0].ToString();                            dr[Name] = DBds.Tables[0].Rows[j][i].ToString();                                            }                    ds.Tables["VIEW"].Rows.Add(dr);                }                return ds;            }            catch (Exception e2)            {                return ds;            }        }

Aspx代码如下:
C# code
<asp:GridView ID="GridView3" runat="server" EmptyDataText="无数据" Font-Size="Small" AllowPaging="True" OnSelectedIndexChanging="GridView3_SelectedIndexChanging">   <PagerTemplate> <table width="100%">                           <tr>                             <td style="text-align:right">                             第 <asp:Label id="lblPageIndex" runat="server" text=' <%# ((GridView)Container.Parent.Parent).PageIndex + 1  %>' />页                                 共/ <asp:Label id="lblPageCount" runat="server" text=' <%# ((GridView)Container.Parent.Parent).PageCount  %>' />页                                 <asp:linkbutton id="btnFirst" runat="server" causesvalidation="False" commandargument="First" commandname="Page" text="首页" />                               <asp:linkbutton id="btnPrev" runat="server" causesvalidation="False" commandargument="Prev" commandname="Page" text="上一页" />                             <asp:linkbutton id="btnNext" runat="server" causesvalidation="False" commandargument="Next" commandname="Page" text="下一页" />                                                      <asp:linkbutton id="btnLast" runat="server" causesvalidation="False" commandargument="Last" commandname="Page" text="尾页" />                                                                        <asp:textbox id="txtNewPageIndex" runat="server" width="20px" text=' <%# ((GridView)Container.Parent.Parent).PageIndex + 1  %>' />                             <asp:linkbutton id="btnGo" runat="server" causesvalidation="False" commandargument="-1" commandname="Page" text="GO" />                            </td>                           </tr>                         </table>                         </PagerTemplate>      </asp:GridView>





------解决方案--------------------------------------------------------
GridView1.PageIndex = e.NewPageIndex;
BindGridView();//绑定数据的方法