[Last Call] Learn how to a build a cloud-first strategyRegister Now


How do I update One table in a DataGridView that was populated using Two Tables?

Posted on 2008-11-11
Medium Priority
Last Modified: 2012-05-05
I have populated a DataGridView using a SQL JOIN SELECT statement pulling data from two tables in the same DataSet. After the end user makes changes in the DataGridView, I need to UPDATE only One of the tables.

What is the most efficient way of handling this?
Question by:TheMidnightToker
1 Comment

Accepted Solution

Mitzs earned 1500 total points
ID: 22932291
If your gridview contains an Id column for the record that you want to update in one particular table then you can write a simple update statement to upddate the record.
Update table
set fields = value1
where Id_field = (IdField from datagridview)

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

834 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