tingningpower的专栏

用户操作

[留言] [发消息] [加为好友]

订阅我的博客

[编辑]tingningpower的公告

[编辑]文章分类

存档

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>

点这里可以看到演视

发表于 @ 2002年12月02日　09:28:00 | 评论( loading... ) | 编辑| 举报| 收藏