C#数据库连接的三种方式: //ACCESS 2007数据库的连接: string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("App_Data/db.accdb"); OleDbConnection objConnection = new OleDbConnection(strConnection); objConnection.Open(); //SQL Server 2005数据库的连接: string strConnection = "data source=LOCALHOST//SQLEXPRESS;User Id=ranqilei;Password=ranqilei520;packet size=4096;database=NewBase"; //string strConnection = "server=LOCALHOST//SQLEXPRESS;User=username;Password=userpassword;database=NewBase";//SQL用户模式的验证。 string strConnection = "server=LOCALHOST//SQLEXPRESS;database=NewBase;Integrated Security=true"; //Windows模式的验证。 SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); //适配器连接数据库 string strConnection = "server=LOCALHOST//SQLEXPRESS;User=ranqilei;Password=ranqilei520;database=NewBase";//SQL用户模式的验证。 string strConnection = "server=LOCALHOST//SQLEXPRESS;database=NewBase;Integrated Security=true"; //Windows模式的验证。 SqlConnection objConnection = new SqlConnection(strConnection); SqlDataAdapter objDataAdapter = new SqlDataAdapter("select * from [User]", objConnection);