VB.NET能衔接ACCESS吗
来源:百度知道 编辑:UC知道 时间:2024/06/01 01:59:31
vb.net当然可以连接ACCESS数据库,一是可以手动,二可以编写程序。
看看些程序的
Dim constr As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\1\桌面\treeview.mdb;Persist Security Info=False"
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection(constr)
conn.Open()
Dim sqlstr As String = "SELECT * FROM 职员表"
Dim mydataadapter As New OleDb.OleDbDataAdapter
Dim mydataset As New DataSet
mydataadapter.SelectCommand = New OleDb.OleDbCommand(sqlstr, conn)
mydataadapter.Fill(mydataset, "table1")
DataGridView1.DataSource = mydataset.Tables("table1")
mydataset.Dispose()
mydataadapter.Dispose()
conn.Close()
conn.Dispose()
你的库文件在哪只要改下路径和库文件名字就OK了
可以
"Provider=Microsoft.Jet.OLEDB.4.0;User Id=你的用户名;jet OleDB:Database