大家都等著急了吧，直接上方法
1、確定asp.net的文檔頭部語句：<%@ Page Language="C#" %>
2、引用資料庫語句：
<%@ import Namespace="System.Data" %><%@ import Namespace="System.Data.OleDb" %>
3、建立一個資料庫：data.mdb
4、js代碼script語句的編寫：
<script runat="server"> // Insert page code here // void Page_Load(){ string db=@"database/data.mdb"; string connStr="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(db)+";"; string SQLcmd="create table IEB_webs(ID identity primary key,title varchar(255) Default Null)"; OleDbConnection conn=new OleDbConnection(connStr); conn.Open(); OleDbCommand OleCmd=new OleDbCommand(SQLcmd,conn); OleCmd.ExecuteNonQuery(); //執行SQL命令 Response.Write("資料表建立完成！"); } conn.Close(); conn=null; OleCmd=null; }</script>
5、把JS語句寫入HTML文本中
<html><head></head><body> <form method="post" runat="server"> <!-- 此地調用資料庫內容 --> </form></body></html>
6、最後完整的代碼結構如：
<%@ Page Language="C#" %><%@ import Namespace="System.Data" %><%@ import Namespace="System.Data.OleDb" %><script runat="server"> // Insert page code here // void Page_Load(){ string db=@"database/data.mdb"; string connStr="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(db)+";"; string SQLcmd="create table IEB_webs(ID identity primary key,title varchar(255) Default Null)"; OleDbConnection conn=new OleDbConnection(connStr); conn.Open(); OleDbCommand OleCmd=new OleDbCommand(SQLcmd,conn); OleCmd.ExecuteNonQuery(); //執行SQL命令 Response.Write("資料表建立完成！"); } conn.Close(); conn=null; OleCmd=null; }</script><html><head></head><body> <form method="post" runat="server"> <!-- 此地調用資料庫內容 --> </form></body></html>
以上就是asp.net串連access既快速又簡單的辦法，希望大家能夠按照我分享的步驟實現asp.net與access的串連。
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
