Adding new row results in 2 entries for that same row in the database. Using a submit button to refresh.
I'm not quite sure what you're asking. Can you elaborate on what you're doing?
Hi I am using Infragistics11.1. I have a Webdata grid. I try to add a row to the table at the bottom of the grid. I get to the last field I hit enter. It duplicates the record twice in the database. You can see this in teh last 3 records entered it is duplicating them.
Here is the code.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="testing.aspx.cs" Inherits="FPR.Maintenance.testing" %>
<%@ Register assembly="Infragistics35.Web.v11.1, Version=11.1.20111.1006, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.Web.UI.GridControls" tagprefix="ig" %><%@ Register assembly="Infragistics35.Web.v11.1, Version=11.1.20111.1006, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.Web.UI" tagprefix="ig" %>
<!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>Untitled Page</title></head><body> <form id="form1" runat="server"> <div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:FCRRConnectionString %>" SelectCommand="SELECT [PK_staticDocumentID], [bActive], [DocType], [DocName], [bMerged] FROM [tblDocuments_Static]" DeleteCommand="DELETE FROM [tblDocuments_Static] WHERE [PK_staticDocumentID] = @PK_staticDocumentID" InsertCommand="INSERT INTO [tblDocuments_Static] ([bActive], [DocType], [DocName], [bMerged]) VALUES (@bActive, @DocType, @DocName, @bMerged)" UpdateCommand="UPDATE [tblDocuments_Static] SET [bActive] = @bActive, [DocType] = @DocType, [DocName] = @DocName, [bMerged] = @bMerged WHERE [PK_staticDocumentID] = @PK_staticDocumentID"> <DeleteParameters> <asp:Parameter Name="PK_staticDocumentID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="bActive" Type="Boolean" /> <asp:Parameter Name="DocType" Type="String" /> <asp:Parameter Name="DocName" Type="String" /> <asp:Parameter Name="bMerged" Type="Boolean" /> <asp:Parameter Name="PK_staticDocumentID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="bActive" Type="Boolean" /> <asp:Parameter Name="DocType" Type="String" /> <asp:Parameter Name="DocName" Type="String" /> <asp:Parameter Name="bMerged" Type="Boolean" /> </InsertParameters> </asp:SqlDataSource> <ig:WebDataGrid ID="WebDataGrid1" runat="server" AutoGenerateColumns="False" DataKeyFields="PK_staticDocumentID" DataSourceID="SqlDataSource1" Height="350px" Width="400px"> <Columns> <ig:BoundDataField DataFieldName="PK_staticDocumentID" Hidden="True" Key="PK_staticDocumentID"> <header text="PK_staticDocumentID" /> </ig:BoundDataField> <ig:BoundCheckBoxField DataFieldName="bActive" Key="bActive"> <header text="bActive" /> </ig:BoundCheckBoxField> <ig:BoundDataField DataFieldName="DocType" Key="DocType"> <header text="DocType" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="DocName" Key="DocName"> <header text="DocName" /> </ig:BoundDataField> <ig:BoundCheckBoxField DataFieldName="bMerged" Key="bMerged"> <header text="bMerged" /> </ig:BoundCheckBoxField> </Columns> <behaviors> <ig:EditingCore> <behaviors> <ig:CellEditing> </ig:CellEditing> <ig:RowAdding> <columnsettings> <ig:RowAddingColumnSetting ColumnKey="bActive" DefaultValueAsString="true" /> <ig:RowAddingColumnSetting ColumnKey="bMerged" DefaultValueAsString="true" /> </columnsettings> </ig:RowAdding> </behaviors> </ig:EditingCore> <ig:Selection> </ig:Selection> </behaviors> </ig:WebDataGrid> <ig:WebScriptManager ID="WebScriptManager1" runat="server"> </ig:WebScriptManager> </div> <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" /> </form></body></html>
Hi bridsimon,
I was able to successfully reproduce the issue you were seeing. It had to do when pressing enter on the checkbox column that was last, right? I have submitted this issue internally as 81094. It has been fixed and should be resolved in the next Service Release.
Thanks for pointing out this issue.
regards,
David Young
Yes correct, it double entries when the checkbox column is last. When do you expect the service release for this fix to be available?
Much Obliged.
Hello Brid,
I’ve created a case with number CAS-68350-NPRQX0 on your behalf and linked the logged developer issue with it. You can now track it’s progress.
The development issue is resolved and is awaiting the new release.
The release date for the next service pack is not set yet but you could track the dates for the newest releases at:
http://ko.infragistics.com/support/service-releases.aspx#ServiceReleases
Maya Kirova
Developer Support Engineer
Infragistics, Inc.
http://ko.infragistics.com/support
I'm just following up to see if you need further assistance regarding this issue.
If so don't hesitate to ask for assistance.
Best Regards,