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 ...