ADO.NET How To:

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

Introduction

To display the records of a table in a data grid view, after getting a connection to the database, create a command that specifies the records to select. Create a data adapter and pass the command to it. Create a data set. 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()
    {
        InitializeComponent();
    }

    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);

        Controls.Add(btnShow);
        Controls.Add(dgvProperties);
    }

    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; ",
                                       scnDepartmentStore);
            SqlDataAdapter sdaProperties = new SqlDataAdapter(cmdProperties);
            DataSet dsProperties = new DataSet("StoreItems");

            scnDepartmentStore.Open();

            sdaProperties.Fill(dsProperties);

            dgvProperties.DataSource = dsProperties.Tables[0];
        }
    }
}

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


Home	Copyright © 2010-2016, FunctionX