«

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:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="Provider=Microsoft.Jet.OLEDB.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 (?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}"
ProviderName="System.Data.OleDb"
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] = ?">
<DeleteParameters>
<asparameter Name="original_pcnr" Type="Int32" />
<asparameter Name="original_naam" Type="String" />
<asparameter Name="original_defect" Type="Boolean" />
<asparameter Name="original_type" Type="String" />
<asparameter Name="original_software" Type="String" />
<asparameter Name="original_lokaal" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asparameter Name="naam" Type="String" />
<asparameter Name="defect" Type="Boolean" />
<asparameter Name="type" Type="String" />
<asparameter Name="software" Type="String" />
<asparameter Name="lokaal" Type="String" />
<asparameter Name="original_pcnr" Type="Int32" />
<asparameter Name="original_naam" Type="String" />
<asparameter Name="original_defect" Type="Boolean" />
<asparameter Name="original_type" Type="String" />
<asparameter Name="original_software" Type="String" />
<asparameter Name="original_lokaal" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" PageSize="14" width="990px"
AutoGenerateColumns="False" CellPadding="4" DataKeyNames="pcnr"
DataSourceID="SqlDataSource1"
ForeColor="#333333" GridLines="None">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lb1" runat="server"
OnClientClick="return confirm(yes?');"
CommandName="Delete">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="pcnr" HeaderText="pcnr"
InsertVisible="False" ReadOnly="True"
SortExpression="pcnr" />
<asp:BoundField DataField="naam" HeaderText="naam"
SortExpression="naam" />
<asp:CheckBoxField DataField="defect" HeaderText="defect"
SortExpression="defect" />
<asp:BoundField DataField="type" HeaderText="type"
SortExpression="type" />
<asp:BoundField DataField="software" HeaderText="software"
SortExpression="software" />
<asp:BoundField DataField="lokaal" HeaderText="lokaal"
SortExpression="lokaal" />
</Columns>
</asp:GridView>

I found it.
All the fields must be filled ..


"Marc" <> schreef in bericht
news:%...
> 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:SqlDataSource ID="SqlDataSource1" runat="server"
> ConflictDetection="CompareAllValues"
> ConnectionString="Provider=Microsoft.Jet.OLEDB.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 (?, ?, ?, ?, ?, ?)"
> OldValuesParameterFormatString="original_{0}"
> ProviderName="System.Data.OleDb"
> 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] = ?">
> <DeleteParameters>
> <asparameter Name="original_pcnr" Type="Int32" />
> <asparameter Name="original_naam" Type="String" />
> <asparameter Name="original_defect" Type="Boolean" />
> <asparameter Name="original_type" Type="String" />
> <asparameter Name="original_software" Type="String" />
> <asparameter Name="original_lokaal" Type="String" />
> </DeleteParameters>
> <UpdateParameters>
> <asparameter Name="naam" Type="String" />
> <asparameter Name="defect" Type="Boolean" />
> <asparameter Name="type" Type="String" />
> <asparameter Name="software" Type="String" />
> <asparameter Name="lokaal" Type="String" />
> <asparameter Name="original_pcnr" Type="Int32" />
> <asparameter Name="original_naam" Type="String" />
> <asparameter Name="original_defect" Type="Boolean" />
> <asparameter Name="original_type" Type="String" />
> <asparameter Name="original_software" Type="String" />
> <asparameter Name="original_lokaal" Type="String" />
> </UpdateParameters>
> </asp:SqlDataSource>
>
> <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
> AllowSorting="True" PageSize="14" width="990px"
> AutoGenerateColumns="False" CellPadding="4" DataKeyNames="pcnr"
> DataSourceID="SqlDataSource1"
> ForeColor="#333333" GridLines="None">
> <Columns>
> <asp:CommandField ShowEditButton="True" />
> <asp:TemplateField>
> <ItemTemplate>
> <asp:LinkButton ID="lb1" runat="server"
> OnClientClick="return confirm(yes?');"
> CommandName="Delete">
> </asp:LinkButton>
> </ItemTemplate>
> </asp:TemplateField>
> <asp:BoundField DataField="pcnr" HeaderText="pcnr"
> InsertVisible="False" ReadOnly="True"
> SortExpression="pcnr" />
> <asp:BoundField DataField="naam" HeaderText="naam"
> SortExpression="naam" />
> <asp:CheckBoxField DataField="defect" HeaderText="defect"
> SortExpression="defect" />
> <asp:BoundField DataField="type" HeaderText="type"
> SortExpression="type" />
> <asp:BoundField DataField="software" HeaderText="software"
> SortExpression="software" />
> <asp:BoundField DataField="lokaal" HeaderText="lokaal"
> SortExpression="lokaal" />
> </Columns>
> </asp:GridView>
>
>
>
>