In this article I will explain with an example, how to connect
SQL Server database to
DataGridView in Windows Forms (WinForms) Application using C# and VB.Net.
Database
I have made use of the following table Customers with the schema as follows.
![How to Connect SQL Server Database to DataGridView in Windows]()
I have already inserted few records in the table.
![How to Connect SQL Server Database to DataGridView in Windows]()
Note: You can download the database table SQL by clicking the download link below.
Form Design
The Form consists of following control:
DataGridView – For displaying data.
![How to Connect SQL Server Database to DataGridView in Windows]()
Namespaces
You will need to import the following namespaces.
C#
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
VB.Net
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Connecting SQL Server Database to DataGridView
Inside the
Form Load event handler, the records are fetched from the
Customers Table of
SQL Server database.
Finally, DataTable is assigned to the DataSource property of DataGridView.
C#
private void Form1_Load(object sender, EventArgs e)
{
string sql = "SELECT CustomerId, Name, Country FROM Customers";
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter(sql, con))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dgvCustomers.DataSource = dt;
}
}
}
}
VB.Net
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim sql As String = "SELECT CustomerId, Name, Country FROM Customers"
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As New SqlConnection(constr)
Using sda As New SqlDataAdapter(sql, con)
Using dt As New DataTable()
sda.Fill(dt)
dgvCustomers.DataSource = dt
End Using
End Using
End Using
End Sub
Screenshot
![How to Connect SQL Server Database to DataGridView in Windows]()
Downloads
