| | |
Updating database with related tables and queries??
Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
![]() |
•
•
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 .net2008 2005 2008 access account add application array basic beginner browser button buttons center check click code combo cpu crystalreport cuesent database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic dropdownlist excel exists fade file-dialog filter forms ftp generatetags html images input insert intel listview mobile module monitor mysql net number open output panel passingparameters picturebox picturebox2 port print printing printpreview problem regex reuse right-to-left searchvb.net select settings shutdown socket sqldatbase sqlserver storedprocedure survey tcp temperature textbox timespan transparency trim txttoxmlconverter user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet vista visual visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year





