如何用字符串建立ACCESS数据库连接？？？

Question

http://www.csdn.net/Develop/read_article.asp?id=16437
http://xml.sz.luohuedu.net/xml/ShowList.asp?id=1

Answer 1

"Microsoft.Jet.OLEDB.4.0;Data Source=c:\\somepath\\mydb.mdb;"

Answer 2

给20分我万能:Module Functions    Public objConn As System.Data.OleDb.OleDbConnection
    Const PublicConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\dc\data\Suppinfo.mdb"
    ';Persist Security Info=False#Region "Database Reader"    Function OpenDB(ByVal connString As String, ByVal strsql As String) As System.Data.OleDb.OleDbCommand
        ' Dim objConn As System.Data.OleDb.OleDbConnection
        Dim objCmd As System.Data.OleDb.OleDbCommand        objConn = New System.Data.OleDb.OleDbConnection(connString)
        objCmd = New System.Data.OleDb.OleDbCommand(strsql, objConn)
        objCmd.Connection.Open()
        OpenDB = objCmd    End Function    Function OpenReader(ByVal SQL As String) As System.Data.OleDb.OleDbDataReader
        Dim objReader As System.Data.OleDb.OleDbDataReader
        Dim Rdb As New System.Data.OleDb.OleDbCommand()
        Rdb = OpenDB(PublicConnStr, SQL)
        OpenReader = Rdb.ExecuteReader()
    End Function#End Region#Region "Database Adepter"    Function OpenAdp(ByVal strsql As String, ByVal tbname As String) As DataSet
        '  Dim objConn As System.Data.OleDb.OleDbConnection
        Dim objCmd As System.Data.OleDb.OleDbDataAdapter
        Dim objds As New System.Data.DataSet()        objConn = New System.Data.OleDb.OleDbConnection(PublicConnStr)
        objCmd = New System.Data.OleDb.OleDbDataAdapter(strsql, objConn)
        ' objCmd.SelectCommand = New System.Data.OleDb.OleDbCommand(strsql, objConn)
        objCmd.Fill(objds, tbname)
        OpenAdp = objds
    End Function    Function savedata(ByVal strsql As String)
        '        Dim objconn As System.Data.OleDb.OleDbConnection
        Dim objCmd As System.Data.OleDb.OleDbCommand
        objConn = New System.Data.OleDb.OleDbConnection(PublicConnStr)
        objCmd = New System.Data.OleDb.OleDbCommand(strsql, objConn)
        ' objCmd.Connection.Open()
        objconn.Open()
        objCmd.ExecuteNonQuery()
        objconn.Close()
          End Function#End Region
End Module

Answer 3

using System.Data;
using System.Data.OleDb;
---------------------------
OleDbConnection thisConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\D\DevCs\Works2\Person.mdb;");
thisConnection.Open();
OleDbCommand thisCommand=thisConnection.CreateCommand(); //
thisCommand.CommandText="SELECT * FROM Intro";
OleDbDataReader thisReader=thisCommand.ExecuteReader();
while(thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",thisReader["ID"],thisReader["TheName"]);
}
thisReader.Close();
thisConnection.Close();