hello...
I want to select two different set of rows(same no of columns)from single table and and i want to collect it in a single datatable .
e.g.
First query is
"select * from TABLE1 where chapter_name='chapter1'";
and second query is
"select * from TABLE1 where chapter_name 'chapter2'";
now i want to collect result of these two queries into a single datatable.
please suggest an answer
Loading
Sukesh MarlaPosted Sep 11, 2012, 6:09 AM
What you can do is
DAtaTable dt=getFirstDataTable();
.
..
.
.
.
.
DAtaTable dt2=getSecondDataTable();
dt.Merge(dt2)
Now use dt
Check this is correct answer if it helped.
Sukesh MarlaPosted Sep 11, 2012, 2:26 PM
varsha waghmodePosted Sep 11, 2012, 6:33 AM
VulpesPosted Sep 11, 2012, 6:25 AM
varsha waghmodePosted Sep 11, 2012, 5:03 AM
VulpesPosted Sep 11, 2012, 4:20 AM