{"id":7511,"date":"2024-03-14T05:38:12","date_gmt":"2024-03-14T05:38:12","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/"},"modified":"2025-08-02T17:11:39","modified_gmt":"2025-08-02T17:11:39","slug":"how-to-connect-a-database-with-a-datagridview-in-c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/","title":{"rendered":"C# DataGridView Database Connection Guide"},"content":{"rendered":"

To connect a database with a DataGridView in C#, you can follow these steps:<\/p>\n

    \n
  1. Add a DataGridView control to the form and name it dataGridView1.<\/li>\n
  2. Import the System.Data.SqlClient namespace.<\/li>\n
  3. Create a database connection object SqlConnection and set the connection string.<\/li>\n
  4. Create a data adapter object SqlDataAdapter.<\/li>\n
  5. Create a DataSet object.<\/li>\n
  6. Fill the dataset using SqlDataAdapter in the form’s Load event.<\/li>\n
  7. Bind the dataset to the DataGridView control.<\/li>\n<\/ol>\n

    Here is an example piece of code:<\/p>\n

    using<\/span> System;\r\nusing<\/span> System.Windows.Forms;\r\nusing<\/span> System.Data;\r\nusing<\/span> System.Data.SqlClient;\r\n\r\nnamespace<\/span> DataGridViewDatabase<\/span>\r\n{\r\n    public<\/span> partial<\/span> class<\/span> Form1<\/span> : Form<\/span>\r\n    {\r\n        \/\/ \u521b\u5efa\u6570\u636e\u5e93\u8fde\u63a5\u5bf9\u8c61<\/span>\r\n        SqlConnection conn = new<\/span> SqlConnection(\"Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True\"<\/span>);\r\n\r\n        public<\/span> Form1<\/span>()<\/span>\r\n        {\r\n            InitializeComponent();\r\n        }\r\n\r\n        private<\/span> void<\/span> Form1_Load<\/span>(object<\/span> sender, EventArgs e<\/span>)<\/span>\r\n        {\r\n            \/\/ \u521b\u5efa\u6570\u636e\u9002\u914d\u5668\u5bf9\u8c61<\/span>\r\n            SqlDataAdapter da = new<\/span> SqlDataAdapter(\"SELECT * FROM YourTable\"<\/span>, conn);\r\n\r\n            \/\/ \u521b\u5efa\u6570\u636e\u96c6\u5bf9\u8c61<\/span>\r\n            DataSet ds = new<\/span> DataSet();\r\n\r\n            \/\/ \u586b\u5145\u6570\u636e\u5230\u6570\u636e\u96c6<\/span>\r\n            da.Fill(ds);\r\n\r\n            \/\/ \u7ed1\u5b9a\u6570\u636e\u96c6\u5230DataGridView\u63a7\u4ef6<\/span>\r\n            dataGridView1.DataSource = ds.Tables[0<\/span>];\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n
    In the example above, you will need to replace “YourServer”, “YourDatabase”, and “YourTable” with the actual database server, database name, and table name. This will allow you to connect to the database and display data using DataGridView in C#.<\/p>\n","protected":false},"excerpt":{"rendered":"
    To connect a database with a DataGridView in C#, you can follow these steps: Add a DataGridView control to the form and name it dataGridView1. Import the System.Data.SqlClient namespace. Create a database connection object SqlConnection and set the connection string. Create a data adapter object SqlDataAdapter. Create a DataSet object. Fill the dataset using SqlDataAdapter […]<\/p>\n","protected":false},"author":6,"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":[9637,274,1788,4695,572],"class_list":["post-7511","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-ado-net","tag-c","tag-database-connection","tag-datagridview","tag-sql-server"],"yoast_head":"\nC# DataGridView Database Connection Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Step-by-step tutorial to connect SQL database with DataGridView in C#. Complete code example included.\" \/>\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-connect-a-database-with-a-datagridview-in-c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C# DataGridView Database Connection Guide\" \/>\n<meta property=\"og:description\" content=\"Step-by-step tutorial to connect SQL database with DataGridView in C#. Complete code example included.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-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-14T05:38:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T17:11:39+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\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=\"Benjamin Taylor\" \/>\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-connect-a-database-with-a-datagridview-in-c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"C# DataGridView Database Connection Guide\",\"datePublished\":\"2024-03-14T05:38:12+00:00\",\"dateModified\":\"2025-08-02T17:11:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/\"},\"wordCount\":121,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"ADO.NET\",\"c#\",\"Database Connection\",\"DataGridView\",\"sql server\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/\",\"name\":\"C# DataGridView Database Connection Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T05:38:12+00:00\",\"dateModified\":\"2025-08-02T17:11:39+00:00\",\"description\":\"Step-by-step tutorial to connect SQL database with DataGridView in C#. Complete code example included.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C# DataGridView Database Connection Guide\"}]},{\"@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\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C# DataGridView Database Connection Guide - Blog - Silicon Cloud","description":"Step-by-step tutorial to connect SQL database with DataGridView in C#. Complete code example included.","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-connect-a-database-with-a-datagridview-in-c\/","og_locale":"en_US","og_type":"article","og_title":"C# DataGridView Database Connection Guide","og_description":"Step-by-step tutorial to connect SQL database with DataGridView in C#. Complete code example included.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T05:38:12+00:00","article_modified_time":"2025-08-02T17:11:39+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"C# DataGridView Database Connection Guide","datePublished":"2024-03-14T05:38:12+00:00","dateModified":"2025-08-02T17:11:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/"},"wordCount":121,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["ADO.NET","c#","Database Connection","DataGridView","sql server"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/","name":"C# DataGridView Database Connection Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T05:38:12+00:00","dateModified":"2025-08-02T17:11:39+00:00","description":"Step-by-step tutorial to connect SQL database with DataGridView in C#. Complete code example included.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-connect-a-database-with-a-datagridview-in-c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"C# DataGridView Database Connection Guide"}]},{"@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\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7511","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7511"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7511\/revisions"}],"predecessor-version":[{"id":152294,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7511\/revisions\/152294"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}