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