coolite 更新删除修改

最新推荐文章于 2019-08-02 01:38:20 发布

weixin_30736301

最新推荐文章于 2019-08-02 01:38:20 发布

阅读量39

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/AndySong/archive/2009/11/01/1593788.html

本文介绍了一个使用Ajax进行数据增删改操作的例子，并演示了如何在GridPanel中与SqlDataSource配合使用，实现数据的动态更新。特别注意，在演示插入操作时，必须将Region设置为'AL'，否则会触发自定义数据验证并返回错误信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

< ext : Column DataIndex = "ContactName" Header = "Contact Name" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField2" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "ContactTitle" Header = "Contact Title" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField3" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "Address" Header = "Address" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField4" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "City" Header = "City" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField5" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "Region" Header = "Region" Width = "200" >
                                                < Editor >
                                                    < ext : ComboBox ID = "cbStates" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "PostalCode" Header = "Postal Code" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField7" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "Country" Header = "Country" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField8" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >
                                            < ext : Column DataIndex = "Phone" Header = "Phone" >
                                                < Editor >
                                                    < ext : TextField ID = "TextField9" runat = "server" />
                                                </ Editor >
                                            </ ext : Column >

                                            <ext:Column DataIndex="Fax" Header="Fax">
                                                <Editor>
                                                    <ext:TextField ID="TextField10" runat="server" />
                                                </Editor>
                                            </ext:Column>
                                        </Columns>
                                    </ColumnModel>
                                    <SelectionModel>
                                        <ext:RowSelectionModel runat="server"/>
                                    </SelectionModel>
                                    <BottomBar>
                                        <ext:PagingToolBar ID="PagingToolBar1" runat="server" PageSize="10" StoreID="Store1" DisplayInfo="false" />
                                    </BottomBar>
                                    <SaveMask ShowMask="true" />
                                    <LoadMask ShowMask="true" />
                                </ext:GridPanel>
                            </ext:FitLayout>
                        </Body>
                         <Buttons>

        <SortInfo Field="CompanyName" Direction="ASC" />
        <Listeners>
            <LoadException Handler="Ext.Msg.alert('Suppliers - Load failed', e.message || e )" />
            <CommitFailed Handler="Ext.Msg.alert('Suppliers - Commit failed', 'Reason: ' + msg)" />
            <SaveException Handler="Ext.Msg.alert('Suppliers - Save failed', e.message || e)" />
            <CommitDone Handler="Ext.Msg.alert('Suppliers - Commit', 'The data successfully saved');" />
        </Listeners>
    </ext:Store>

    <ext:ViewPort ID="ViewPort1" runat="server" >
        <Body>
            <ext:BorderLayout runat="server">
                <North MarginsSummary="5 5 5 5">
                    <ext:Panel runat="server" Title="Description" Height="100" BodyStyle="padding: 5px;"
                        Frame="true" Icon="Information">
                        <Body>
                            Example - Ajax update (insert/delete/update) with SqlDataSource.
                            <br />
                            For demo purpose when insert action perfoms, the Region must be "AL" otherwise
                            custom data validation will fail and return error message.
                        </Body>
                    </ext:Panel>
                </North>
                <Center MarginsSummary="0 5 0 5">
                    <ext:Panel ID="Panel1" runat="server" Height="300" Header="false">
                        <Body>
                            <ext:FitLayout ID="FitLayout1" runat="server">
                                <ext:GridPanel ID="GridPanel1" runat="server" Title="Suppliers" AutoExpandColumn="CompanyName"
                                    StoreID="Store1" Border="false" Icon="Lorry">
                                    <ColumnModel runat="server">
                                        <Columns>
                                            <ext:Column ColumnID="CompanyName" DataIndex="CompanyName" Header="Company Name">
                                                <Editor>
                                                    <ext:TextField ID="TextField1" runat="server" />
                                                </Editor>
                                            </ext:Column>