I have a SQL join for two tables. I want to display the data in a datagrid and update both tables witht the changes. I first tried to do an update using a SQL JOIN DataSet, but that gave me an error, I then tried to create 2 different DataTables and adding a DataRelation.
Table1
-ID "PK"
-UserName
-UserSurname
-UserEmailAdress
-Some more fields--
relation TABLE1.ID --> TABLE2.UserID
Table2
ID "PK"
UserID
-Some more fields--
I am new to SQL Joins VS 2005 beta 2.
SQL Joins
Hot Topic
- give or take
- Mathcad DLL
- Adding permanent filename data to a combo box during program execution
- emulator for barcode Scanner
- VB vs C#. How capable is VB compared to C#?
- DataGridView Add new record
- Send email in VB6?
- Subnet Mask
- Does calling a function from a dll created from VB class library spawn a new thread when run or it uses the thread that call it?
- Can't start appliction with sub main
Visual Basic
- Performance:: Array(), ListBox and Class
- suggestion for the location of user vailidation code
- Looking for multimedia function in VB.net
- VisualBasic IDE Corrupts Form !
- Refactor and Module?
- How to stimulate a mouse left click when the x, y co-ordinates are provided
- GUID
- vb and access
- Navigate Backwards and Forwards button missing
- Iterate through querytables
SQL Joins
Gergely Meszaros
Hello
There is a good exaample on MSDN on updating related tables in a Dataset. Example shows a dataset which has Customers and Orders table of Northwind DB .
Customers.CustomerID = Orders.CustomerID
http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbtskPerformingUpdates.asp
Thanks
Sunder
VB.net