ASP.NET连接Access数据库

最新推荐文章于 2015-04-13 20:59:28 发布

CGraphX

最新推荐文章于 2015-04-13 20:59:28 发布

阅读量825

点赞数

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

本文链接：https://blog.csdn.net/ziren235/article/details/1447906

版权

ASP.NET 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<title>test access connection</title>
</head>
<body>
<h4>first example:listing data from a access table</h4>
<asp:DataGrid id="dgUserList"
runat="server"
GridLines="None"
BackColor="LightBlue"
CellPadding="5"
CellSpacing="5"
BorderWidth="2"
BorderColor="Black"
ShowHeader="false"
ToolTip="Show all infor from the guestbook.mdb"/>
</body>
</html>
<script language="C#" runat="server">
private void Page_Load(Object sender, EventArgs e) {
   String strConnection="Provider=Microsoft.Jet.OleDb.4.0;data source=F://guestbook.mdb;";
   OleDbConnection objConnection=new OleDbConnection(strConnection);
   String strSQL="SELECT * FROM guestbook";
   OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);

   objConnection.Open();
   dgUserList.DataSource=objCommand.ExecuteReader();
   dgUserList.DataBind();
   objConnection.Close();
}
</script>