beta 2 gridview edit problem

M

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:eek:urco.providerName %>"
ConnectionString="<%$ ConnectionStrings:eek:urco%>"
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top