给我示例如何使用代码将访问数据库连接到asp.net(c#) [英] give me example how to connect to access database to asp.net(c#) with code
本文介绍了给我示例如何使用代码将访问数据库连接到asp.net(c#)的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
给我示例如何使用清除代码将访问数据库连接到asp.net(c#)
give me example how to connect to access database to asp.net(c#) with clear code
推荐答案
尝试使用此代码gridview连接ms访问数据库
Try this code gridview connect ms access database
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MSACCESSGV.aspx.cs" Inherits="MSACCESSGV" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Test MS ACCESS DATABASE CONNECTION</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvArticle" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Id" />
<asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Title" />
<asp:BoundField DataField="Published" HeaderText="Published" SortExpression="Visit" />
<asp:BoundField DataField="Modified" HeaderText="Modified" SortExpression="Modified" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
现在，您需要在服务器端编写代码以绑定GridView gvArticle.首先为您的MS Access数据库建立连接字符串.然后从MS Access数据库读取数据.完整的服务器端代码如下:
Now you need to write code in server side to bind GridView gvArticle. First make connection string for your MS Access Database. And then read data from MS Access database. Complete server side code is given below:
using System;
using System.Data;
using System.Web.UI;
using System.Data.OleDb;
public partial class MSACCESSGV : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sFilePath = Server.MapPath("MSACCESS.mdb");
DataTable dt;
OleDbConnection Conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sFilePath + ";");
using (Conn)
{
Conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM ARTICLE", Conn);
OleDbDataAdapter oDA = new OleDbDataAdapter(cmd);
dt = new DataTable();
oDA.Fill(dt);
}
gvArticle.DataSource = dt;
gvArticle.DataBind();
}
}
}
有许多示例，如果您 ^ ].
例如以下示例: http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/ [
There are lots of examples if you google[^].
For example this one: http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/[^]
去看看Google:
Go look at Google: http://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=connect+to+access+database+to+asp.net(c%23)[^]
It gives loads of examples.
In future, please do at least basic research yourself, and stop wasting your time and ours.
这篇关于给我示例如何使用代码将访问数据库连接到asp.net(c#)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
