Member Avatar for slpefanis

Hi All

I am currently using a Dataset in my program to load data from a SQL database. when i open my form, i am using a

 Me.Tbl_CustomersTableAdapter.FillBy(Me.MydatabaseDataSet.tbl_Customers, ID)

to load the data, which i then bind into the textboxes on the form. I would like to know if there is an easy way to save this data back to the SQL table without having to greate an update command for each field?
i thought something like

Me.Tbl_CustomersTableAdapter.Update(Me.MydatabaseDataSet.tbl_Customers)

could work but am not sure how to approach and searching isn't helping much at this stage.

Would appreciate any help
Thanks
Stephen

Edited by Reverend Jim because: typo in thread title
  • 2 Contributors
  • 1 Reply
  • 135 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by XEN0
Member Avatar for XEN0

Refer here Click Here a nice snippet involving datasets.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.