Posted on: 11/28/2013 7:09:29 PM | Views : 898

I have a listview With a Insert, Update and delete all done in a codebehind C# page. It gives an error "Incorrect syntax update"
 
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1" OnItemCommand="ListView_OnItemCommand" DataKeyNames="SCID" <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TheOneConnectionString %>" InsertCommand="INSErt" UpdateCommand="update" DeleteCommand="DELETE FROM [StaffContacts] WHERE [SCID] = @SCID" SelectCommand="SELECT [SCID], [ContactDesc], [NumberEmail] FROM [StaffContacts] WHERE Userid = @uid" > ...

Go to the complete details ...