| | |
Updating database with related tables and queries??
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Feb 2006
Posts: 15
Reputation:
Solved Threads: 0
Hi!
Since there is no problem (any longer) to update database via simple datatable binded to a datagridview I would like to go to a second level.
Binding related tables and queries in order they are able to update data in my database.
I don't find that as a problem in ACCESS database but when I transfer those tables and queries into VB express project…….
It's all so lovely shown in dataset designer with all the connections and everything.
I noticed there are missing update expressions in properties of some tableadapters. How do I overcome the problem?
Do I have to create my own update expressions for those tableadapterqueries or is there something else going wrong?
I'm also not so good with SQL…..
Thanks in advance for any help or suggestions.
--------------------------------------------------------------------------------
kdee
Since there is no problem (any longer) to update database via simple datatable binded to a datagridview I would like to go to a second level.
Binding related tables and queries in order they are able to update data in my database.
I don't find that as a problem in ACCESS database but when I transfer those tables and queries into VB express project…….
It's all so lovely shown in dataset designer with all the connections and everything.
I noticed there are missing update expressions in properties of some tableadapters. How do I overcome the problem?
Do I have to create my own update expressions for those tableadapterqueries or is there something else going wrong?
I'm also not so good with SQL…..
Thanks in advance for any help or suggestions.
--------------------------------------------------------------------------------
kdee
![]() |
Similar Threads
- database questions I have (Database Design)
- How to connect queries from SQL Server 2005 to VB.Net Windows application (MS SQL)
- Exclude duplicate records in a JOIN (MS SQL)
- Updating multiple tables in C# (C#)
- Error connecting to database (ASP.NET)
- Multiple Tables in a Database (Visual Basic 4 / 5 / 6)
- Manipulating A Database (C#)
- PHP newbie, project feasibility (PHP)
- updating 2 HTML tables on one PHP page (PHP)
Other Threads in the VB.NET Forum
- Previous Thread: How to extract all frames from .avi file
- Next Thread: Filling datarow with combos!
| Thread Tools | Search this Thread |
.net .net2005 30minutes 2005 2008 access account arithmetic array basic binary bing button buttons center check code combobox component connectionstring crystalreport data database databasesearch datagrid datagridview date design dissertation dissertations dissertationthesis dropdownlist excel fade file-dialog folder ftp generatetags google hardcopy image images input insert intel internet login mobile monitor ms net networking objects output passingparameters peertopeervideostreaming picturebox picturebox1 port print problem problemwithinstallation project reports" save savedialog searchbox searchvb.net select serial shutdown soap survey table tcp temperature text textbox timer toolbox trim update updown user usercontrol vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web winforms wpf





