★(一)常用连接: 1.使用SqlConn...... (一)常用连接: 1.使用SqlConnection对象: public void SqlConnectionOpen() { SqlConnection conn= new SqlConnection(); conn.ConnectionString = "user id=sa;password=;initial catalog=northwind;datasource=localhost;connect Timeout=20"; conn.Open(); } 2.使用OleDbConnection对象: public void OleDBConnectionOpen() { OleDBConnection conn = new OleDbconnection(); conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Customer.mdb"; conn.Open(); } (二)其它: 1.ODBC连接Access本地数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=C:\a.mdb;"+ "Uid=Admin;"+"Pwd=;"); 2.ODBC连接Access系统数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=C:\a.mdb;"+ "SystemDB=Admin;"+"Pwd=;"); 3.ODBC连接Access系统数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.mdb)};"+"Dbq=\\server\share\a.mdb;"); 4.ODBC连接Excel系统数据库 conGoodDay.Open("Driver={Microsoft Access Driver(*.xls)};"+"DriverId=790;"+ "Dbq=C:\a.xls;"+"DefaultDir=c:\somepath;"); 5.ODBC连接Oracle系统数据库 conGoodDay.Open("Driver={Microsoft ODBC for Oracle};"+"Server=OracleServer.world;"+ "Uid=Admin;"+"Pwd=password;"); 6.ODBC连接Sql Servr conGoodDay.Open("Driver={Sql Server};"+"Server=myServer;"+"Database=myDatabaseName;" "Uid=Admin;"+"Pwd=password;"); 7.ODBC连接Visual FoxPro conGoodDay.Open("Driver={Microsoft Visual FoxPro Driver};"+ "SourceType=DBC;"+"SourceDB=c:a.dbc;"+"Exclusive=No;"); |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 23:34 , Processed in 0.157537 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.