Is it possible to fill a DataSet.DataTable with values from more than one database table?

  • Thread starter Thread starter nvx
  • Start date Start date
N

nvx

Hello,
is there a way to fill a DataSet.DataTable with values from more than
one table from a single database file? The thing I'd like to achieve
is to get something similar to a result of the JOIN keyword in SQL.

Thanks for any help...

With regards
nvx
 
Not really. You can do some stuff with Expressions to add additional
columns pointing to a separate data table in the same data set with a
foreign key, but you can't do update queries on a dataset, which it sounds
like you're looking for.

You could, of course, also do a join when you originally fill your
datatable.

Robin S.
 
NVX,

Of course you can, but be aware that you cannot use the standard procedurs
from ADONET, you will have to write your own Fill, Update, and Insert
commands or in otherwords Select, Update, Insert, Delete.

Cor
 
Thank you very much for your replies... :) Hopefully I'll manage to
code it... ;)

With regards
nvx


Cor Ligthert [MVP] napsal:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to data-bind a ToolStripMenuItem to a column of a DataTable? 0
"Invalid cast from 'Int32' to 'DateTime'." 1
How To Fill Strong DataSet DateTime Column With yyyyMMDD Data Valu 1
How to Populate Data from a table to another 0
Second fill in Ado.recordset does not fill table 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Using OleDbDataAdapter Fill when INNER JOIN specified 2
Cascade fill for tables with FK relationships 1

Back
Top