ADO.NET How To: Display to Display the Records of a Table in a Data Grid View



To display the records of a table in a data grid view, after getting a connection to the database, create a data adapter and a data set. Use a command to select the records of the table. Assign that command to the data adapter. Fill the data set with the records from the data adapter. Assign the table from the data set to the data source of the data grid view. Here is an example:

// References needed: System.dll,
//                    System.Data,
//                    System.Drawing,
//                    System.Windows.Forms
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

public class DatabaseExercise : Form
    Button btnShow;
    DataGridView dgvProperties;

    public DatabaseExercise()

    private void InitializeComponent()
        btnShow = new Button();
        btnShow.Text = "Show";
        btnShow.Location = new System.Drawing.Point(12, 12);
        btnShow.Click += new EventHandler(btnShowClicked);
        dgvProperties = new DataGridView();
        dgvProperties.Location = new System.Drawing.Point(12, 44);
        dgvProperties.Anchor = AnchorStyles.Left | AnchorStyles.Top |
                               AnchorStyles.Right | AnchorStyles.Bottom;

        Text = "Database Exercise";
        StartPosition = FormStartPosition.CenterScreen;
        Size = new System.Drawing.Size(275, 235);


    private void btnShowClicked(object sender, EventArgs e)
        using (SqlConnection scnDepartmentStore =
                new SqlConnection("Data Source=(local);" +
                                  "Database='AltairRealtors1';" +
                                  "Integrated Security=yes;"))
            SqlCommand cmdProperties =
                        new SqlCommand("SELECT * FROM dbo.Properties; ",
            SqlDataAdapter sdaProperties = new SqlDataAdapter();
            DataSet dsProperties = new DataSet("StoreItems");


            sdaProperties.SelectCommand = cmdProperties;

            dgvProperties.DataSource = dsProperties.Tables[0];

public class Exercise
    public static int Main()
        Application.Run(new DatabaseExercise());
        return 0;


Home Copyright © 2010-2016, FunctionX