{"id":10538,"date":"2024-03-14T12:18:52","date_gmt":"2024-03-14T12:18:52","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/"},"modified":"2025-08-04T00:52:16","modified_gmt":"2025-08-04T00:52:16","slug":"how-to-call-a-data-table-class-in-mfc","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/","title":{"rendered":"MFC Data Table Tutorial"},"content":{"rendered":"<p>To reference a class that calls a data table, you first need to create a database object within the MFC application and instantiate a record set object. Then you can access the data table in the database through the record set object.<\/p>\n<p>Here is a simple example code demonstrating how to call a class for a data table in an MFC application.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\">\/\/ \u58f0\u660e\u6570\u636e\u5e93\u548c\u8bb0\u5f55\u96c6\u5bf9\u8c61<\/span>\r\nCDatabase db;\r\n<span class=\"hljs-function\">CRecordset <span class=\"hljs-title\">rs<\/span><span class=\"hljs-params\">(&amp;db)<\/span><\/span>;\r\n\r\n<span class=\"hljs-comment\">\/\/ \u8fde\u63a5\u6570\u636e\u5e93<\/span>\r\n<span class=\"hljs-keyword\">if<\/span> (db.<span class=\"hljs-built_in\">OpenEx<\/span>(_T(<span class=\"hljs-string\">\"DSN=YourDSN;UID=YourUsername;PWD=YourPassword\"<\/span>))){\r\n    <span class=\"hljs-comment\">\/\/ \u6267\u884c\u6570\u636e\u5e93\u67e5\u8be2<\/span>\r\n    <span class=\"hljs-keyword\">if<\/span> (rs.<span class=\"hljs-built_in\">Open<\/span>(CRecordset::forwardOnly, _T(<span class=\"hljs-string\">\"SELECT * FROM YourTable\"<\/span>))){\r\n        <span class=\"hljs-comment\">\/\/ \u904d\u5386\u8bb0\u5f55\u96c6<\/span>\r\n        <span class=\"hljs-keyword\">while<\/span> (!rs.<span class=\"hljs-built_in\">IsEOF<\/span>()){\r\n            <span class=\"hljs-comment\">\/\/ \u8bfb\u53d6\u6570\u636e\u8868\u5b57\u6bb5\u503c<\/span>\r\n            CString field1, field2;\r\n            rs.<span class=\"hljs-built_in\">GetFieldValue<\/span>(_T(<span class=\"hljs-string\">\"Field1\"<\/span>), field1);\r\n            rs.<span class=\"hljs-built_in\">GetFieldValue<\/span>(_T(<span class=\"hljs-string\">\"Field2\"<\/span>), field2);\r\n\r\n            <span class=\"hljs-comment\">\/\/ \u4f7f\u7528\u6570\u636e\u8868\u5b57\u6bb5\u503c\u8fdb\u884c\u5176\u4ed6\u64cd\u4f5c<\/span>\r\n            <span class=\"hljs-comment\">\/\/ ...<\/span>\r\n\r\n            <span class=\"hljs-comment\">\/\/ \u79fb\u52a8\u5230\u4e0b\u4e00\u6761\u8bb0\u5f55<\/span>\r\n            rs.<span class=\"hljs-built_in\">MoveNext<\/span>();\r\n        }\r\n\r\n        <span class=\"hljs-comment\">\/\/ \u5173\u95ed\u8bb0\u5f55\u96c6<\/span>\r\n        rs.<span class=\"hljs-built_in\">Close<\/span>();\r\n    }\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5<\/span>\r\n    db.<span class=\"hljs-built_in\">Close<\/span>();\r\n}\r\n<\/code><\/pre>\n<p>In the example above, a database object CDatabase and a record set object CRecordset are first instantiated, then the database is connected and data is queried from the table. The GetFieldValue method is used to retrieve field values from the table, which can then be manipulated as needed. Finally, make sure to close the connection and record set after using the database and record set.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To reference a class that calls a data table, you first need to create a database object within the MFC application and instantiate a record set object. Then you can access the data table in the database through the record set object. Here is a simple example code demonstrating how to call a class for [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[13204,13205,13203,13206,13207],"class_list":["post-10538","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-cdatabase","tag-crecordset","tag-mfc-data-table","tag-mfc-database","tag-mfc-programming"],"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>MFC Data Table Tutorial - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to call a data table class in MFC applications. Step-by-step guide with CDatabase and CRecordset code examples.\" \/>\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-call-a-data-table-class-in-mfc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MFC Data Table Tutorial\" \/>\n<meta property=\"og:description\" content=\"Learn how to call a data table class in MFC applications. Step-by-step guide with CDatabase and CRecordset code examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/\" \/>\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-14T12:18:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T00:52:16+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\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=\"Noah Thompson\" \/>\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-call-a-data-table-class-in-mfc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"MFC Data Table Tutorial\",\"datePublished\":\"2024-03-14T12:18:52+00:00\",\"dateModified\":\"2025-08-04T00:52:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/\"},\"wordCount\":131,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"CDatabase\",\"CRecordset\",\"MFC data table\",\"MFC database\",\"MFC programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/\",\"name\":\"MFC Data Table Tutorial - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T12:18:52+00:00\",\"dateModified\":\"2025-08-04T00:52:16+00:00\",\"description\":\"Learn how to call a data table class in MFC applications. Step-by-step guide with CDatabase and CRecordset code examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MFC Data Table Tutorial\"}]},{\"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MFC Data Table Tutorial - Blog - Silicon Cloud","description":"Learn how to call a data table class in MFC applications. Step-by-step guide with CDatabase and CRecordset code examples.","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-call-a-data-table-class-in-mfc\/","og_locale":"en_US","og_type":"article","og_title":"MFC Data Table Tutorial","og_description":"Learn how to call a data table class in MFC applications. Step-by-step guide with CDatabase and CRecordset code examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T12:18:52+00:00","article_modified_time":"2025-08-04T00:52:16+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"MFC Data Table Tutorial","datePublished":"2024-03-14T12:18:52+00:00","dateModified":"2025-08-04T00:52:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/"},"wordCount":131,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["CDatabase","CRecordset","MFC data table","MFC database","MFC programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/","name":"MFC Data Table Tutorial - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T12:18:52+00:00","dateModified":"2025-08-04T00:52:16+00:00","description":"Learn how to call a data table class in MFC applications. Step-by-step guide with CDatabase and CRecordset code examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-a-data-table-class-in-mfc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MFC Data Table Tutorial"}]},{"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10538","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=10538"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10538\/revisions"}],"predecessor-version":[{"id":154304,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10538\/revisions\/154304"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=10538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=10538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=10538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}