提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  移动开发

当前栏目

Asp.netGridView使用大全(分页实现)

ASP 实现 使用 分页 大全 netGridview
2023-06-13 09:14:51 时间

GridView自带的分页功能实现：

要实现GrdView分页的功能
操作如下：
1、更改GrdView控件的AllowPaging属性为true。
2、更改GrdView控件的PageSize属性为任意数值（默认为10）
3、更改GrdView控件的PageSetting->Mode为Numeric等（默认为Numeric）该属性为分页样式。
GridView属性设置好了，从页面上也能看到分页样式。

现在开始实现分页的功能：

1、在<<asp:GridViewID=......>后添加，OnPageIndexChanging="GridView1_PageIndexChanging"
2、在对应的aspx.cs中添加：
   protectedvoidGridView1_PageIndexChanging(objectsender,GridViewPageEventArgse)
   {
       GridView1.PageIndex=e.NewPageIndex;
       InitPage();//重新绑定GridView数据的函数
   }
3、
GridView1.PageIndex=e.NewPageIndex;
完了之后再重新绑定一下GridView。

GridView添加CheckBox列实现全选/全部取消功能

首先GridView编辑模版，在模板上添加CheckBox控件，之后将新添加列字段转换为TemplateFiled



后台代码：

复制代码代码如下:

usingSystem;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
usingSystem.Data.SqlClient;

publicpartialclassDefault5:System.Web.UI.Page
{
   SqlConnectionsqlcon;
   stringstrCon="DataSource=(local);Database=北风贸易;Uid=sa;Pwd=sa";
   protectedvoidPage_Load(objectsender,EventArgse)
   {
       if(!IsPostBack)
       {
           bind();
       }
   }
   protectedvoidCheckBox2_CheckedChanged(objectsender,EventArgse)
   {
       for(inti=0;i<=GridView1.Rows.Count-1;i++)
       {
           CheckBoxcbox=(CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
           if(CheckBox2.Checked==true)
           {
               cbox.Checked=true;
           }
           else
           {
               cbox.Checked=false;
           }
       }
   }
   protectedvoidButton2_Click(objectsender,EventArgse)
   {
       sqlcon=newSqlConnection(strCon);
       SqlCommandsqlcom;
       for(inti=0;i<=GridView1.Rows.Count-1;i++)
       {
           CheckBoxcbox=(CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
           if(cbox.Checked==true)
           {

               stringsqlstr="deletefrom飞狐工作室where身份证号码=""+GridView1.DataKeys[i].Value+""";
               sqlcom=newSqlCommand(sqlstr,sqlcon);
               sqlcon.Open();
               sqlcom.ExecuteNonQuery();
               sqlcon.Close();
           }
       }
       bind();
   }
   protectedvoidButton1_Click(objectsender,EventArgse)
   {
       CheckBox2.Checked=false;
       for(inti=0;i<=GridView1.Rows.Count-1;i++)
       {
           CheckBoxcbox=(CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
           cbox.Checked=false;
       }
   }
   publicvoidbind()
   {
       stringsqlstr="selecttop5*from飞狐工作室";
       sqlcon=newSqlConnection(strCon);
       SqlDataAdaptermyda=newSqlDataAdapter(sqlstr,sqlcon);
       DataSetmyds=newDataSet();
       sqlcon.Open();
       myda.Fill(myds,"tb_Member");
       GridView1.DataSource=myds;
       GridView1.DataKeyNames=newstring[]{"身份证号码"};
       GridView1.DataBind();
       sqlcon.Close();
   }
}


前台主要代码：
复制代码代码如下:

<asp:GridViewID="GridView1"runat="server"AllowSorting="True"AutoGenerateColumns="False"
                       CellPadding="3"Font-Size="9pt"BackColor="White"BorderColor="#CCCCCC"BorderStyle="None"BorderWidth="1px">
                       <FooterStyleBackColor="White"ForeColor="#000066"/>
                       <Columns>
                            <asp:TemplateField>
                               <ItemTemplate>
                                   <asp:CheckBoxID="CheckBox1"runat="server"/>
                               </ItemTemplate>
                           </asp:TemplateField>
                            <asp:BoundFieldDataField="身份证号码"HeaderText="用户ID"SortExpression="身份证号码"/>
                           <asp:BoundFieldDataField="姓名"HeaderText="用户姓名"SortExpression="姓名"/>

                           <asp:BoundFieldDataField="家庭住址"HeaderText="家庭住址"SortExpression="家庭住址"/>

                       </Columns>
                       <RowStyleForeColor="#000066"/>
                       <SelectedRowStyleBackColor="#669999"Font-Bold="True"ForeColor="White"/>
                       <PagerStyleBackColor="White"ForeColor="#000066"HorizontalAlign="Left"/>
                       <HeaderStyleBackColor="#006699"Font-Bold="True"ForeColor="White"/>
                   </asp:GridView>
                    <asp:CheckBoxID="CheckBox2"runat="server"AutoPostBack="True"Font-Size="9pt"OnCheckedChanged="CheckBox2_CheckedChanged"
                       Text="全选"/>
                   <asp:ButtonID="Button1"runat="server"Font-Size="9pt"Text="取消"onClick="Button1_Click"/>
                   <asp:ButtonID="Button2"runat="server"Font-Size="9pt"Text="删除"onClick="Button2_Click"/>

相关文章