What's New?

[CLOSED] Save Data in grid, with StoreProcedure

  1. #1
    Jan 26, 2009, 4:34 AM

    [CLOSED] Save Data in grid, with StoreProcedure

    Hi I have a grid that I fill with data from a Store procedure, this works fine. Then I made a an other store procedure to save the data. This I dont get to work. If I put the code from the save store procedure, directly in the update command it works.
    Do you know if this is suppose to work?
    I will post a simplyfied example in a while.

    /Mikael
  2. #2
    Jan 26, 2009, 6:34 AM

    RE: [CLOSED] Save Data in grid, with StoreProcedure

    Hi Mikael,

    I modified example to using stored procedures
    https://examples1.ext.net/#/GridPanel/DataSource_Update/SqlDataSource/


    It works fine. You can test below code putting it to the Examples Explorer. May be you SP raise SQL exception or something else. You can try possible exception under debug (in VS press Ctrl-Alt-E and check 'Common Language Runtime Exceptions', then run example and try save data)


    Here is my test example:
    <%@ Page Language="C#" %>
<%@ Import Namespace="System.Xml"%>


<%@ Register Assembly="Coolite.Ext.Web" Namespace="Coolite.Ext.Web" TagPrefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
** *<title>Coolite Toolkit - AJAX GridPanel with details</title>
** *<script runat="server">
** * * *protected void Page_Load(object sender, EventArgs e)
** * * *{
** * * * * *XmlDocument xml = new XmlDocument();
** * * * * *xml.Load(Server.MapPath("States.xml"));


** * * * * *foreach (XmlNode state in xml.SelectNodes("states/state"))
** * * * * *{
** * * * * * * *this.cbStates.Items.Add(new Coolite.Ext.Web.ListItem(state.Attributes["label"].InnerText, state.Attributes["data"].InnerText));
** * * * * *}
** * * *}
** * * *
** * * *protected void Store1_RefershData(object sender, StoreRefreshDataEventArgs e)
** * * *{
** * * * * *this.Store1.DataBind();
** * * *}
** *</script>
</head>
<body>
** *<form id="form1" runat="server">
** *<ext:ScriptManager ID="ScriptManager1" runat="server" StateProvider="None" />
** *
** *<asp:SqlDataSource ID="SqlDataSource1" runat="server"*
** * * *ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
** * * *DeleteCommand="Suppliers_Delete"
** * * *InsertCommand="Suppliers_Insert" * * * * * * * * * * * *
** * * *SelectCommand="Suppliers_Select_All" * * * * * * * * * * **
** * * *UpdateCommand="Suppliers_Update"
** * * * * * * * * * **
** * * *DeleteCommandType="StoredProcedure"*
** * * *InsertCommandType="StoredProcedure"*
** * * *SelectCommandType="StoredProcedure"*
** * * *UpdateCommandType="StoredProcedure">
** * * *
** * * *<DeleteParameters>
** * * * * *<asp:Parameter Name="SupplierID" Type="Int32" />
** * * *</DeleteParameters>
** * * *
** * * *<UpdateParameters>
** * * * * *<asp:Parameter Name="SupplierID" Type="Int32" />
** * * * * *<asp:Parameter Name="CompanyName" Type="String" />
** * * * * *<asp:Parameter Name="ContactName" Type="String" />
** * * * * *<asp:Parameter Name="ContactTitle" Type="String" />
** * * * * *<asp:Parameter Name="Address" Type="String" />
** * * * * *<asp:Parameter Name="City" Type="String" />
** * * * * *<asp:Parameter Name="Region" Type="String" />
** * * * * *<asp:Parameter Name="PostalCode" Type="String" />
** * * * * *<asp:Parameter Name="Country" Type="String" />
** * * * * *<asp:Parameter Name="Phone" Type="String" />
** * * * * *<asp:Parameter Name="Fax" Type="String" />
** * * * * *<asp:Parameter Name="HomePage" Type="String" DefaultValue="" />
** * * *</UpdateParameters>
** * * *
** * * *<InsertParameters>
** * * * * *<asp:Parameter Name="CompanyName" Type="String" />
** * * * * *<asp:Parameter Name="ContactName" Type="String" />
** * * * * *<asp:Parameter Name="ContactTitle" Type="String" />
** * * * * *<asp:Parameter Name="Address" Type="String" />
** * * * * *<asp:Parameter Name="City" Type="String" />
** * * * * *<asp:Parameter Name="Region" Type="String" />
** * * * * *<asp:Parameter Name="PostalCode" Type="String" />
** * * * * *<asp:Parameter Name="Country" Type="String" />
** * * * * *<asp:Parameter Name="Phone" Type="String" />
** * * * * *<asp:Parameter Name="Fax" Type="String" />
** * * * * *<asp:Parameter Name="HomePage" Type="String" DefaultValue="" />
** * * *</InsertParameters>
** *</asp:SqlDataSource>
** *
** *<ext:Store ID="Store1" runat="server"*
** * * *DataSourceID="SqlDataSource1"*
** * * *OnRefreshData="Store1_RefershData">
** * * *<Reader>
** * * * * *<ext:JsonReader ReaderID="SupplierID">
** * * * * * * *<Fields>
** * * * * * * * * *<ext:RecordField Name="CompanyName" />
** * * * * * * * * *<ext:RecordField Name="ContactName" />
** * * * * * * * * *<ext:RecordField Name="ContactTitle" />
** * * * * * * * * *<ext:RecordField Name="Address" />
** * * * * * * * * *<ext:RecordField Name="City" />
** * * * * * * * * *<ext:RecordField Name="Region" />
** * * * * * * * * *<ext:RecordField Name="PostalCode" />
** * * * * * * * * *<ext:RecordField Name="Country" />
** * * * * * * * * *<ext:RecordField Name="Phone" />
** * * * * * * * * *<ext:RecordField Name="Fax" />
** * * * * * * *</Fields>
** * * * * *</ext:JsonReader>
** * * *</Reader>
** * * *<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. * * * * * * * * * * * * * *
** * * * * * * * * * * *</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>
** * * * * * * * * * * * * * * * * * * * * *<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>
** * * * * * * * * * * * * *<ext:Button ID="btnSave" runat="server" *Text="Save" Icon="Disk">
** * * * * * * * * * * * * * * *<Listeners>
** * * * * * * * * * * * * * * * * *<Click Handler="#{GridPanel1}.save();" />
** * * * * * * * * * * * * * * *</Listeners>
** * * * * * * * * * * * * *</ext:Button>
** * * * * * * * * * * * * *<ext:Button ID="btnDelete" runat="server" *Text="Delete selected records" Icon="Delete">
** * * * * * * * * * * * * * * *<Listeners>
** * * * * * * * * * * * * * * * * *<Click Handler="#{GridPanel1}.deleteSelected();" />
** * * * * * * * * * * * * * * *</Listeners>
** * * * * * * * * * * * * *</ext:Button>
** * * * * * * * * * * * * *<ext:Button ID="btnInsert" runat="server" *Text="Insert" Icon="Add">
** * * * * * * * * * * * * * * *<Listeners>
** * * * * * * * * * * * * * * * * *<Click Handler="#{GridPanel1}.insertRecord(0, {});#{GridPanel1}.getView().focusRow(0);#{GridPanel1}.startEditing(0, 0);" />
** * * * * * * * * * * * * * * *</Listeners>
** * * * * * * * * * * * * *</ext:Button>
** * * * * * * * * * * * * *<ext:Button ID="btnRefresh" runat="server" *Text="Refresh" Icon="ArrowRefresh">
** * * * * * * * * * * * * * * *<Listeners>
** * * * * * * * * * * * * * * * * *<Click Handler="#{GridPanel1}.reload();" />
** * * * * * * * * * * * * * * *</Listeners>
** * * * * * * * * * * * * *</ext:Button> * * * * * * * * * * **
** * * * * * * * * * * *</Buttons>
** * * * * * * * * *</ext:Panel>
** * * * * * * *</Center> * * * * * **
** * * * * *</ext:BorderLayout>
** * * *</Body>
** *</ext:ViewPort>
** *</form>
</body>
</html>



  3. #3
    Jan 28, 2009, 4:00 AM

    RE: [CLOSED] Save Data in grid, with StoreProcedure

    Hi
    Thanks for the example! I will look in to this later on. You can mark this as solved
    /Mikael

Similar Threads

  1. [CLOSED] What would be the most efficient way to loop through a Grid with Data and save it to an Object ?
    By Fahd in forum 2.x Legacy Premium Help
    Replies: 3
    Last Post: Jun 26, 2012, 2:32 PM
  2. How to save grid panel layout (save column order, column positions etc.) ?
    By teo80 in forum 1.x Help
    Replies: 1
    Last Post: Jul 27, 2011, 10:19 AM
  3. Save data from two GridPanels
    By Dominik in forum 1.x Help
    Replies: 15
    Last Post: May 11, 2011, 2:43 PM
  4. How to save data using a Grid and Form detail
    By FlorMariaF in forum 1.x Help
    Replies: 0
    Last Post: Jan 19, 2010, 1:02 PM
  5. How to save the many data
    By wkcode in forum 1.x Help
    Replies: 1
    Last Post: Feb 28, 2009, 3:39 AM

Posting Permissions