DataGrid 链接Access数据库

1@ Import Namespace="System"

1@ Import Namespace="System.Data"

1@ Import Namespace="System.Data.OleDb"

 1<script language="c#" runat="server">   
 2void Page_Load()   
 3{   
 4string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";   
 5strConnection += @"Data Source=\Northwind.mdb"; \\\mdb文件位置绝对路径   
 6string strSQL = "SELECT * FROM Employees ";   
 7DataSet objDataSet = new DataSet();   
 8OleDbConnection objConnection = new OleDbConnection(strConnection);   
 9OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);   
10objAdapter.Fill(objDataSet, "Employees");   
11DataView objDataView = new DataView(objDataSet.Tables["Employees"]);   
12dgNameList.DataSource=objDataView;   
13dgNameList.DataBind();   
14} 
15
16</script>

1<html>
2<body>
3<h4>```
4=Request.QueryString["id"]
5```</h4>
6<asp:datagrid allowcustompaging="false" autogeneratecolumns="false" backcolor="#ffffff" cellpadding="2" cellspacing="0" enableviewstate="false" font-name="?聬I" font-size="10pt" headerstyle-backcolor="#eeaadd" id="dgNameList" runat="server" showfooter="true" ／="">
7</asp:datagrid></body>
8</html>

点这里可以看到演视