deletecommand problem

Stelly · 21 Feb 2007 at 15:32

I have this...
<form id="form1" runat="server">
<div>
<asp:GridView ID="AdminGridView" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" DataSourceID="EventDataSource">
<Columns>
<asp:BoundField DataField="PriKey" HeaderText="ID No" />
<asp:BoundField DataField="Typage" HeaderText="Type" />
<asp:BoundField DataField="UserName" HeaderText="UserName" />
<asp:BoundField DataField="BookedFrom" HeaderText="From" />
<asp:BoundField DataField="BookedUntill" HeaderText="Untill" />
<asp:BoundField DataField="Setup" HeaderText="Set Up?" />
<asp:BoundField DataField="TimeStamp" HeaderText="Time Stamp" />
<asp:BoundField DataField="Approved" HeaderText="Approved?" />
<asp:BoundField DataField="ModelNo" HeaderText="Model No" />
<asp:BoundField DataField="Projector" HeaderText="Projector" />
<asp:BoundField DataField="Status" HeaderText="Status" />
<asp:BoundField DataField="AssignedBy" HeaderText="AssignedBy" />
<asp:BoundField DataField="BookedIn" HeaderText="Booked In" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton ="True" />
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC" />
</asp:GridView>
<asp:SqlDataSource ID="EventDataSource" runat="server" ConnectionString="<%$ appsettings:ConnectionString %>"
SelectCommand="SELECT * FROM [book]" DeleteCommand="DELETE FROM [book] WHERE ([PriKey] = @PriKey)" InsertCommand="INSERT INTO [Events] ([PriKey], [Typage], [Username], [BookedFrom], [BookedUntill], [SetUp], [TimeStamp], [Approved], [ModelNo], [Projector], [Status], [AssignedBy], [BookedIn]) VALUES (@PriKey, @Typage, @username, @BookedFrom, @BookedUntill, @SetUp, @Approved, @ModelNo, @Projector, @Status, @AssignedBy, @BookedIn)" UpdateCommand="UPDATE [book] SET [PriKey] = @PriKey, [Typage] = @Typage, [Username] = @username, [BookedFrom] = @BookedFrom, [BookedUntill] = @BookedUntill, [SetUp] = @SetUp, [TimeStamp] = @TimeStamp, [Approved] = @Approved, [ModelNo] = @ModelNo, [Projector] = @Projector, [Status] = @Status, [AssignedBy] = @AssignedBy, [BookedIn] = @BookedIn WHERE [PriKey] = @PriKey">
<DeleteParameters>
<asp

arameter Name="PriKey" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp

arameter Name="PriKey" Type="Int32" />
<asp

arameter Name="Typage" Type="String" />
<asp

arameter Name="Username" Type="String" />
<asp

arameter Name="BookedFrom" Type="String" />
<asp

arameter Name="BookedUntill" Type="String" />
<asp

arameter Name="SetUp" Type="String" />
<asp

arameter Name="TimeStamp" Type="String" />
<asp

arameter Name="Approved" Type="String" />
<asp

arameter Name="ModelNo" Type="String" />
<asp

arameter Name="Projector" Type="String" />
<asp

arameter Name="Status" Type="String" />
<asp

arameter Name="AssignedBy" Type="String" />
<asp

arameter Name="BookedIn" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp

arameter Name="PriKey" Type="Int32" />
<asp

arameter Name="Typage" Type="String" />
<asp

arameter Name="Username" Type="String" />
<asp

arameter Name="BookedFrom" Type="String" />
<asp

arameter Name="BookedUntill" Type="String" />
<asp

arameter Name="SetUp" Type="String" />
<asp

arameter Name="TimeStamp" Type="String" />
<asp

arameter Name="Approved" Type="String" />
<asp

arameter Name="ModelNo" Type="String" />
<asp

arameter Name="Projector" Type="String" />
<asp

arameter Name="Status" Type="String" />
<asp

arameter Name="AssignedBy" Type="String" />
<asp

arameter Name="BookedIn" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>

and its not deleting throwing this up...

Must declare the scalar variable "@PriKey".
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.Data.SqlClient.SqlException: Must declare the scalar variable "@PriKey".

Source Error:

cheers in advance

Stelly

Stelly · 22 Feb 2007 at 19:23

TrUz said:
Should it no be:

Code:

<asp:Parameter Name="@PriKey" Type="Int32" />

TrUz

hmm will try that but I dont think so

Stelly

Stelly · 23 Feb 2007 at 10:53

Didnt work... any more ideas??

Stelly

Stelly · 23 Feb 2007 at 13:25

figured it out lads... silly me

Code:

<asp:GridView ID="AdminGridView" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" DataSourceID="EventDataSource">

should be

Code:

<asp:GridView ID="AdminGridView" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" DataSourceID="EventDataSource" DataKeyNames="PriKey">

Mr B Gates said:
Gets or sets an array that contains the names of the primary key fields for the items displayed in a GridView control

need to set the primarykey in the gridview... oops!

Thanks anyway

Stelly