1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
private void data_Load(object sender, System.EventArgs e)
{
// create a connection string
string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=P:\\contacts.mdb";
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = connString;
// create a data adapter
OleDbDataAdapter da = new OleDbDataAdapter("Select * from Contacts", myConnection);
// create a new dataset
DataSet ds = new DataSet();
// fill dataset
da.Fill(ds, "Contacts");
// Attach DataSet to DataGrid
dataGrid1.DataSource = ds.DefaultViewManager; |
Partager