GridView 常用方法合集

在项目中主要用了gridview来显示数据，其中的方法都是常用的。
1、利用sqldatasource动态邦定数据，其中sqldatasource1是托放在页面的sqldatasource控件，将数据邦定到gridview1上面

    void gridviewband() {
             try
            {
                SqlDataSource1.ConnectionString  = ConfigurationSettings.AppSettings[ "sqlconn"];
                SqlDataSource1.SelectCommand  = squerysql;
                GridView1.DataSource  = SqlDataSource1;
                GridView1.DataBind();
                 //看有没有数据 如果没有数据 提示错误  lblresult的text的内容是错误信息  
                 int count = GridView1.Rows.Count;
                 if (count == 0) { lblresult.Visible  = true; }
                 else { lblresult.Visible  = false; }
            }
             catch   (SqlException ex5)
            {
                 //提示错误信息
            }
             finally {  
            }
    }

2、选择一行，获取关键字，然后传到其他页面

    protected void GridView1_SelectedIndexChanged( object sender, EventArgs e)
    {//选择某一行
        Session[ "selectkey"] = GridView1.SelectedDataKey.Value;
        Response.Redirect( "~/employee/employeedetail.aspx");
    }

3、获取编辑行的关键字

         protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        //编辑修改
        Session[ "editkey"] = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Redirect( "~/employee/employeeedit.aspx");
    }

4、删除一行，获取关键字。这个地方还是用rowdeleting 事件。

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        String idno111  = GridView1.DataKeys[e.RowIndex].Value.ToString();
        SqlDataSource1.DeleteCommand  = "delete from empinfo where empnum=' " + idno111 + "'" 
             + "delete from employee where empnum=' " + idno111 + "'";
        //删除行
         if (e.RowIndex >= 0)
        {

            String connectstr  = ConfigurationSettings.AppSettings[ "sqlconn"];
            SqlConnection sqlconn  = new SqlConnection(connectstr);
            sqlconn.Open();
            SqlCommand comm  = new SqlCommand(SqlDataSource1.DeleteCommand, sqlconn);
            comm.ExecuteNonQuery();
            sqlconn.Close();
        }
    }

5、删除前提示关键字，不仅仅是提示“确认删除吗？” 而是提示“确认删除关键字是***的数据吗？”

首先在aspx文件脚本里面要设置 重要看的是gridview的标签里面要有
 DatakeyNames="关键字" 同时 CommandArgument='<%# Eval("departno") %>'  这两处要填写

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
        CellPadding ="4" DataKeyNames="departno" DataSourceID="SqlDataSource1" ForeColor="#333333"
        GridLines ="None" OnDataBound="CustomersGridView_DataBound" OnRowDeleting="GridView1_RowDeleting"
        OnRowEditing ="GridView1_RowEditing" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
        PageSize ="15" Width="800px" OnRowDataBound="GridView1_RowDataBound">
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <Columns>
             <asp:BoundField DataField="departno" HeaderText="部门编号" SortExpression="departno" />
             <asp:BoundField DataField="father" HeaderText="父级部门" SortExpression="father" />
             <asp:BoundField DataField="departname" HeaderText="部门名称" SortExpression="departname" />
             <asp:BoundField DataField="person" HeaderText="联系人" SortExpression="person" />
             <asp:BoundField DataField="tel" HeaderText="固定电话" SortExpression="tel" />
             <asp:BoundField DataField="mobiletel" HeaderText="手机" SortExpression="mobiletel" />
            
             <asp:CommandField ButtonType="Image" HeaderText="查看" SelectImageUrl="~/icons/look.gif"
                SelectText ="查看" ShowSelectButton="True">
                 <HeaderStyle HorizontalAlign="Center" />
                 <ItemStyle HorizontalAlign="Center" />
             </asp:CommandField>
             <asp:CommandField ButtonType="Image" EditImageUrl="~/icons/edit.gif" EditText="编辑"
                HeaderText ="编辑" ShowEditButton="True">
                 <HeaderStyle HorizontalAlign="Center" />
                 <ItemStyle HorizontalAlign="Center" />
             </asp:CommandField>
             <asp:TemplateField HeaderText="删除" ShowHeader="False">
                 <ItemStyle HorizontalAlign="Center" />
                 <HeaderStyle HorizontalAlign="Center" />
                 <ItemTemplate>
                     <asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="False" CommandName="Delete"
                        ImageUrl ="~/icons/delete.gif" CommandArgument='<%# Eval("departno") %>' Text="删除" />
                 </ItemTemplate>
             </asp:TemplateField>
        </Columns>
        
        <PagerTemplate>
             <table width="100%">
                 <tr>
                     <td width="70%">
                         <asp:Label ID="MessageLabel" runat="server" Font-Size="Larger" ForeColor="Black"
                            Text ="页码:"></asp:Label>
                         <asp:DropDownList ID="PageDropDownList" runat="server" AutoPostBack="true" OnSelectedIndexChanged="PageDropDownList_SelectedIndexChanged" >
                         </asp:DropDownList>
                         <asp:LinkButton ID="linkBtnFirst" runat="server" CommandArgument="First" CommandName="Page"
                            ForeColor ="Black">首页</asp:LinkButton>
                         <asp:LinkButton ID="linkBtnPrev" runat="server" CommandArgument="Prev" CommandName="Page"
                            ForeColor ="Black">上一页</asp:LinkButton>
                         <asp:LinkButton ID="linkBtnNext" runat="server" CommandArgument="Next" CommandName="Page"
                            ForeColor ="Black">下一页</asp:LinkButton>
                         <asp:LinkButton ID="linkBtnLast" runat="server" CommandArgument="Last" CommandName="Page"
                            ForeColor ="Black">末页</asp:LinkButton>
                     </td>
                     <td align="right" width="70%">
                         <asp:Label ID="CurrentPageLabel" runat="server" ForeColor="black"></asp:Label>
                     </td>
                 </tr>
             </table>
        </PagerTemplate>
        
        <RowStyle BackColor="#EFF3FB" />
        <EditRowStyle BackColor="#2461BF" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>

然后在cs页面里填入事件：

    //删除某一行的时候要提示关键字  不仅是提示确认删除，departno是关键字
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            ImageButton l  = (ImageButton)e.Row.FindControl( "ImageButton1" );
            l.Attributes.Add( "onclick", "javascript: return " +
             "confirm('确认要删除部门编号为   " +
            DataBinder.Eval(e.Row.DataItem,  "departno") + " 的部门吗？" + "')");
        }
    }
}

这样删除的时候就能提示关键字了。

6、显示页码
显示页码要在aspx代码里填入几行数据，上面的代码已经有了 重新写一下：
代码放在 </Columns>下面

         <PagerTemplate>
             <table width="100%">
                 <tr>
                     <td width="70%">
                         <asp:Label ID="MessageLabel" runat="server" Font-Size="Larger" ForeColor="Black"
                            Text ="页码:"></asp:Label>
                         <asp:DropDownList ID="PageDropDownList" runat="server" AutoPostBack="true" OnSelectedIndexChanged="PageDropDownList_SelectedIndexChanged" >
                         </asp:DropDownList>
                         <asp:LinkButton ID="linkBtnFirst" runat="server" CommandArgument="First" CommandName="Page"
                            ForeColor ="Black">首页</asp:LinkButton>
                         <asp:LinkButton ID="linkBtnPrev" runat="server" CommandArgument="Prev" CommandName="Page"
                            ForeColor ="Black">上一页</asp:LinkButton>
                         <asp:LinkButton ID="linkBtnNext" runat="server" CommandArgument="Next" CommandName="Page"
                            ForeColor ="Black">下一页</asp:LinkButton>
                         <asp:LinkButton ID="linkBtnLast" runat="server" CommandArgument="Last" CommandName="Page"
                            ForeColor ="Black">末页</asp:LinkButton>
                     </td>
                     <td align="right" width="70%">
                         <asp:Label ID="CurrentPageLabel" runat="server" ForeColor="black"></asp:Label>
                     </td>
                 </tr>
             </table>
        </PagerTemplate>

然后在gridview的标签里面填入

OnDataBound="CustomersGridView_DataBound"

位置看 5 的代码就可以了。
然后再 cs代码区加入如下代码

//显示页码

    protected void PageDropDownList_SelectedIndexChanged(Object sender, EventArgs e)
    {
        GridViewRow pagerRow  = GridView1.BottomPagerRow;
        DropDownList pageList  = (DropDownList)pagerRow.Cells[ 0].FindControl("PageDropDownList");
        GridView1.PageIndex  = pageList.SelectedIndex;
    }

    protected void CustomersGridView_DataBound(Object sender, EventArgs e)
    {
        try
        {
            GridViewRow pagerRow  = GridView1.BottomPagerRow;

            LinkButton linkBtnFirst  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnFirst");
            LinkButton linkBtnPrev  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnPrev");
            LinkButton linkBtnNext  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnNext");
            LinkButton linkBtnLast  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnLast");

             if (GridView1.PageIndex  == 0)
            {
                linkBtnFirst.Enabled  = false;
                linkBtnPrev.Enabled  = false;
            }
             else if (GridView1.PageIndex  == GridView1.PageCount - 1)
            {
                linkBtnLast.Enabled  = false;
                linkBtnNext.Enabled  = false;
            }
             else if (GridView1.PageCount  <= 0)
            {
                linkBtnFirst.Enabled  = false;
                linkBtnPrev.Enabled  = false;
                linkBtnNext.Enabled  = false;
                linkBtnLast.Enabled  = false;
            }
            DropDownList pageList  = (DropDownList)pagerRow.Cells[ 0].FindControl("PageDropDownList");
            Label pageLabel  = (Label)pagerRow.Cells[0].FindControl("CurrentPageLabel");

             if (pageList != null)
            {
                 for (int i = 0; i < GridView1.PageCount; i ++)
                {
                     int pageNumber = i + 1;
                    ListItem item  = new ListItem(pageNumber.ToString()  + "/" + GridView1.PageCount.ToString(), pageNumber.ToString());
                     if (i == GridView1.PageIndex)
                    {
                        item.Selected  = true;
                    }
                    pageList.Items.Add(item);
                }
            }
             if (pageLabel != null)
            {
                 int currentPage = GridView1.PageIndex + 1;
                pageLabel.Text  = "当前页： " + currentPage.ToString()  +
                   " / " + GridView1.PageCount.ToString();
            }
        }
        catch 
        {
            Response.Write( "现在还没有该部门的记录！！");
        }
    }

如果发生异常，是应为没有数据。这时候可以在catch里面提示没有数据。这样就可以绑定页码了。
但是这样做的条件是没有把绑定数据放在 （!ispostback）里面，如果放在里面了，就会出问题
因为页面的代码实际上是控制显示第几页。但是绑定数据放在了！ispostback里面了，所以不能重新绑定。
这样的情况，要写那个绑定的方法。
然后在cs文件里写下面的代码：

    protected void PageDropDownList_SelectedIndexChanged(Object sender, EventArgs e)
    {
        GridViewRow pagerRow  = GridView1.BottomPagerRow;
        DropDownList pageList  = (DropDownList)pagerRow.Cells[ 0].FindControl("PageDropDownList");
        GridView1.PageIndex  = pageList.SelectedIndex;
        gridviewband(); ///重新绑定数据，这是特殊的地方
    }

    protected void CustomersGridView_DataBound(Object sender, EventArgs e)
    {
        try
        {
            GridViewRow pagerRow  = GridView1.BottomPagerRow;

            LinkButton linkBtnFirst  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnFirst");
            LinkButton linkBtnPrev  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnPrev");
            LinkButton linkBtnNext  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnNext");
            LinkButton linkBtnLast  = (LinkButton)pagerRow.Cells[ 0].FindControl("linkBtnLast");

             if (GridView1.PageIndex  == 0)
            {
                linkBtnFirst.Enabled  = false;
                linkBtnPrev.Enabled  = false;
            }
             else if (GridView1.PageIndex  == GridView1.PageCount - 1)
            {
                linkBtnLast.Enabled  = false;
                linkBtnNext.Enabled  = false;
            }
             else if (GridView1.PageCount  <= 0)
            {
                linkBtnFirst.Enabled  = false;
                linkBtnPrev.Enabled  = false;
                linkBtnNext.Enabled  = false;
                linkBtnLast.Enabled  = false;
            }
            DropDownList pageList  = (DropDownList)pagerRow.Cells[ 0].FindControl("PageDropDownList");
            Label pageLabel  = (Label)pagerRow.Cells[0].FindControl("CurrentPageLabel");

             if (pageList != null)
            {
                 for (int i = 0; i < GridView1.PageCount; i ++)
                {
                     int pageNumber = i + 1;
                    ListItem item  = new ListItem(pageNumber.ToString()  + "/" + GridView1.PageCount.ToString(), pageNumber.ToString());
                     if (i == GridView1.PageIndex)
                    {
                        item.Selected  = true;
                    }
                    pageList.Items.Add(item);
                }
            }
             if (pageLabel != null)
            {
                 int currentPage = GridView1.PageIndex + 1;
                pageLabel.Text  = "当前页： " + currentPage.ToString()  +
                   " / " + GridView1.PageCount.ToString();
            }
        }
        catch //(Exception ex5)
        {
            Response.Write( "现在还没有该部门的记录！！");
        }
    }
        protected void GridView1_PageIndexChanging( object sender, GridViewPageEventArgs e)
    {
        
        GridView1.PageIndex  = e.NewPageIndex;
        gridviewband(); //重新绑定数据
    }

这样就可以显示了 如果按照前面的方法会提示没有  pageindexchanging事件。