I'm using Visual Web Developer 2010 and SQL Server 2008 R2. I have a table that
does not have any uniqueidentifier columns. It's got a UserName column that I have set as a Primary Key and a few other varchar columns. I'm trying to create a web page with a FormView
control that will allow individual users to enter or edit their information after their record has been retrieved.
I'm dragging the FormView onto the form, selecting SQL Database and my data connection, and selecting Specify a Custom SQL starement or stored procedure. Then I enter my SQL statement using Query Builder and test it using Test Query. It retrieves
the record - no problem. I then hit Finish and it returns me to the Design View of my web page. But to my dismay, the list of enableable features for my FormView is limited to only
- Enable Dynamic Data support
- Enable Paging
The only option I actually need is Enable Editing but it's not there. In all the online video tutorials that I've seen on the subject, the Enable Editing option is always there and there's never any mention of it not being
there under certain circumstances. What might be the cause of the Enable Editing option missing from my FormView?
View Complete Post