Publish date: 2006-08-09

DataGridView filling (C#, FW 2.0)

 /// <summary>
/// DataGridView fill Sample
/// </summary>
/// <param name="connection_str"></param>
public void Run(string connection_str)
{
    OleDbConnection con = new OleDbConnection(connection_str);  //create connection
    con.Open();
    OleDbTransaction trans = con.BeginTransaction();            //begin transaction
    //create command
    OleDbCommand cmd = new OleDbCommand("select * from employee", con, trans);

    //create DataGridView and its DataSource
    DataGridView gv = new DataGridView();
    DataTable tbl = new DataTable("source");
    //fill DataTable
    OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
    adapter.Fill(tbl);

    gv.DataSource = tbl;

    //Display DataGridView
    Form f = new Form();
    f.Controls.Add(gv);
    gv.Dock = DockStyle.Fill;
    f.ShowDialog();

    //finaliaze
    trans.Commit();
    con.Close();
}