数据库连接

c#：

            string strCon = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Application.StartupPath+ @"\**.mdb";
            OleDbConnection cn = new OleDbConnection(strCon);

            string strsql = "Select * From 表名";

            OleDbDataAdapter da = new OleDbDataAdapter(strsql, cn);
            DataSet ds = new DataSet();
            da.Fill(ds, "表名");

 

vb.NET

 

        Dim oleDbConnection1 As OleDb.OleDbConnection

        Dim strField As String
        Dim DataAdapter As New OleDb.OleDbDataAdapter
        Dim dataset As New DataSet

        Dim strConnect As String
        strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & StrPath & CStr("\**.MDB")
        oleDbConnection1 = New System.Data.OleDb.OleDbConnection(strConnect)

         strField = "SELECT * FROM 表名"

        DataAdapter = New OleDb.OleDbDataAdapter(strField, oleDbConnection1)
        DataAdapter.Fill(dataset, "表名")