1.创建一个C#窗体应用程序
2.添加一个按钮
3.加入以下代码
private void button1_Click(object sender, EventArgs e)
{
//Data Sourse 后接数据库位置
string strConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\Administrator\桌面\text.accdb;Persist Security Info=False";
accConnection = new OleDbConnection(strConnectionString);
try
{
accConnection.Open();
}
catch (OleDbException ee)
{
MessageBox.Show("Access Error");
MessageBox.Show("Error Code = " + ee.ErrorCode);
MessageBox.Show("Error Message = " + ee.Message);
}
catch (InvalidOperationException eee)
{
MessageBox.Show("InvalidOperation:" + eee.Message);
}
if (accConnection.State != ConnectionState.Open)
{
MessageBox.Show("Database connection is Failed!");
Application.Exit();
}
else
{
MessageBox.Show("连接成功!");
}
}