{"id":24769,"date":"2024-03-16T03:49:03","date_gmt":"2024-03-16T03:49:03","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/"},"modified":"2024-03-22T04:32:54","modified_gmt":"2024-03-22T04:32:54","slug":"how-to-remove-duplicate-rows-in-a-c-datatable","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/","title":{"rendered":"How to remove duplicate rows in a C# datatable?"},"content":{"rendered":"

In C#, you can use the following method to remove duplicate rows in a DataTable:<\/p>\n

    \n
  1. Utilize the Distinct method:<\/li>\n<\/ol>\n
    DataTable distinctTable = dataTable.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDataTable();\r\n<\/code><\/pre>\n
      \n
    1. Query using LINQ:<\/li>\n<\/ol>\n
      DataTable distinctTable = dataTable\r\n    .AsEnumerable()\r\n    .GroupBy(row => new<\/span> { Col1 = row[\"Column1\"<\/span>], Col2 = row[\"Column2\"<\/span>], ... }) \/\/ \u6839\u636e\u591a\u4e2a\u5217\u8fdb\u884c\u5206\u7ec4<\/span>\r\n    .Select(group<\/span> => group<\/span>.First()) \/\/ \u9009\u62e9\u6bcf\u4e2a\u5206\u7ec4\u7684\u7b2c\u4e00\u884c<\/span>\r\n    .CopyToDataTable();\r\n<\/code><\/pre>\n
      Please note that the above method can only remove completely identical rows. If you want to remove duplicates based on specific columns, you can specify the columns to be grouped in the GroupBy method.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In C#, you can use the following method to remove duplicate rows in a DataTable: Utilize the Distinct method: DataTable distinctTable = dataTable.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDataTable(); Query using LINQ: DataTable distinctTable = dataTable .AsEnumerable() .GroupBy(row => new { Col1 = row[“Column1”], Col2 = row[“Column2”], … }) \/\/ \u6839\u636e\u591a\u4e2a\u5217\u8fdb\u884c\u5206\u7ec4 .Select(group => group.First()) \/\/ \u9009\u62e9\u6bcf\u4e2a\u5206\u7ec4\u7684\u7b2c\u4e00\u884c .CopyToDataTable(); Please note that the […]<\/p>\n","protected":false},"author":9,"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-24769","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow to remove duplicate rows in a C# datatable? - 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\/how-to-remove-duplicate-rows-in-a-c-datatable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to remove duplicate rows in a C# datatable?\" \/>\n<meta property=\"og:description\" content=\"In C#, you can use the following method to remove duplicate rows in a DataTable: Utilize the Distinct method: DataTable distinctTable = dataTable.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDataTable(); Query using LINQ: DataTable distinctTable = dataTable .AsEnumerable() .GroupBy(row => new { Col1 = row["Column1"], Col2 = row["Column2"], ... }) \/\/ \u6839\u636e\u591a\u4e2a\u5217\u8fdb\u884c\u5206\u7ec4 .Select(group => group.First()) \/\/ \u9009\u62e9\u6bcf\u4e2a\u5206\u7ec4\u7684\u7b2c\u4e00\u884c .CopyToDataTable(); Please note that the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/\" \/>\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-16T03:49:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T04:32:54+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\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=\"Ava Mitchell\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"How to remove duplicate rows in a C# datatable?\",\"datePublished\":\"2024-03-16T03:49:03+00:00\",\"dateModified\":\"2024-03-22T04:32:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/\"},\"wordCount\":65,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/\",\"name\":\"How to remove duplicate rows in a C# datatable? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T03:49:03+00:00\",\"dateModified\":\"2024-03-22T04:32:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to remove duplicate rows in a C# datatable?\"}]},{\"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to remove duplicate rows in a C# datatable? - 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\/how-to-remove-duplicate-rows-in-a-c-datatable\/","og_locale":"en_US","og_type":"article","og_title":"How to remove duplicate rows in a C# datatable?","og_description":"In C#, you can use the following method to remove duplicate rows in a DataTable: Utilize the Distinct method: DataTable distinctTable = dataTable.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDataTable(); Query using LINQ: DataTable distinctTable = dataTable .AsEnumerable() .GroupBy(row => new { Col1 = row[\"Column1\"], Col2 = row[\"Column2\"], ... }) \/\/ \u6839\u636e\u591a\u4e2a\u5217\u8fdb\u884c\u5206\u7ec4 .Select(group => group.First()) \/\/ \u9009\u62e9\u6bcf\u4e2a\u5206\u7ec4\u7684\u7b2c\u4e00\u884c .CopyToDataTable(); Please note that the […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T03:49:03+00:00","article_modified_time":"2024-03-22T04:32:54+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"How to remove duplicate rows in a C# datatable?","datePublished":"2024-03-16T03:49:03+00:00","dateModified":"2024-03-22T04:32:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/"},"wordCount":65,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/","name":"How to remove duplicate rows in a C# datatable? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T03:49:03+00:00","dateModified":"2024-03-22T04:32:54+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-remove-duplicate-rows-in-a-c-datatable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to remove duplicate rows in a C# datatable?"}]},{"@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\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24769","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=24769"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24769\/revisions"}],"predecessor-version":[{"id":58824,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24769\/revisions\/58824"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=24769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=24769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=24769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}