//using System.Data.OleDb;
OleDbConnection myConn;
DataView dbRec;
private void gridtst_Load(object sender, EventArgs e)
{ // my document path
string MDB = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\db.mdb";
try
{ //OleDbConnection
myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + MDB);
myConn.Open();
//DB Set
DataSet dSet = new DataSet("DataBase");
OleDbDataAdapter dAdapt = new OleDbDataAdapter("select * from TBL", myConn);
dAdapt.Fill(dSet);
DataTable dTab = dSet.Tables[0];
//Data Source
dbRec = new DataView(dTab);
//grid
GD.DataSource = dbRec;
GD.Columns[0].Width = 40;
GD.Columns[1].HeaderText = "BB";
//close
myConn.Close();
}
catch (Exception ex)
{ //Error Message
MessageBox.Show(ex.ToString());
}
}