public partial class kqmanage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            BindGrid();

    }
    private void BindGrid()
    {
        string str = ConfigurationSettings.AppSettings["dsn"];
        SqlConnection cn = new SqlConnection(str);
        cn.Open();
        String mysql = "select * from kq";
        SqlDataAdapter da = new SqlDataAdapter(mysql, cn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        GridView1.DataBind();
        cn.Close();

    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        BindGrid();//重新绑定记录
    }
   
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //GridView gv = (GridView)sender;
        //string aa = e.RowIndex.ToString();
        //string id = gv.DataKeys[e.RowIndex].ToString();
    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex = e.NewEditIndex;
        BindGrid();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

    }
    //当取消时触发
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex = -1;
        BindGrid();
    }
    protected void LinkButton8_Click(object sender, EventArgs e)
    {
        Response.Redirect("kamanageadd.aspx");

    }
   
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            int vardid = Convert.ToInt32(txt_kid.Text.ToString());
            Response.Redirect("kpmodify.aspx?kid=" + vardid);
        }
        catch
        {
            Response.Write("输入的编号不正确");
            Response.End();
        }

    }
}

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="None"
            BorderWidth="1px" CellPadding="4" DataKeyNames="kid" DataSourceID="SqlDataSource1"
            OnSelectedIndexChanged="GridView1_SelectedIndexChanged" PageSize="5" Style="z-index: 109;
            left: 140px; position: absolute; top: 148px" Width="396px" HorizontalAlign="Left">
            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
            <Columns>
                <asp:BoundField DataField="kid" HeaderText="kid" ReadOnly="True" SortExpression="kid" />
                <asp:BoundField DataField="uid" HeaderText="uid" SortExpression="uid" />
                <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" />
                <asp:BoundField DataField="kqdate" HeaderText="kqdate" SortExpression="kqdate" />
                <asp:BoundField DataField="dgdate" HeaderText="dgdate" SortExpression="dgdate" />
                <asp:BoundField DataField="cq" HeaderText="cq" SortExpression="cq" />
                <asp:BoundField DataField="sj" HeaderText="sj" SortExpression="sj" />
                <asp:BoundField DataField="bj" HeaderText="bj" SortExpression="bj" />
                <asp:BoundField DataField="gj" HeaderText="gj" SortExpression="gj" />
                <asp:BoundField DataField="kg" HeaderText="kg" SortExpression="kg" />
                <asp:BoundField DataField="hj" HeaderText="hj" SortExpression="hj" />
                <asp:BoundField DataField="sj1" HeaderText="sj1" SortExpression="sj1" />
                <asp:BoundField DataField="gxj" HeaderText="gxj" SortExpression="gxj" />
                <asp:BoundField DataField="tqj" HeaderText="tqj" SortExpression="tqj" />
                <asp:BoundField DataField="pc" HeaderText="pc" SortExpression="pc" />
                <asp:BoundField DataField="cc" HeaderText="cc" SortExpression="cc" />
                <asp:BoundField DataField="dx" HeaderText="dx" SortExpression="dx" />
                <asp:CommandField ShowEditButton="True" />
                <asp:CommandField ShowDeleteButton="True" />
            </Columns>
            <RowStyle BackColor="White" ForeColor="#330099" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
            <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:kqConnectionString %>"
            SelectCommand="SELECT [kid], [uid], [uname], [kqdate], [dgdate], [cq], [sj], [bj], [gj], [kg], [hj], [sj1], [gxj], [tqj], [pc], [cc], [dx] FROM [kaoqin]">
        </asp:SqlDataSource>
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        &nbsp;&nbsp;
        <asp:Table ID="Table3" runat="server" Height="368px" Style="z-index: 110; left: 26px;
            position: absolute; top: 125px" Width="112px" HorizontalAlign="Left" GridLines="Horizontal">
            <asp:TableRow runat="server">
                <asp:TableCell runat="server" Height="20px" HorizontalAlign="Center" VerticalAlign="Middle">
                <asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="adminmassage.aspx">人员管理信息</asp:LinkButton>
           </asp:TableCell>
            </asp:TableRow>
            <asp:TableRow runat="server">
            </asp:TableRow>
            <asp:TableRow runat="server">
                <asp:TableCell runat="server"><asp:LinkButton ID="LinkButton2" runat="server" PostBackUrl="demanage.aspx">部门信息管理</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            <asp:TableRow runat="server">
            </asp:TableRow>
            <asp:TableRow runat="server">
                <asp:TableCell runat="server"><asp:LinkButton ID="LinkButton3" runat="server" PostBackUrl="kqmanage.aspx">考勤信息管理</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            <asp:TableRow runat="server">
            </asp:TableRow>
            <asp:TableRow ID="TableRow1" runat="server">
                <asp:TableCell ID="TableCell1" runat="server"><asp:LinkButton ID="LinkButton7" runat="server" PostBackUrl="jbmanage.aspx">加班信息管理</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            <asp:TableRow ID="TableRow2" runat="server">
                <asp:TableCell ID="TableCell2" runat="server"><asp:LinkButton ID="LinkButton9" runat="server" PostBackUrl="zbmanage.aspx">值班信息管理</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            <asp:TableRow runat="server">
                <asp:TableCell runat="server"><asp:LinkButton ID="LinkButton4" runat="server" PostBackUrl="usermanage.aspx">用户信息管理</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            <asp:TableRow runat="server">
            </asp:TableRow>
            <asp:TableRow runat="server">
                <asp:TableCell runat="server"><asp:LinkButton ID="LinkButton5" runat="server" PostBackUrl="usermodify.aspx" >个人密码修改</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            <asp:TableRow runat="server">
            </asp:TableRow>
            <asp:TableRow runat="server">
                <asp:TableCell runat="server" HorizontalAlign="Center" VerticalAlign="Middle"><asp:LinkButton ID="LinkButton6" runat="server" PostBackUrl="Default2.aspx">注销</asp:LinkButton></asp:TableCell>
            </asp:TableRow>
            
        </asp:Table>

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        BindGrid();//重新绑定记录
    }

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        BindGrid();//重新绑定记录
    }

<asp:GridView AllowPaging="True" PageSize="5" onpageindexchanging="GridView1_PageIndexChanging".............>

[ 本帖最后由 foktime 于 2010-8-16 17:06 编辑 ]

谢谢了，可以了