Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
elke
459
insert, update, delete is not saved in DB (sqlsvr)
posted
Hello, I have a project containing a dataset “dsNetwerk”.I have programmed a SqlDataAdapter with a select command, wich works fine with the ultrawebgrid ‘uwgNetwerk’. Now, I try to programm insert, update and delete commands.It seems to work fine. When I debug, I see the changes in the dataset (fe. me.sqlDataset.tblNetwerkDocumentatie.Rows(3).Item(4)). But the changes are not saved in the database itself.I suppose you’ll need more information about my project, but I don’t know what specific information you’ll need. Thx in advance 

Elke

Parents
No Data
Reply
  • 1922
    posted

    Hi Elke,

    a dataset is disconnected from the database and will not automatically updated to the database. Instead you have to do it manually through a dataadapter.

    So for example you would have to write

    sqlDataAdapter1.Update(dsNetzwerk)

     

Children