关闭

GridView与UpdatePanel组合无刷新分页

1924人阅读 评论(0) 收藏 举报

这个类子很简单,我把他放最前面。

拖这三控件,ScriptManager、UpdatePanel、GridView,其中GridView放在UpdatePanel里面。设置UpdatePanel的Triggers属性,分别绑定GridView的分页、删除、更新、编辑事件。OK。GridView怎么使用,我就不说了,不会的话去找找资料看看。如下:

<Triggers>
    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="PageIndexChanging" />
    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowDeleting" />
    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowUpdating" />
    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowEditing" />
</Triggers>

所有代码如下:

<asp:ScriptManager runat="server"  />

            <asp:UpdatePanel runat="server">

                <ContentTemplate>

                    <asp:SqlDataSource runat="server" ConnectionString="<%$ ConnectionStrings:AjaxDbConnectionString %>"

                        SelectCommand="SELECT [id], [namer], [title], [content] FROM [userid]"

                        DeleteCommand="DELETE FROM userid WHERE id=@id"

                        UpdateCommand="UPDATE userid SET [namer]=@namer,[title]=@title,[content]=@content WHERE id=@id">

                        <DeleteParameters>

                            <asp:Parameter />

                        </DeleteParameters>

                        <UpdateParameters>

                            <asp:Parameter />

                            <asp:Parameter />

                            <asp:Parameter />

                        </UpdateParameters>

                        </asp:SqlDataSource>

                    <asp:GridView runat="server" AllowPaging="True" AutoGenerateColumns="False"

                        BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"

                        CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1" PageSize="2">

                        <FooterStyle BackColor="White" ForeColor="#000066" />

                        <Columns>

                            <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"

                                SortExpression="id" />

                            <asp:BoundField DataField="namer" HeaderText="namer" SortExpression="namer" />

                            <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />

                            <asp:BoundField DataField="content" HeaderText="content" SortExpression="content" />

                            <asp:CommandField ShowDeleteButton="True" />

                            <asp:CommandField ShowEditButton="True" />

                        </Columns>

                        <RowStyle ForeColor="#000066" />

                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />

                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />

                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />

                    </asp:GridView>

                </ContentTemplate>

                <Triggers>

                    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="PageIndexChanging" />

                    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowDeleting" />

                    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowUpdating" />

                    <asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowEditing" />

                </Triggers>

            </asp:UpdatePanel>

OK。测试通过!

 
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:177937次
    • 积分:3037
    • 等级:
    • 排名:第11537名
    • 原创:107篇
    • 转载:88篇
    • 译文:0篇
    • 评论:28条
    最新评论