Help porting online demo of Webgrid

[Damian]

Hi,

Looking for some simple support on the webgrid: http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/Programming/WebGrid/DefaultCS.aspx

I'm trying to use this as a demo on my existing DB. I've used my own columns (all gridbound) and the demo EditFormSettings.

The grid displays the values fine (SELECT works) but when I try to edit or delete. I just get the following error:
Incorrect syntax near '?'.

I'm pretty sure there is a easy fix to this. can someone tell me what mistake I'm making. Thanks!

Here is a snippet of my datasourcecode:

       <asp:SqlDataSource ID="SessionDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MarinaConnectionString %>"
            ProviderName="System.Data.SqlClient"
            SelectCommand="SELECT OrderID, FirstName, LastName, Email, Phone, BabyName, BabyAge, DiaperSize, Notes FROM [Orders]"
            DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = ?"
            InsertCommand="INSERT INTO Orders(FirstName, LastName, Email, Phone, BabyName, BabyAge, DiaperSize, Notes) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
            UpdateCommand="UPDATE [Orders] SET [FirstName] = ?, [LastName] = ?, [Email] = ?, [Phone] = ?, [BabyName] = ?, [BabyAge] = ?, [DiaperSize], [Notes] = ? WHERE [OrderID] = ?"
            OldValuesParameterFormatString="original_{0}"
            ConflictDetection="CompareAllValues">
            <DeleteParameters>
                <asp:Parameter Name="OrderID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="FirstName" Type="String" />
                <asp:Parameter Name="LastName" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="Phone" Type="String" />
                <asp:Parameter Name="BabyName" Type="String" />
                <asp:Parameter Name="BabyAge" Type="String" />
                <asp:Parameter Name="DiaperSize" Type="String" />
                <asp:Parameter Name="Notes" Type="String" />
                <asp:Parameter Name="OrderID" Type="Int32" />
            </UpdateParameters>
...

[Daniel]

Hello Damian,

I modified the demo website in order to work with SqlDataSource. Please take a look at the attachment. Basically, the error is generated because you need to replace the question marks with parameter names.

Regards,
Daniel
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center