C#中怎么连接ACCESS数据库？

Question

  在C#中建立一个DBHelp 类！ 
 class DBHelper
    {
        private static string connstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\My c#\BookShop System\BookShop System\Library.mdb";
        OleDbConnection connection = new OleDbConnection(connstring);
    }
  我在窗体上放一个按钮 ！怎么测试连接啊？

Answer 1

button1_click(sender,e)
{try
{
private static string connstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\My c#\BookShop System\BookShop System\Library.mdb"; 
        OleDbConnection connection = new OleDbConnection(connstring); 
connection.open();
MessageBox.show("成功");
connection.close();
}
catch (exception ex)
{
    MessageBox.show("连接失败"+ex.ToString())
}
}

Answer 2

connection.State
返回的是ConnectionState是一个enum
ConnectionState.Broken;
ConnectionState.Connecting;
ConnectionState.Closed;
ConnectionState.Executing;
ConnectionState.Fetching;
ConnectionState.Open;

Answer 3

string CnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + ("db3.mdb");

Answer 4

access版本不一样Oledb后面的版本号也会不同的