{"id":25792,"date":"2024-03-16T05:34:53","date_gmt":"2024-03-16T05:34:53","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/"},"modified":"2024-03-22T07:01:40","modified_gmt":"2024-03-22T07:01:40","slug":"merge-two-datatables-columns-in-c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/","title":{"rendered":"Merge two DataTables columns in C#."},"content":{"rendered":"<p>We can merge two DataTables&#8217; columns in C# using the Merge() method. Here is a simple example:<\/p>\n<pre class=\"post-pre\"><code>DataTable dt1 = <span class=\"hljs-keyword\">new<\/span> DataTable();\r\nDataTable dt2 = <span class=\"hljs-keyword\">new<\/span> DataTable();\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6dfb\u52a0\u5217\u5230dt1<\/span>\r\ndt1.Columns.Add(<span class=\"hljs-string\">\"ID\"<\/span>, <span class=\"hljs-keyword\">typeof<\/span>(<span class=\"hljs-built_in\">int<\/span>));\r\ndt1.Columns.Add(<span class=\"hljs-string\">\"Name\"<\/span>, <span class=\"hljs-keyword\">typeof<\/span>(<span class=\"hljs-built_in\">string<\/span>));\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6dfb\u52a0\u5217\u5230dt2<\/span>\r\ndt2.Columns.Add(<span class=\"hljs-string\">\"ID\"<\/span>, <span class=\"hljs-keyword\">typeof<\/span>(<span class=\"hljs-built_in\">int<\/span>));\r\ndt2.Columns.Add(<span class=\"hljs-string\">\"Age\"<\/span>, <span class=\"hljs-keyword\">typeof<\/span>(<span class=\"hljs-built_in\">int<\/span>));\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6dfb\u52a0\u884c\u5230dt1<\/span>\r\ndt1.Rows.Add(<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-string\">\"John\"<\/span>);\r\ndt1.Rows.Add(<span class=\"hljs-number\">2<\/span>, <span class=\"hljs-string\">\"Mary\"<\/span>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6dfb\u52a0\u884c\u5230dt2<\/span>\r\ndt2.Rows.Add(<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">25<\/span>);\r\ndt2.Rows.Add(<span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">30<\/span>);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u5408\u5e76\u4e24\u4e2aDataTable\u7684\u5217<\/span>\r\ndt1.Merge(dt2);\r\n\r\n<span class=\"hljs-comment\">\/\/ \u6253\u5370\u5408\u5e76\u540e\u7684DataTable<\/span>\r\n<span class=\"hljs-keyword\">foreach<\/span> (DataRow row <span class=\"hljs-keyword\">in<\/span> dt1.Rows)\r\n{\r\n    <span class=\"hljs-keyword\">foreach<\/span> (DataColumn col <span class=\"hljs-keyword\">in<\/span> dt1.Columns)\r\n    {\r\n        Console.Write(row[col] + <span class=\"hljs-string\">\"\\t\"<\/span>);\r\n    }\r\n    Console.WriteLine();\r\n}\r\n<\/code><\/pre>\n<p>The output is:<\/p>\n<pre class=\"post-pre\"><code>1   John    25\r\n2   Mary    30\r\n<\/code><\/pre>\n<p>In the above example, we first create two DataTables, dt1 and dt2, and add different columns and rows to them respectively. Then we merge the columns of dt2 into dt1 by calling the Merge() method of dt1. Finally, we loop through the rows and columns of dt1 to print out the merged DataTable.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We can merge two DataTables&#8217; columns in C# using the Merge() method. Here is a simple example: DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); \/\/ \u6dfb\u52a0\u5217\u5230dt1 dt1.Columns.Add(&#8220;ID&#8221;, typeof(int)); dt1.Columns.Add(&#8220;Name&#8221;, typeof(string)); \/\/ \u6dfb\u52a0\u5217\u5230dt2 dt2.Columns.Add(&#8220;ID&#8221;, typeof(int)); dt2.Columns.Add(&#8220;Age&#8221;, typeof(int)); \/\/ \u6dfb\u52a0\u884c\u5230dt1 dt1.Rows.Add(1, &#8220;John&#8221;); dt1.Rows.Add(2, &#8220;Mary&#8221;); \/\/ \u6dfb\u52a0\u884c\u5230dt2 dt2.Rows.Add(1, 25); dt2.Rows.Add(2, 30); \/\/ \u5408\u5e76\u4e24\u4e2aDataTable\u7684\u5217 dt1.Merge(dt2); \/\/ [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-25792","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Merge two DataTables columns in C#. - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Merge two DataTables columns in C#.\" \/>\n<meta property=\"og:description\" content=\"We can merge two DataTables&#8217; columns in C# using the Merge() method. Here is a simple example: DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); \/\/ \u6dfb\u52a0\u5217\u5230dt1 dt1.Columns.Add(&quot;ID&quot;, typeof(int)); dt1.Columns.Add(&quot;Name&quot;, typeof(string)); \/\/ \u6dfb\u52a0\u5217\u5230dt2 dt2.Columns.Add(&quot;ID&quot;, typeof(int)); dt2.Columns.Add(&quot;Age&quot;, typeof(int)); \/\/ \u6dfb\u52a0\u884c\u5230dt1 dt1.Rows.Add(1, &quot;John&quot;); dt1.Rows.Add(2, &quot;Mary&quot;); \/\/ \u6dfb\u52a0\u884c\u5230dt2 dt2.Rows.Add(1, 25); dt2.Rows.Add(2, 30); \/\/ \u5408\u5e76\u4e24\u4e2aDataTable\u7684\u5217 dt1.Merge(dt2); \/\/ [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T05:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T07:01:40+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Merge two DataTables columns in C#.\",\"datePublished\":\"2024-03-16T05:34:53+00:00\",\"dateModified\":\"2024-03-22T07:01:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\"},\"wordCount\":79,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\",\"name\":\"Merge two DataTables columns in C#. - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T05:34:53+00:00\",\"dateModified\":\"2024-03-22T07:01:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Merge two DataTables columns in C#.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Merge two DataTables columns in C#. - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/","og_locale":"en_US","og_type":"article","og_title":"Merge two DataTables columns in C#.","og_description":"We can merge two DataTables&#8217; columns in C# using the Merge() method. Here is a simple example: DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); \/\/ \u6dfb\u52a0\u5217\u5230dt1 dt1.Columns.Add(\"ID\", typeof(int)); dt1.Columns.Add(\"Name\", typeof(string)); \/\/ \u6dfb\u52a0\u5217\u5230dt2 dt2.Columns.Add(\"ID\", typeof(int)); dt2.Columns.Add(\"Age\", typeof(int)); \/\/ \u6dfb\u52a0\u884c\u5230dt1 dt1.Rows.Add(1, \"John\"); dt1.Rows.Add(2, \"Mary\"); \/\/ \u6dfb\u52a0\u884c\u5230dt2 dt2.Rows.Add(1, 25); dt2.Rows.Add(2, 30); \/\/ \u5408\u5e76\u4e24\u4e2aDataTable\u7684\u5217 dt1.Merge(dt2); \/\/ [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T05:34:53+00:00","article_modified_time":"2024-03-22T07:01:40+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Merge two DataTables columns in C#.","datePublished":"2024-03-16T05:34:53+00:00","dateModified":"2024-03-22T07:01:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/"},"wordCount":79,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/","url":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/","name":"Merge two DataTables columns in C#. - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T05:34:53+00:00","dateModified":"2024-03-22T07:01:40+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/merge-two-datatables-columns-in-c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Merge two DataTables columns in C#."}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=25792"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25792\/revisions"}],"predecessor-version":[{"id":59922,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25792\/revisions\/59922"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=25792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=25792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=25792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}