将两个表合并到一个datatable

        /// <summary>
        /// 将表1表和表2合并起来
        /// </summary>
        /// <param name="dt1">表1</param>
        /// <param name="dt2">表2</param>
        /// <returns></returns>
        private DataTable UniteDataTable(DataTable dt1, DataTable dt2)
        {
            DataTable dt3 = dt1.Clone();
            for (int i = 0; i < dt2.Columns.Count; i++)
            {
                if (dt2.Columns[i].ColumnName != "ProductNum")
                {
                    dt3.Columns.Add(dt2.Columns[i].ColumnName);
                }
            }
            object[] obj = new object[dt3.Columns.Count];

            for (int i = 0; i < dt1.Rows.Count; i++)
            {
                dt1.Rows[i].ItemArray.CopyTo(obj, 0);
                dt3.Rows.Add(obj);
            }
            for (int i = 0; i < dt1.Rows.Count; i++)
            {
                DataRow[] dr = dt2.Select("ProductNum='" + dt1.Rows[i]["ProductType"].ToString() + "'");

                if (dr.Length > 0)
                {
                    for (int j = 0; j < dt2.Columns.Count - 1; j++)
                    {
                        dt3.Rows[i][j + dt1.Columns.Count] = dr[0][j + 1].ToString();
                    }
                }
            }
            return dt3;
        }