DataGrid 链接Access数据库:小鱼之家,,编程技术,保险

DataGrid 链接Access数据库DataGrid 链接Access数据库:小鱼之家,,编程技术,保险

DataGrid 链接Access数据库

<%@ Import Namespace=System %>
<%@ Import Namespace=System.Data %>
<%@ Import Namespace=System.Data.OleDb %>
<script Language=c# runat=server >
void Page_Load()
{
    string strConnection = Provider=Microsoft.Jet.OleDb.4.0; ;
    strConnection += @ Data Source=Northwind.mdb ;    \mdb文件位置绝对路径
    string strSQL = SELECT * FROM Employees ;
    DataSet objDataSet = new DataSet();
    OleDbConnection objConnection = new OleDbConnection(strConnection);
    OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
    objAdapter.Fill(objDataSet, Employees );
    DataView objDataView = new DataView(objDataSet.Tables[ Employees ]);
    dgNameList.DataSource=objDataView;
    dgNameList.DataBind();
}

</script>
<html>
<body>
<h4><%=Request.QueryString[ id ]%></h4>

<asp:datagrid id=dgNameList runat=server
    BackColor=#ffffff
    CellPadding=2
    CellSpacing=0
    ShowFooter=true
    Font-Name=???I
    Font-Size=10pt
    HeaderStyle-BackColor=#eeaadd
    EnableViewState=false
    AutoGenerateColumns=false
    AllowCustomPaging=false
    ／>
</body>
</html>

点这里可以看到演视