• gridView分页


    <tr>
                         <td align="center" style="height: 25px">
                             <asp:LinkButton ID="btnFirst" CommandArgument="first" OnClick="PagerButtonClick"
                                 runat="server">
    </asp:LinkButton>
                             <asp:LinkButton ID="btnPrev" CommandArgument="prev" OnClick="PagerButtonClick" runat="server">
    上一页</asp:LinkButton>
                             <asp:LinkButton ID="btnNext" CommandArgument="next" OnClick="PagerButtonClick" runat="server">
    下一页</asp:LinkButton>
                             <asp:LinkButton ID="btnLast" CommandArgument="last" OnClick="PagerButtonClick" runat="server">
    </asp:LinkButton>
                             <asp:Label ID="LblCurrentIndex" runat="server"></asp:Label>
                             <asp:Label ID="LblPageCount" runat="server"></asp:Label>
                             <asp:Label ID="LblRecordCount" runat="server"></asp:Label></td>
                     </tr>
                     <tr>
                         <td>
                             <asp:Button ID="Button2" runat="server" Text="checkbox
    得到选择的行" OnClick="Button2_Click">
                             </asp:Button>
                             <asp:Button ID="Button1" runat="server" Text="radio
    得到选择的行" OnClick="Button1_Click"></asp:Button>
                         </td>
                     </tr>

    private void GridViewBind(string Sqlsort)
         {
             string connStr = ConfigurationManager.ConnectionStrings["ConnString1"].ConnectionString;
             string SqlStr = "Select * FROM test01 where id<1000" + Sqlsort;
             DataSet ds = new DataSet();
            
             try
             {
                 SqlConnection conn = new SqlConnection(connStr);
                 if (conn.State.ToString() == "Closed") conn.Open();

                 SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
                 da.Fill(ds, "test01");            
                 if (conn.State.ToString() == "Open") conn.Close();

                 GridView1.DataSource = ds.Tables[0].DefaultView;
                 GridView1.DataBind();

                 LblCurrentIndex.Text = "
    " + (GridView1.PageIndex + 1).ToString() + " ";
                 LblPageCount.Text = "
    " + GridView1 .PageCount.ToString()+ " ";
                 LblRecordCount.Text = "
    总共 "+ds.Tables[0].Rows.Count.ToString()+" ";
                 if (ds.Tables[0].Rows.Count == 0)
                 {
                     btnFirst.Visible = false;
                     btnPrev.Visible = false;
                     btnNext.Visible = false;
                     btnLast.Visible = false;

                     LblCurrentIndex.Visible = false;
                     LblPageCount.Visible = false;
                     LblRecordCount.Visible = false;
                 }
                 else if (GridView1.PageCount == 1)
                 {
                     btnFirst.Visible = false;
                     btnPrev.Visible = false;
                     btnNext.Visible = false;
                     btnLast.Visible = false;
                 }
    //QQ:272912705 光之翼 www.hi.baidu.com/jcomet
                 //
    计算生成分页页码,分别为:" " "上一页" "下一页" " "
                 btnFirst.CommandName = "1";
                 btnPrev.CommandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());

                 btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
                 btnLast.CommandName = GridView1.PageCount.ToString();
                 //
             }
             catch(Exception ex)
             {
                 Response.Write("
    数据库错误,错误原因:"+ex.Message);
                 Response.End();
             }
         }
         protected void PagerButtonClick(object sender, EventArgs e)
         {
             GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName)-1;
             GridViewBind("");        
         }

         protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
         {
             e.Row.Attributes["onmouseover"] = "ItemOver(this)";
         }

  • 相关阅读:
    getter 和 setter方法
    了解coredata 数据库的博客
    iOS 本地缓存简述
    iOS 9.0 xcode7
    iOS 直播推流SDK -- PLCameraStreamingKit
    时间充裕的时候看看技术总结
    技术分享7
    学习笔记-音频编解码
    学习笔记-weak strong ARC mrc
    飘雪效果的swf
  • 原文地址:https://www.cnblogs.com/jcomet/p/1242478.html
Copyright © 2020-2023  润新知