Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
325
Web Data Grid - Batch Updating - Changes not saved to database
posted

Working with WebDataGrid 12.1 (Version=12.1.20121.1005). Have loaded GRID with BatchUpdating="True" and installed a "Save Changes" button.  WebDataGrid is bound to a SqlDataSource control.

Data is retrieved successfully.  When I change one or more rows on the grid and click the "Save Changes' button the values are saved on the grid.  However, when I check the data in the database the rows I changed in the grid are not reflected in the table; the data is unchanged.  When I click the "Save Changes" button a second time it triggers a postback and the data from the table table is loaded in the grid overwriting the changes I made previously.

====================================================================

ENVIRONMENT:  VISUAL STUDIO 2008, VB.NET, ASP.NET Framework 3.5, NetAdvantage Select 2012 Vol. 1

====================================================================

Source code for the grid...

<ig:WebDataGrid ID="wdgReference"
runat="server"
AutoGenerateColumns="False"
AutoCRUD="false"
DataKeyFields="APP,CATEGORY,SUBCATEGORY,KEY,VALUE,CRET_TMSTP"
DataSourceID="SqlDataSource1"
Height="420px"
Width="1091px"
CssClass="accordionHeaderSelected">

<EditorProviders>
<ig:DatePickerProvider ID="ExpirationProvider" />
<ig:DatePickerProvider ID="EffectiveDateProvider" />
<ig:DateTimeEditorProvider ID="EffectiveDate_DateTimeProvider" />
<ig:DateTimeEditorProvider ID="ExpirationDate_DateTimeProvider" />
</EditorProviders>

<Columns>
<ig:BoundDataField DataFieldName="APP" Key="APP">
 <Header Text= "APP" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="CATEGORY" Key="CATEGORY">
 <Header Text= "CATEGORY" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="SUBCATEGORY" Key="SUBCATEGORY">
 <Header Text= "SUBCATEGORY" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="KEY" Key="KEY">
 <Header Text= "KEY" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="VALUE" Key="VALUE">
 <Header Text= "VALUE" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="EFF_DT" Key="EFF_DT">
 <Header Text= "EFF_DT" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="EXP_DT" Key="EXP_DT">
 <Header Text= "EXP_DT" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="COMMENTS" Key="COMMENTS">
 <Header Text= "COMMENTS" />
</ig:BoundDataField>
<ig:BoundDataField DataFieldName="CRET_TMSTP" Key="CRET_TMSTP"
Hidden="true">
 <Header Text="CRET_TMSTP" />
</ig:BoundDataField>
</Columns>

<Behaviors>
 <ig:Activation Enabled="true" />
 <ig:Selection RowSelectType="Multiple" CellClickAction="Row" Enabled="true" />
 <ig:EditingCore BatchUpdating="True">
 <Behaviors>
 <ig:CellEditing EditModeActions-EnableF2="true" EditModeActions-MouseClick="Single"
    Enabled="true">
        <ColumnSettings>
         <ig:EditingColumnSetting ColumnKey="APP" ReadOnly="true" />
         <ig:EditingColumnSetting ColumnKey="CATEGORY" ReadOnly="true" />
         <ig:EditingColumnSetting ColumnKey="SUBCATEGORY" ReadOnly="true" />
         <ig:EditingColumnSetting ColumnKey="KEY" ReadOnly="true" />
         <ig:EditingColumnSetting ColumnKey="EFF_DT" EditorID="EffectiveDateProvider" ReadOnly="false" />
         <ig:EditingColumnSetting ColumnKey="EXP_DT" EditorID="ExpirationProvider" ReadOnly="false" />
        </ColumnSettings>
 <EditModeActions MouseClick="Single" />
</ig:CellEditing>
<ig:RowAdding Alignment="Top" EditModeActions-EnableF2="true" EditModeActions-EnableOnActive="true"
EditModeActions-MouseClick="Single" Enabled="true" >
<EditModeActions EnableOnActive="True" MouseClick="Single" />
</ig:RowAdding>
<ig:RowDeleting Enabled="false" />
</Behaviors>
</ig:EditingCore>
<ig:Paging PageSize="50">
</ig:Paging>
<ig:Sorting SortingMode="Multi">
</ig:Sorting>
<ig:ColumnResizing>

<ColumnSettings>
 <ig:ColumnResizeSetting ColumnKey="CATEGORY" />
 <ig:ColumnResizeSetting ColumnKey="SUBCATEGORY" />
 <ig:ColumnResizeSetting ColumnKey="APP" />
<ig:ColumnResizeSetting ColumnKey="KEY" />
</ColumnSettings>
</ig:ColumnResizing>
</Behaviors>
</ig:WebDataGrid>
==============================================================

Source Code for the SQLDataSource

<asp:SqlDataSource 
  ID="SqlDataSource1"
  runat="server"
  ConnectionString="<%$ ConnectionStrings:webprodConnectionString %>"
  ProviderName="<%$ ConnectionStrings:webprodConnectionString.ProviderName %>"
  UpdateCommand=
    "UPDATE WP.XENIT_TCODES_V2 SET VALUE = ?, COMMENTS = ?, EFF_DT = ?, EXP_DT = ? WHERE APP = ? AND CATEGORY = ? AND SUBCATEGORY = ? AND KEY = ? "
    SelectCommand="SELECT APP, CATEGORY, SUBCATEGORY, KEY, VALUE, COMMENTS, EFF_DT, EXP_DT, CRET_USER_ID, CHAR(CRET_TMSTP) AS CRET_TMSTP FROM WP.XENIT_TCODES_V2 ORDER BY APP, CATEGORY, SUBCATEGORY, KEY, VALUE FOR READ ONLY WITH UR">
  <UpdateParameters>
      <asp:Parameter Name="VALUE" Type="String" />
      <asp:Parameter Name="COMMENTS" Type="String" />
      <asp:Parameter Name="EFF_DT" Type="DateTime" />
      <asp:Parameter Name="EXP_DT" Type="DateTime" />
      <asp:Parameter Name="APP" Type="String" />
      <asp:Parameter Name="CATEGORY" Type="String" />
      <asp:Parameter Name="SUBCATEGORY" Type="String" />
      <asp:Parameter Name="KEY" Type="String" />
  </UpdateParameters>       
</asp:SqlDataSource> 

==============================================================

Any help anyone can provide is greatly appreciated.
Thank you for your help...