<div>
This example is showing the resultset containing information from a single table<br />
<br />
SELECT * FROM Item JOIN Names ON Item.ItemID = Names.ItemID<br />
<br />
How would you dp this if the SQL looked something like this?<br />
<br />
SELECT Item.*, Name.* FROM Item JOIN Names ON Item.ItemID = Names.ItemID
</div>


This example is showing the resultset containing information from a single table

SELECT * FROM Item JOIN Names ON Item.ItemID = Names.ItemID

How would you dp this if the SQL looked something like this?

SELECT Item.*, Name.* FROM Item JOIN Names ON Item.ItemID = Names.ItemID

<div>
<div class="content wysiwyg-content">
I'm using Visual Studio .NET and an Access database. &nbsp;I have a dataset which is derived from multiple tables (Join). &nbsp;How do I update the dataset? &nbsp;I have a grid object that is unbounded to the dataset and I need a way to update the grid information. <br />
<br />
In short, how dow you perform an insert, an update and a delete on a dataset derived from multiple tables?
</div>
</div>


I'm using Visual Studio .NET and an Access database.  I have a dataset which is derived from multiple tables (Join).  How do I update the dataset?  I have a grid object that is unbounded to the dataset and I need a way to update the grid information. 

In short, how dow you perform an insert, an update and a delete on a dataset derived from multiple tables?

Update dataset with multiple tables

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.