beta 2 gridview edit problem

[Mike P]

I am trying to create a simple editable gridview and I can't get my code
to work :

<asp:GridView ID="GridView1" Width=500px
DataSourceID="SqlDataSource1"
CellPadding="3"
Font-Names="arial"
Font-Size="8pt"
HeaderStyle-BackColor="#dcdcdc"
HeaderStyle-Font-Bold="true"
HeaderStyle-ForeColor="#00015E"
FooterStyle-BackColor="#CCCCCC"
SelectedRowStyle-BackColor="#FFFFFF"
PagerStyle-BackColor=Gray
PagerSettings-Mode=NumericFirstLast
BackColor="#0066CC"
Forecolor="white"
PageSize="10"
AllowPaging=true
AllowSorting=true
AutoGenerateColumns=false
DataKeyNames="CompanyID"
EditRowStyle-BackColor=Gold
EditRowStyle-Font-Names="Arial"
EditRowStyle-ForeColor=Black
Runat="server">
<Columns>
<asp:BoundField Visible=false DataField="CompanyID"
ReadOnly=true />
<asp:BoundField HeaderText="Company Name"
DataField="CompanyName" SortExpression="CompanyName" />
<asp:BoundField HeaderText="Location"
DataField="CompanyLocation" SortExpression="CompanyLocation" />
<asp:CheckBoxField HeaderText="Delivery"
DataField="Delivery" SortExpression="Delivery" />
<asp:BoundField HeaderText="Established"
DataField="DateEstablished" SortExpression="DateEstablished" />
<asp:BoundField HeaderImageUrl="~/Images/globe.jpg"
DataField="Country" SortExpression="Country" NullDisplayText="N/A" />
<asp:CommandField ShowEditButton=true ButtonType=Button
/>
<asp:CommandField ShowDeleteButton=true
ButtonType=Button />
</Columns>
</asp:GridView><BR />

<asp:DetailsView ID="DetailsView1"
DataSourceID="SqlDataSource1"
AllowPaging=true
Runat="server">
</asp:DetailsView>

<asp:SqlDataSource ID="SqlDataSource1" runat=server
SelectCommand="SELECT * FROM COMPANY"
ProviderName="<%$ ConnectionStrings:ourco.providerName %>"
ConnectionString="<%$ ConnectionStrings:ourco%>"
UpdateCommand="UPDATE Company SET CompanyName = @CompanyName,
CompanyLocation = @CompanyLocation,
Delivery = @Delivery, DateEstablished =
@DateEstablished, Country = @Country
WHERE CompanyID = @CompanyID"
DeleteCommand="DELETE FROM Company WHERE CompanyID =
@CompanyID">
<UpdateParameters>
<asp:Parameter Name="CompanyID" Type=Int32 />
<asp:Parameter Name="CompanyName" Type=String />
<asp:Parameter Name="CompanyLocation" Type=String />
<asp:Parameter Name="Delivery" Type=Boolean />
<asp:Parameter Name="DateEstablished" Type=DateTime />
<asp:Parameter Name="Country" Type=String />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="CompanyID" Type=Int32 />
</DeleteParameters>
</asp:SqlDataSource>

When I try to do an edit on a row I get the error :

Must declare the scalar variable "@CompanyID"

And when I try to delete a row, I don't get an error but nothing
happens. Does anybody have any ideas what I am doing wrong?
Cheers,

Mike

*** Sent via Developersdex http://www.developersdex.com ***