How to combine two query results in a dataTable not in a dataSet

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi All,

I have two queries like this

select *from sample1
select *from sample2

I would like to get the result in a single dataTable.
When I run this query I get the result in two grids. I want this to be in a single grid.

Posted 12-Feb-12 19:59pm

sacraj

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manognya kota · Answer 1 · 2012-02-12T20:05:00

Solution 1

Hi,

Cant this be done by joining the tables or like,

select * from sample1,sample2

Wouldnt this be the easy way instead of 2 queries and join data tables?

Posted 12-Feb-12 20:05pm

manognya kota

Updated 12-Feb-12 20:06pm

v2

Varun Sareen · Answer 2 · 2012-02-12T20:08:00

Dear Friend,

If the no of columns in both the tables from the database are same then go for

DataTable.Merge()

functionality to get the result into one datatable.

Please follow link for more clarity:- http://msdn.microsoft.com/en-us/library/system.data.datatable.merge.aspx[^]

I hope this will help you out.

Thanks

jai000 · Answer 3 · 2012-02-12T20:29:00

You can use UNION or UNION ALL command in SQL.

For detailed information check the following link

http://blog.sqlauthority.com/2009/03/11/sql-server-difference-between-union-vs-union-all-optimal-performance-comparison/[^]

I hope this will help you. If this solution works for you then accept this answer otherwise revert back to me

How to combine two query results in a dataTable not in a dataSet

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to combine two query results in a dataTable not in a dataSet

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us