DataGrid 链接Access数据库

最新推荐文章于 2023-12-28 18:12:30 发布

tingningpower

最新推荐文章于 2023-12-28 18:12:30 发布

阅读量1.2k

点赞数 1

分类专栏： ASP.NET 文章标签： datagrid access dataset import string server

本文链接：https://blog.csdn.net/tingningpower/article/details/14065

版权

ASP.NET 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<%@ 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>

点这里可以看到演视

tingningpower

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
DataGrid 链接Access数据库

void Page_Load() { string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;"; strConnection += @"Data Source=/Northwind.mdb"; //mdb文件位置绝对路径 string strSQL = "SELECT * FROM Employees ";
复制链接

扫一扫