How to create dataview from two datatables

  • Thread starter Thread starter H.Mahadevan
  • Start date Start date
H

H.Mahadevan

Hi
is there any way to create a dataview from two different
datatables.

My purpose is to display a datagrid. some columns from one
table and some other columns from other table.

i am using commandbuilder for automatic query. so i am not
able to join query from datasource.

Thanks in advance.

Regards

H. Mahadevan
 
By definition, a dataview is a kind of a filtered view of the underlying
DataTable. A commandbuilder basically can generate command objects for
insert, delete and update operations. How are u using a command builder for
query? Pls detail. Is it not feasible to create Views in the DB in your
case? Why not just change the select command of the DataAdapter used to pick
data from the view and then bind the filled dataset. If so, that would be
the most elegant solution. Else it would be painful to synthesize a new
DataTable out of two datatables.
 
Back
Top