Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Dataview Update

Posted on 2004-10-14
7
426 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VS.net 2010 11 48
Need a starter for ETL protocol? 4 65
Web Form VB.Net  import CSV 4 44
Help with error in Query 2 31
This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…

861 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