Solved

Dataview Update

Posted on 2004-10-14
7
425 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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