Populating a DataGridView

Populating a DataGridView

In this short snippet, we will populate a DataGridView using the LoadData() method. This method uses the SqlDataAdapter to populate a DataSet. The table ‘Orders’ in the DataSet is then bound to the BindingSource component which gives us the flexibility to choose/modify the data location.

C#

public partial class Form1 : Form

    {

        private SqlDataAdapter da;

        private SqlConnection conn;

        BindingSource bsource = new BindingSource();

        DataSet ds = null;

        string sql;

        public Form1()

        {

            InitializeComponent();

        }

        private void btnLoad_Click(object sender, EventArgs e)

        {

            LoadData();

        }

        private void LoadData()

        {

string connectionString = "Data Source=localhost;Initial Catalog=Northwind;" + "Integrated Security=SSPI;";

            conn = new SqlConnection(connectionString);

sql = "SELECT OrderID, CustomerID, EmployeeID, OrderDate, Freight," + "ShipName, ShipCountry FROM Orders";

            da = new SqlDataAdapter(sql, conn);

            conn.Open();

            ds = new DataSet();

            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(da);          

            da.Fill(ds, "Orders");

            bsource.DataSource = ds.Tables["Orders"];

            dgv.DataSource = bsource;          

        }

    }