OLeDB
to access OLeDB
libraries.
using System.Data.OleDb;
OleDbConnection con = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + Application.StartupPath + "/studentdb.accdb"); OleDbCommand cmd; OleDbDataAdapter da; DataTable dt; string sql;
private void fill_combo(string sql) { try { con.Open(); cmd.Connection = con; cmd.CommandText = sql; da.SelectCommand = cmd; da.Fill(dt); cbo.HeaderText="Name"; cbo.DataSource = dt; cbo.ValueMember = "ID"; cbo.DisplayMember = "fname"; dataGridView1.Columns.Add(cbo); } catch(Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); da.Dispose(); } }
private void Form1_Load(object sender, EventArgs e) { sql = "Select * From tblstudent"; fill_combo(sql); }