新建一个test.aspx文件内容如下：<%@ Page Language="C#"%><%@ Import namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><html><head><script language="C#" runat="server">private void Page_Load(Object Src, EventArgs E) { openUserDB();}// 打开用户数据库private void openUserDB(){ string connStr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+Server.MapPath("test.mdb"); string SQLStr = "SELECT * FROM [user]"; OleDbConnection myConnection = new OleDbConnection(connStr); OleDbDataAdapter myCommand = new OleDbDataAdapter(SQLStr,myConnection); //myConnection.Open();//( 多余的！) DataSet ds=new DataSet(); myCommand.Fill(ds,"dept"); myConnection.Close(); myConnection.Dispose(); myCommand.Dispose(); MyDataGrid.DataSource=ds.Tables["dept"].DefaultView; MyDataGrid.DataBind();}</script></head><body style="font: 10pt verdana"><form runat="server" >DataView 绑定到 DataGrid － 访问test.mdb数据<br>请将“test.mdb”(内含“USER”表)放到此文件（“test.aspx”）同一目录下 <ASP:DataGrid id="MyDataGrid" runat="server" BackColor="#F4FFF4" BorderColor="black" ShowFooter="true" Font-Size="8pt" HeaderStyle-BackColor="lightblue" > </ASP:DataGrid></form></body></html>
评论