如何从Access中读出数据，并且写入到DataGrid控件当中？？？？？

Question

private void Form1_Load(object sender, System.EventArgs e)
{
OleDbConnection conn=new OleDbConnection("xxx");
OleDbDataAdapter da=new OleDbDataAdapter(conn,"select * from ");
DataSet ds=new DataSet();
da.Fill(ds);
this.DataGrid1.DataSource=ds.Tables[0].DefaultView;

}

Answer 1

//用当前路径上的access文件
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +  @"Data source= " +Server.MapPath(Request.ApplicationPath+"\\jinxc.mdb") ;
OleDbCommand cmd = conn.CreateCommand ();
cmd.CommandText = "select * from area";
OleDbDataAdapter mysqldataadapter;
mysqldataadapter = new OleDbDataAdapter ();
DataSet mydataset;
mydataset = new DataSet();
OleDbCommandBuilder mysqlcommandbuilder;
mysqlcommandbuilder = new OleDbCommandBuilder (mysqldataadapter);
mysqldataadapter.SelectCommand = cmd;
mysqldataadapter.Fill(mydataset,"area");
DataTable mydatatable;
mydatatable = mydataset.Tables["area"];
DataGrid1.DataSource = mydatatable;
DataGrid1.DataBind();
conn.Dispose ();
conn.Close ();