Hi,
I have one dataset which is exported to an external file (excel)
My problem is that I want to append the data of two different views to
one dataset. (because they have to be displayed in an sheet among each
other)
Something like:
cmd = new OracleDataAdapter("Select * from view1");
cmd.Tablemappings.Add("Table", "Views");
cmd = new OracleDataAdapter("Select * from view2");
cmd.Tablemappings.Add("Table", "Views"); -- append to first table
cmd.Fill(ds, "Views");
Is there a way to do something like that?
Thank you very much in advance.
regards,
Sebastian
SePp - 07 Apr 2008 10:17 GMT
> Hi,
>
[quoted text clipped - 19 lines]
>
> Sebastian
Okay found a way in sql ....
select * from view1 union (all) select * from view2
cheers
sebastian
Cor Ligthert [MVP] - 07 Apr 2008 12:01 GMT
Sepp,
The DataSet.Merge(table) will merge every datatable inside a dataset.
(be aware that it is only the reference of course)
Cor
> Hi,
>
[quoted text clipped - 19 lines]
>
> Sebastian