数据库连接配置

  1）访问Access 2000
     "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=databaseName;User ID=userName;Password=userPassWord"

  2)访问ODBC数据
   "Provider=MADASQL;DSN=dsnName;UID=userName;PWD=userPassword;"
 
  3)访问Oracle数据库
    “Provider=MSDAORA;Data Sourse=serverName;User ID=userName;Password=userPassword;"

  3)访问MS SQL数据库
   "Provider=SQLOLEDB,Data Source=serverName;Initial Catalog=databaseName;User ID=userName;Password=userPassword;"

 

OleDbConnection con=new
    OleDbConnection(ConfigurationSettings.AppSettings["constring"].ToString());
   con.Open();
   string name=txtname.Text.Trim();
   string psd=txtpsd.Text.Trim();
   com=new OleDbCommand("select * from Users where uname="+name+",upsd="+psd,con);
   dr=com.ExecuteReader();
   if(dr.Read())
   {
    MessageBox.Show("登录成功");
   }

access2007   Provider=Microsoft.ACE.OLEDB.12.0;Data Source="d:/xxx.accdb";Persist Security Info=False