{"id":19379,"date":"2024-03-15T18:46:43","date_gmt":"2024-03-15T18:46:43","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/"},"modified":"2024-03-21T15:33:41","modified_gmt":"2024-03-21T15:33:41","slug":"how-to-retrieve-data-from-a-datagrid-in-wpf","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/","title":{"rendered":"How to retrieve data from a DataGrid in WPF?"},"content":{"rendered":"<p>To grab the data in a WPF DataGrid, you can use one of the following methods:<\/p>\n<ol>\n<li>Use the ItemsSource property of DataGrid to retrieve the entire dataset.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">var<\/span> data = myDataGrid.ItemsSource <span class=\"hljs-keyword\">as<\/span> IEnumerable&lt;MyModel&gt;;\r\n<\/code><\/pre>\n<ol>\n<li>Iterate through the rows and columns of the DataGrid, and fetch the data in each cell one by one.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">foreach<\/span> (<span class=\"hljs-keyword\">var<\/span> item <span class=\"hljs-keyword\">in<\/span> myDataGrid.Items)\r\n{\r\n    DataGridRow row = (DataGridRow)myDataGrid.ItemContainerGenerator.ContainerFromItem(item);\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u83b7\u53d6\u884c\u4e2d\u7684\u6240\u6709\u5217\u6570\u636e<\/span>\r\n    <span class=\"hljs-keyword\">var<\/span> cellValue1 = (row.Item <span class=\"hljs-keyword\">as<\/span> MyModel).Property1;\r\n    <span class=\"hljs-keyword\">var<\/span> cellValue2 = (row.Item <span class=\"hljs-keyword\">as<\/span> MyModel).Property2;\r\n    <span class=\"hljs-comment\">\/\/ ...<\/span>\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u6216\u8005\u901a\u8fc7\u5217\u7d22\u5f15\u83b7\u53d6\u7279\u5b9a\u5217\u7684\u6570\u636e<\/span>\r\n    <span class=\"hljs-keyword\">var<\/span> cellValue3 = (row.Item <span class=\"hljs-keyword\">as<\/span> MyModel)[<span class=\"hljs-number\">3<\/span>];\r\n}\r\n<\/code><\/pre>\n<p>Please note that the second method can only retrieve the currently visible rows. If you need to retrieve data from all rows, you may need to first scroll to the bottom and then iterate through rows beyond the visible ones.<\/p>\n<p>I hope this information is helpful to you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To grab the data in a WPF DataGrid, you can use one of the following methods: Use the ItemsSource property of DataGrid to retrieve the entire dataset. var data = myDataGrid.ItemsSource as IEnumerable&lt;MyModel&gt;; Iterate through the rows and columns of the DataGrid, and fetch the data in each cell one by one. foreach (var item [&hellip;]<\/p>\n","protected":false},"author":8,"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-19379","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>How to retrieve data from a DataGrid in WPF? - 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-retrieve-data-from-a-datagrid-in-wpf\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to retrieve data from a DataGrid in WPF?\" \/>\n<meta property=\"og:description\" content=\"To grab the data in a WPF DataGrid, you can use one of the following methods: Use the ItemsSource property of DataGrid to retrieve the entire dataset. var data = myDataGrid.ItemsSource as IEnumerable&lt;MyModel&gt;; Iterate through the rows and columns of the DataGrid, and fetch the data in each cell one by one. foreach (var item [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/\" \/>\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-15T18:46:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T15:33:41+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\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=\"William Carter\" \/>\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\/how-to-retrieve-data-from-a-datagrid-in-wpf\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How to retrieve data from a DataGrid in WPF?\",\"datePublished\":\"2024-03-15T18:46:43+00:00\",\"dateModified\":\"2024-03-21T15:33:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/\"},\"wordCount\":103,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/\",\"name\":\"How to retrieve data from a DataGrid in WPF? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T18:46:43+00:00\",\"dateModified\":\"2024-03-21T15:33:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to retrieve data from a DataGrid in WPF?\"}]},{\"@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\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to retrieve data from a DataGrid in WPF? - 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-retrieve-data-from-a-datagrid-in-wpf\/","og_locale":"en_US","og_type":"article","og_title":"How to retrieve data from a DataGrid in WPF?","og_description":"To grab the data in a WPF DataGrid, you can use one of the following methods: Use the ItemsSource property of DataGrid to retrieve the entire dataset. var data = myDataGrid.ItemsSource as IEnumerable&lt;MyModel&gt;; Iterate through the rows and columns of the DataGrid, and fetch the data in each cell one by one. foreach (var item [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T18:46:43+00:00","article_modified_time":"2024-03-21T15:33:41+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How to retrieve data from a DataGrid in WPF?","datePublished":"2024-03-15T18:46:43+00:00","dateModified":"2024-03-21T15:33:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/"},"wordCount":103,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/","name":"How to retrieve data from a DataGrid in WPF? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T18:46:43+00:00","dateModified":"2024-03-21T15:33:41+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-retrieve-data-from-a-datagrid-in-wpf\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to retrieve data from a DataGrid in WPF?"}]},{"@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\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19379","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=19379"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19379\/revisions"}],"predecessor-version":[{"id":53120,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19379\/revisions\/53120"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=19379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=19379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=19379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}