using System.Data.OleDb; 
///, & lt; summary>///,访问数据库测试连接按钮///,& lt;/summary>///,& lt; param name=胺⒓恕弊４? lt;/param>///,& lt; param name=" e "祝辞& lt;/param>
private void button1_Click (object ,发送方,EventArgs e)
{
,,试一试
,,{
,,,,//创建连接数据库的字符串
,,,,string reportpath =, @“C: \用户桌面\ \ 15543 \ test.mdb”;//,,,数据库路径,如,,我的mdb文件为test.mdb ,位置为桌面,,
,,,,string ConStr =,提供者=Microsoft.Jet.OLEDB.4.0; Data “源”=,+,reportpath +,”; Uid=Admin; Pwd=jcvadmin;”;
,,,,//创建oledbconnection对象
,,,,OleDbConnection con =, new OleDbConnection(若干);
,,,,con.Open();//打开数据库
,,,,MessageBox.Show (“OK”);
,,,,con.Close();//关闭数据库
,,,,MessageBox.Show(“不”);
,,,,//以下注释为从一张表中选择数据,然后加载到视图中
,,,,//string str =,“select *,得到TestTable”;//加载表中所有数据
,,,,//OleDbCommand cmd =, new OleDbCommand (str,,);
,,,,//OleDbDataReader oldbRed =, cmd.ExecuteReader ();
,,,,//时(oldbRed.Read()),,//不调用读(),将会没有数据又是;
,,,,//{
,,,,//,,,,ListViewItem lvi =, new ListViewItem (oldbRed [0] .ToString ());
,,,,//,,,,lvi.SubItems.Add (oldbRed [1] .ToString ());
,,,,//,,,,lvi.SubItems.Add (oldbRed [2] .ToString ());
,,,,//,,,,lvi.SubItems.Add (oldbRed [3] .ToString ());
,,,,//,,,,lvi.SubItems.Add (oldbRed [4] .ToString ());
,,,,//,,,,lvi.SubItems.Add (oldbRed [5] .ToString ());
,,,,//,,,,listView1.Items.Add (lvi);
,,,,//}
,,,,//oldbRed.Close ();
,,,,//con.Close ();
,,,,//con.Dispose ();
,,}
,才能赶上(Exception 犯错)
,,{
,,,,//如果出错,显示错误信息
,,,,MessageBox.Show (err.Message.ToString ());
,,}
}
