Hi,
I made a detailsview for inserting records.
I also made a gridview for editing and deleting the same records.
The keyfield is an autonumbering field in Access (pcnr).
My problem is: I can see the new inserted records in the gridview but I
can't delete or edit them. When clicking on delete or edit link, nothing
happens (no error either). All the others records (not inserted via the
detailsview) can be edited and deleted.
Thanks for help
Marc
Here part of my code with the gridview:
---------------------------------------
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConflictDetecti on="CompareAllV alues"
ConnectionStrin g="Provider=Mic rosoft.Jet.OLED B.4.0;Data Source=C:\mydb"
DeleteCommand=" DELETE FROM [pc] WHERE [pcnr] = ? AND [naam] = ? AND
[defect] = ? AND [type] = ? AND [software] = ? AND [lokaal] = ?"
InsertCommand=" INSERT INTO [pc] ([pcnr], [naam], [defect], [type],
[software], [lokaal]) VALUES (?, ?, ?, ?, ?, ?)"
OldValuesParame terFormatString ="original_{ 0}"
ProviderName="S ystem.Data.OleD b"
SelectCommand=" SELECT * FROM [pc]" UpdateCommand=" UPDATE [pc] SET [naam]
= ?, [defect] = ?, [type] = ?, [software] = ?, [lokaal] = ? WHERE [pcnr] = ?
AND [naam] = ? AND [defect] = ? AND [type] = ? AND [software] = ? AND
[lokaal] = ?">
<DeleteParamete rs>
<asp:Paramete r Name="original_ pcnr" Type="Int32" />
<asp:Paramete r Name="original_ naam" Type="String" />
<asp:Paramete r Name="original_ defect" Type="Boolean" />
<asp:Paramete r Name="original_ type" Type="String" />
<asp:Paramete r Name="original_ software" Type="String" />
<asp:Paramete r Name="original_ lokaal" Type="String" />
</DeleteParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="naam" Type="String" />
<asp:Paramete r Name="defect" Type="Boolean" />
<asp:Paramete r Name="type" Type="String" />
<asp:Paramete r Name="software" Type="String" />
<asp:Paramete r Name="lokaal" Type="String" />
<asp:Paramete r Name="original_ pcnr" Type="Int32" />
<asp:Paramete r Name="original_ naam" Type="String" />
<asp:Paramete r Name="original_ defect" Type="Boolean" />
<asp:Paramete r Name="original_ type" Type="String" />
<asp:Paramete r Name="original_ software" Type="String" />
<asp:Paramete r Name="original_ lokaal" Type="String" />
</UpdateParameter s>
</asp:SqlDataSour ce>
<asp:GridView ID="GridView1" runat="server" AllowPaging="Tr ue"
AllowSorting="T rue" PageSize="14" width="990px"
AutoGenerateCol umns="False" CellPadding="4" DataKeyNames="p cnr"
DataSourceID="S qlDataSource1"
ForeColor="#333 333" GridLines="None ">
<Columns>
<asp:CommandFie ld ShowEditButton= "True" />
<asp:TemplateFi eld>
<ItemTemplate >
<asp:LinkButt on ID="lb1" runat="server"
OnClientClick=" return confirm(yes?'); "
CommandName="De lete">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateFie ld>
<asp:BoundFie ld DataField="pcnr " HeaderText="pcn r"
InsertVisible=" False" ReadOnly="True"
SortExpression= "pcnr" />
<asp:BoundFie ld DataField="naam " HeaderText="naa m"
SortExpression= "naam" />
<asp:CheckBoxFi eld DataField="defe ct" HeaderText="def ect"
SortExpression= "defect" />
<asp:BoundFie ld DataField="type " HeaderText="typ e"
SortExpression= "type" />
<asp:BoundFie ld DataField="soft ware" HeaderText="sof tware"
SortExpression= "software" />
<asp:BoundFie ld DataField="loka al" HeaderText="lok aal"
SortExpression= "lokaal" />
</Columns>
</asp:GridView>
