(一)常用連接:
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;");
posted on 2006-09-27 11:09
圣域飛俠 閱讀(156)
評論(0) 編輯 收藏 所屬分類:
數據庫