How to define a UpdateCommand of a SqlDataSource, based on a database view for the GridView data control? RRS feed

  • Question

  • User-830563764 posted

    I have a VS2010/ASPnet 4.0 website with a webpage, created by a SqlDataSource based on a database view.  A GrdiView was created to display the database view and the Edit column was added.  An error popped up when I clicked the Edit button of a data row: Updating is not supported by data source SqlDataSource1 unless UpdateCommand is specified.

    I understand that a database view in general cannot be edited or inserted when it involves more than one database table.  I 'd like to have a GridView page for users to browse the database view, and edit/change the records while browsing.  Can UpdateCommand of the SqlDataSource1 be defined to edit the database view?  How?  Reconfigure the SqlDataSource1 for the GridView?

    Monday, September 19, 2016 3:02 PM