Solved

Dataview Update

Posted on 2004-10-14
7
422 Views
Last Modified: 2010-04-23
How do i update my tables when i am using a dataview?
0
Comment
Question by:daverichardson
  • 4
  • 3
7 Comments
 
LVL 4

Accepted Solution

by:
eozz_2000 earned 50 total points
ID: 12312745
Your dataView must be bounded to a table, then:

DataSet1.Update(dsSample,"The table that is bounded to your data view")
0
 

Author Comment

by:daverichardson
ID: 12312825
Should DataSet1.Update be dataadapter.Update if so my table isnt updated
0
 
LVL 4

Expert Comment

by:eozz_2000
ID: 12312979
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:daverichardson
ID: 12312999
Yes thats right
0
 
LVL 4

Expert Comment

by:eozz_2000
ID: 12313025
Is your dataView a result of joining tables?
0
 

Author Comment

by:daverichardson
ID: 12313060
no
0
 

Author Comment

by:daverichardson
ID: 12313125
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now