collecting data in sigle datatable by selecting two sets of rows from same table

Question

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

Sukesh Marla · Answer

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.

Vulpes · Answer

Why don't you just use a combined query: select * from TABLE1 where chapter_name='chapter1' or chapter_name='chapter2';

Sukesh Marla · Answer

My Pleasure varsha waghmode

varsha waghmode · Answer

hey sukesh!! Great answer.. my requirement is bit different but this is also useful....thank you

Vulpes · Answer

Yes you should be able to use the Merge() method but if you want to keep the existing DataTables independent then you'll need to clone them first: DataTable dt3 = dt1.Clone(); dt3.Merge(dt2.Clone());

varsha waghmode · Answer

hey vulpes thanks for your reply but it is not that simple as u think. I need to write queries separately as collect the result into single datatable