How to merge two DataTables?

Question

0.00/5 (No votes)

See more:

C#

SQL

Hey guys

I wonder how can I put two different SQL Select method in one datatable?

Posted 14-Jun-12 21:22pm

Arman_Mousavi

Add a Solution

3 solutions

Solution 2

This can only be done if the schema from both queries are the same, use union in your queries:

SQL

select * from table1 
union 
select * from table2

Posted 14-Jun-12 21:27pm

Mehdi Gholam

Solution 3

C#

private void MergeDataTabels(DataTable dtSource, DataTable dtDest)
        {
            if (dtSource.Columns.Count == dtDest.Columns.Count)
            {
                dtDest.Merge(dtSource);
            }
        }

Posted 14-Jun-12 22:13pm

tssutha03

Add a Solution

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

OriginalGriff · Accepted Answer · 2012-06-14T21:27:00

Solution 1

Have you looked at the JOIN clause?
http://www.w3schools.com/sql/sql_join.asp[^]

Posted 14-Jun-12 21:27pm

OriginalGriff

How to merge two DataTables?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to merge two DataTables?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us