SQLDataSource Configuration not allowing Update, Delete or Insert

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ShahnazNoshin
    New Member
    • Feb 2015
    • 1

    SQLDataSource Configuration not allowing Update, Delete or Insert

    I created a new table in Visual Web Developer for SQL Server Express
    2005. I created a 'gridview' by dragging the table onto an empty web
    form in Visual Developer Express.

    Clicked on the smart tag 'configure data source'. When I click Advanced
    should see
    the Generate Insert, Update and Delete statements check box but it is
    greyed
    out. It isn't in all the video tutorials I have watched.

    Tried to repeat with various new tables, but it always gives the same
    result.

    Activated the edit button on GridView and it allowed me to edit the
    record, but it will not update as DataSource not configured for UPDATE.

    What can I be doing wrong ? I am guessing it is a property or a
    permission, but permissions not normally a problem in windows

    Help my Test Host expires on Microsoft tomorrow and I can not even get
    to edit an existing table at local level, never mind test how to upload
    and execute on a real host.

    Any help appreciated
Working...