关于ACCESS的数据连接

string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection +=@"Data Source=\\192.168.1.10\\access\\CSharptest.mdb";


OleDbConnection objConnection = new OleDbConnection(strConnection); //建立连接
objConnection.Open(); //打开连接
OleDbCommand sqlcmd = new OleDbCommand(@"select * from person where personname='John'",objConnection); //sql语句
OleDbDataReader reader = sqlcmd.ExecuteReader(); //执行查询
int age = new int();
if(reader.Read()){ //这个read调用很重要！不写的话运行时将提示找不到数据
age = (int)reader["age"]; //取得字段的值
objConnection.Close();
reader.Close();