Solved

VB.net SQL Update tables based on joined query

Posted on 2014-10-12
2
117 Views
Last Modified: 2014-10-17
Hi
I have a SQL query where I have joined the Customers, Orders, and [Order Details] tables below. This is shown in a DataGridView. I want the users to be able to choose a line and update the data to something else. How would I approach this?

SELECT c.[Company], c.[Last Name], c.[First Name], b.[Quantity], b.[Unit Price], a.[Ship Name], a.[Ship Address] FROM [Orders] a LEFT JOIN [Order Details] b ON (a.[Order ID] = b.[Order ID]),[Customers] c LEFT JOIN [Orders] d ON (c.[ID] = d.[Customer ID])
0
Comment
Question by:Murray Brown
[X]
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
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40376442
0
 

Author Closing Comment

by:Murray Brown
ID: 40387978
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

623 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