长方形用英文怎么说:asp.net连接access的代码

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/29 09:35:01
提供一个asp.net连接access数据库的代码.我这怎么也不成功.先谢谢了

Set MyConn = Server.CreateObject("ADODB.Connection")
Dim StrConn
StrConn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("test") & "\student.mdb;"
MyConn.Open StrConn
Response.Write Server.MapPath("test") & "student.mdb;" & "<br>"
Response.Write "数据库连接成功: " & myConn.State & "<br>"

设有数据库c:\test\student.mdb,其中有数据库表score

2003中vb.net
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim str = Application.StartupPath & "\data\db.dat"
'OleDbConnection1
'

Me.OleDbConnection1.ConnectionString = conn(file_path)
'OleDbConnection2
'

Me.OleDbConnection2.ConnectionString = conn(file_path)
If file_path <> "" Then

Me.Text = "办砸的文章管理" & file_path
Call read_root_label()
End If
End Sub
Function conn(ByVal str As String)
conn = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=1;Jet OLEDB:Database Password=;Data Source=" & str & ";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1" & _
";Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=Fal" & _
"se;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Je" & _
"t OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=Fals" & _
"e;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt" & _
" Database=False"
End Function

2003中 c#
public string conn_str()
{
string mdb_str=@"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""E:\web\dotnet的数据分页显示代码\c#\web\data\db.mdb"";Mode=Share Deny None;Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
return mdb_str;
}