union and Dataviews??

  • Thread starter Thread starter vincent Blain
  • Start date Start date
V

vincent Blain

is it possible to create a union multiple tables within a dataview?? Taking
in consideration that both table will look the same but come from different
connections

select * from table1
union
select * from table2

if so can anyone show me how to do this???

Vince
 
vincent Blain said:
is it possible to create a union multiple tables within a dataview?? Taking
in consideration that both table will look the same but come from different
connections

select * from table1
union
select * from table2
Click to expand...
You can fill the same DataTable from two different connections.

David
 
vincent Blain said:
is it possible to create a union multiple tables within a dataview?? Taking
in consideration that both table will look the same but come from different
connections

select * from table1
union
select * from table2
Click to expand...
You can fill the same DataTable from two different connections.

David
 
Hi vincent,

Try DataSet.Merge method - it will merge both table records to one table.
You can't do it through DataView though as DataView acts on a single table
only.
 
Back
Top