---
title: "DataGridView Binding - SQL Server dataset in C#"  
description: "DataGridView Binding - SQL Server dataset in C#"  
author: "Takeshi Okada"  
published: 2013-06-15  
updated: 2013-06-15  
canonical: https://www.mindstick.com/forum/1161/datagridview-binding-sql-server-dataset-in-c-sharp  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# DataGridView Binding - SQL Server dataset in C#

hi [Developers](https://www.mindstick.com/articles/12875/blunders-you-must-avoid-while-hiring-java-developers-to-get-the-best-fulfilling-your-needs),\
How to bind the [DataGridView](https://www.mindstick.com/articles/607/working-with-datagridview-in-vc-sharp) with [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) [dataset](https://www.mindstick.com/articles/19/dataset) in C#.

## Replies

### Reply by Sumit Kesarwani

Hi Takeshi,\
You can use this code:\

```
using System;using System.Data;using System.Windows.Forms;using System.Data.SqlClient; namespace WindowsApplication1{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }         private void button1_Click(object sender, EventArgs e)        {            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";            string sql = "SELECT * FROM Authors";            SqlConnection connection = new SqlConnection(connectionString);            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);            DataSet ds = new DataSet();            connection.Open();            dataadapter.Fill(ds, "Authors_table");            connection.Close();            dataGridView1.DataSource = ds;            dataGridView1.DataMember = "Authors_table";        }    }}
```


---

Original Source: https://www.mindstick.com/forum/1161/datagridview-binding-sql-server-dataset-in-c-sharp

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.