如何合并两个数据表? [英] How to merge two DataTables?

问题描述

大家好

我不知道如何将两个不同的SQL Select方法放在一个数据表中?

Hey guys

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

推荐答案

您是否看过JOIN子句?
http://www.w3schools.com/sql/sql_join.asp [

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

只有在架构两个查询中的相同，请在查询中使用union:

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

select * from table1 
union 
select * from table2

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

这篇关于如何合并两个数据表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！