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

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?
Who is Participating?
MitzsConnect With a Mentor Commented:
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)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.