ASP.NET工具类-合并DataTable

最新推荐文章于 2024-09-06 08:26:50 发布

杰拉尔

最新推荐文章于 2024-09-06 08:26:50 发布

阅读量575

点赞数

分类专栏： .NET工用类

本文链接：https://blog.csdn.net/jhl52771/article/details/8187689

版权

.NET工用类专栏收录该内容

12 篇文章 0 订阅

订阅专栏

asp.net工具类

using System.Data;
using System;
public class DataTableMerge
{
    #region 多列连接
    /// <summary>
    /// 合并两个dataTable 类似 select * from  tableA a,tableB b where a.id=b.id
    /// </summary>
    /// <param name="First">第一个dataTable</param>
    /// <param name="Second">第二个dataTable</param>
    /// <param name="FJC">第一个的连接列</param>
    /// <param name="SJC">第二个的连接列</param>
    /// <returns></returns>
    public static DataTable Join(DataTable First, DataTable Second, DataColumn[] FJC, DataColumn[] SJC)
    {

        //创建一个新的DataTable

        DataTable table = new DataTable("Join");

        // Use a DataSet to leverage DataRelation

        using (DataSet ds = new DataSet())
        {

            //把DataTable Copy到DataSet中

            ds.Tables.AddRange(new DataTable[] { First.Copy(), Second.Copy() });

            DataColumn[] parentcolumns = new DataColumn[FJC.Length];

            for (int i = 0; i < parentcolumns.Length; i++)
            {

                parentcolumns = ds.Tables[0].Columns[FJC.ColumnName];

            }

            DataColumn[] childcolumns = new DataColumn[SJC.Length];

            for (int i = 0; i < childcolumns.Length; i++)
            {

                childcolumns = ds.Tables[1].Columns[SJC.ColumnName];

            }

            //创建关联

            DataRelation r = new DataRelation(string.Empty, parentcolumns, childcolumns, false);

            ds.Relations.Add(r);

            //为关联表创建列

            for (int i = 0; i < First.Columns.Count; i++)
            {

                table.Columns.Add(First.Columns.ColumnName, First.Columns.DataType);

            }

            for (int i = 0; i < Second.Columns.Count; i++)
            {

                //看看有没有重复的列，如果有在第二个DataTable的Column的列明后加_Second

                if (!table.Columns.Contains(Second.Columns.ColumnName))

                    table.Columns.Add(Second.Columns.ColumnName, Second.Columns.DataType);

                else

                    table.Columns.Add(Second.Columns.ColumnName + "_Second", Second.Columns.DataType);

            }

            table.BeginLoadData();

            foreach (DataRow firstrow in ds.Tables[0].Rows)
            {

                //得到行的数据

                DataRow[] childrows = firstrow.GetChildRows(r);

                if (childrows != null && childrows.Length > 0)
                {

                    object[] parentarray = firstrow.ItemArray;

                    foreach (DataRow secondrow in childrows)
                    {

                        object[] secondarray = secondrow.ItemArray;

                        object[] joinarray = new object[parentarray.Length + secondarray.Length];

                        Array.Copy(parentarray, 0, joinarray, 0, parentarray.Length);

                        Array.Copy(secondarray, 0, joinarray, parentarray.Length, secondarray.Length);

                        table.LoadDataRow(joinarray, true);

                    }

                }

            }

            table.EndLoadData();

        }

        return table;

    }
    #endregion

    #region 单列连接
    /// <summary>
    /// 合并两个dataTable 类似 select * from  tableA a,tableB b where a.id=b.id

///更多http://www.52mvc.com/showtopic-1264.aspx
    /// </summary>
    /// <param name="First">第一个dataTable</param>
    /// <param name="Second">第二个dataTable</param>
    /// <param name="FJC">第一个的连接列</param>
    /// <param name="SJC">第二个的连接列</param>
    /// <returns></returns>
    public static DataTable Join(DataTable First, DataTable Second, DataColumn FJC, DataColumn SJC)
    {
        return Join(First, Second, new DataColumn[] { FJC }, new DataColumn[] { SJC });
    }

    /// <summary>
    /// 合并两个dataTable 类似 select * from  tableA a,tableB b where a.id=b.id
    /// </summary>
    /// <param name="First">第一个dataTable</param>
    /// <param name="Second">第二个dataTable</param>
    /// <param name="FJC">第一个的连接列</param>
    /// <param name="SJC">第二个的连接列</param>
    /// <returns></returns>
    public static DataTable Join(DataTable First, DataTable Second, string FJC, string SJC)
    {

        return Join(First, Second, new DataColumn[] { First.Columns[FJC] }, new DataColumn[] { First.Columns[SJC] });

    }
    #endregion
}