Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

Dataview Update

How do i update my tables when i am using a dataview?
0
daverichardson
Asked:
daverichardson
  • 4
  • 3
1 Solution
 
eozz_2000Commented:
Your dataView must be bounded to a table, then:

DataSet1.Update(dsSample,"The table that is bounded to your data view")
0
 
daverichardsonAuthor Commented:
Should DataSet1.Update be dataadapter.Update if so my table isnt updated
0
 
eozz_2000Commented:
jajajaja.... sorry, you're right, is dataAdapter.update

If your dataView is the result of joining a couple or several tables it can't be updated, you must reference only one table if you want to update (I think).

Do you have a dataGrid bounded to your dataTable?... if it, let me understand... you have bounded your dataGrid to your dataView, your dataView is bounded to a table... when you update that table... the changes aren't stored in the dataBase?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
daverichardsonAuthor Commented:
Yes thats right
0
 
eozz_2000Commented:
Is your dataView a result of joining tables?
0
 
daverichardsonAuthor Commented:
no
0
 
daverichardsonAuthor Commented:
ok  i have sorted it, i recreated my form from scratch andit worked fine so there must have been something else wrong

thanks for all your help

Dave
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now