急求vb.net2005连接sql和acc数据库代码！给分30!该怎么解决
急求vb.net2005连接sql和acc数据库代码！～～给分30!
有那位大哥能发一段vb.net连接sql和acc数据库的代码给我吗？
本人初学这个，望能注明重要步骤的说明～小弟在此谢谢了！～～
------解决方案--------------------
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DataManage.mdb;Persist Security Info=True;Jet OLEDB:Database Password=admin ")
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand( "SELECT 8 FROM <name> ; ", conn)
------解决方案--------------------
Dim cn As New OleDb.OleDbConnection
Dim constring As String = "Provider=Microsoft.Jet.OlEDB.4.0;Data Source=.\TSGL.mdb "
cn.ConnectionString = constring
这是连接access的
有那位大哥能发一段vb.net连接sql和acc数据库的代码给我吗？
本人初学这个，望能注明重要步骤的说明～小弟在此谢谢了！～～
------解决方案--------------------
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\DataManage.mdb;Persist Security Info=True;Jet OLEDB:Database Password=admin ")
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand( "SELECT 8 FROM <name> ; ", conn)
------解决方案--------------------
Dim cn As New OleDb.OleDbConnection
Dim constring As String = "Provider=Microsoft.Jet.OlEDB.4.0;Data Source=.\TSGL.mdb "
cn.ConnectionString = constring
这是连接access的