I thought I was home free today but alas I was thwarted by Firefox. The following code throws an error in Firefox but works just fine in IE 7.0 Any ideas? I am using the SessionDataSource since I have a page which I want to use a grid but not store any data.
The error thrown is:
Exception Details: System.InvalidOperationException: Unable to locate record to delete. Please asure you have selected the DataKeyNames propery.
Again, it works just perfect in IE 7.0...not in Firefox 3.0.5
The error thrown is:
Unable to locate record to delete. Please asure you have selected the DataKeyNames propery.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: Unable to locate record to delete. Please asure you have selected the DataKeyNames propery.
<cc2:SessionDataSource ID="Asset" runat="server" DisplayWarning="False" ClearSessionOnInitialLoad="True" |
DataFile="~/App_Data/AssetSession.mdb" DeleteCommand="DELETE FROM [Asset] WHERE [ID] = ?" |
InsertCommand="INSERT INTO [Asset] ([ID], [Description], [RMA], [TAG], [PO], [Serial], [Value]) VALUES (?, ?, ?, ?, ?, ?, ?)" |
SelectCommand="SELECT * FROM [Asset]" SessionKey="System.Web.UI.Page_Asset" PrimaryKeyFields="ID" |
UpdateCommand="UPDATE [Asset] SET [Description] = ?, [RMA] = ?, [TAG] = ?, [PO] = ?, [Serial] = ?, [Value] = ? WHERE [ID] = ?"> |
<UpdateParameters> |
<asp:Parameter Name="Description" Type="String" /> |
<asp:Parameter Name="RMA" Type="String" /> |
<asp:Parameter Name="TAG" Type="String" /> |
<asp:Parameter Name="PO" Type="String" /> |
<asp:Parameter Name="Serial" Type="String" /> |
<asp:Parameter Name="Value" Type="String" /> |
<asp:Parameter Name="ID" Type="Int32" /> |
</UpdateParameters> |
<DeleteParameters> |
<asp:Parameter Name="ID" Type="Int32" /> |
</DeleteParameters> |
<InsertParameters> |
<asp:Parameter Name="ID" Type="Int32" /> |
<asp:Parameter Name="Description" Type="String" /> |
<asp:Parameter Name="RMA" Type="String" /> |
<asp:Parameter Name="TAG" Type="String" /> |
<asp:Parameter Name="PO" Type="String" /> |
<asp:Parameter Name="Serial" Type="String" /> |
<asp:Parameter Name="Value" Type="String" /> |
</InsertParameters> |
</cc2:SessionDataSource> |
<telerik:RadGrid ID="assetGrid" runat="server" DataSourceID="Asset" GridLines="None" |
AllowAutomaticInserts="True" Skin="Office2007" AutoGenerateColumns="False" AllowAutomaticDeletes="true"> |
<HeaderContextMenu EnableTheming="True"> |
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
</HeaderContextMenu> |
<ClientSettings> |
<Selecting AllowRowSelect="True" /> |
</ClientSettings> |
<MasterTableView DataKeyNames="ID" DataSourceID="Asset" EditMode="EditForms" CommandItemDisplay="Bottom"> |
<CommandItemTemplate> |
<div class="noprint"> |
<asp:Button ID="btnAdd" runat="server" Text="Add New Item" CommandName="InitInsert"> |
</asp:Button> |
<asp:Button ID="btnDelete" runat="server" Text="Delete Selected Item" ToolTip="Click item to select" CommandName="DeleteSelected"> |
</asp:Button> |
</div> |
</CommandItemTemplate> |
<EditFormSettings> |
<EditColumn UniqueName="InsertCommandColumn" ButtonType="PushButton" InsertText="Insert Item"></EditColumn> |
</EditFormSettings> |
<RowIndicatorColumn> |
<HeaderStyle Width="20px"></HeaderStyle> |
</RowIndicatorColumn> |
<ExpandCollapseColumn> |
<HeaderStyle Width="20px"></HeaderStyle> |
</ExpandCollapseColumn> |
<Columns> |
<telerik:GridBoundColumn DataField="ID" HeaderText="ID" SortExpression="ID" UniqueName="ID" |
DataType="System.Int32" ReadOnly="True"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" SortExpression="Description" |
UniqueName="Description" MaxLength="33"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="RMA" HeaderText="RMA" SortExpression="RMA" UniqueName="RMA" |
MaxLength="18"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="TAG" HeaderText="TAG" SortExpression="TAG" UniqueName="TAG" |
MaxLength="8"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="PO" HeaderText="PO" SortExpression="PO" UniqueName="PO" |
MaxLength="11"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Serial" HeaderText="Serial" SortExpression="Serial" |
UniqueName="Serial" MaxLength="18"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="Value" HeaderText="Value" SortExpression="Value" |
UniqueName="Value" MaxLength="8"> |
</telerik:GridBoundColumn> |
</Columns> |
</MasterTableView> |
<FilterMenu EnableTheming="True"> |
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
</FilterMenu> |
</telerik:RadGrid> |
Again, it works just perfect in IE 7.0...not in Firefox 3.0.5
I have just updated my code with your newer version of the SessionDataSource.cs code (had to convert to vb). and get the same error just in Firefox :( I have put A LOT of time into this project and don't want to see it fail...please help!
Line 252: Dim res As DataRow() = sessionTable.[Select]([select]) |
Line 253: If res.Length <> 1 Then |
Line 254: Throw New InvalidOperationException("Unable to locate record to delete. Please asure you have selected the DataKeyNames propery.") |
Line 255: End If |
Line 256: |