sql -> dataview and back again

How do I update a sql database with changes and additions added in the dataview

Answer this question

sql -> dataview and back again

  • Giovanni Gavazzi

    The dataview is bound to a data connection/adapter. That one has properties for SELECT, UPDATE etc. statements. If you use the designer there are property editors for those properties (press the "..." button that shows next to such properties when you click on their value). Not the best prop editors, but usually do the job.

  • ryuu_iku

    Brian,

    still you haven't mention about the datasource you are using with your Gridview.If you are using the SqlDatasource or ObjectDataSource you can specify the update method in the Property window.If you are binding dynamically then there are events associated with Gridview Gridview_updating and Gridview_updated for updating to database.

    hope this link will help you to get details from Gridview on updating.

    http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_21821284.html

    regards,

    Raj Thilak


  • chuck02323

     

    my bad - wasn't too awake when I posted the question.

    I'm using a dataGridView that I loaded the databases data into - how do I update the database with changes made


  • sql -> dataview and back again