本文介绍了C#连接常用数据库的常用方法,供大家进行设计数据库程序时参考。
(一)常用连接:
(1)使用SqlConnection对象:
publicvoidSqlConnectionOpen()
{
SqlConnectionconn=newSqlConnection();
conn.ConnectionString="userid=sa;password=;initialcatalog=northwind;datasource=localhost;connectTimeout=20";
conn.Open();
}
(2)使用OleDbConnection对象:
publicvoidOleDBConnectionOpen()
{
OleDBConnectionconn=newOleDbconnection();
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Customer.mdb";
conn.Open();
}
(二)其它:
(1)ODBC连接Access本地数据库
conGoodDay.Open("Driver={MicrosoftAccessDriver(*.mdb)};"+"Dbq=C:\a.mdb;"+
"Uid=Admin;"+"Pwd=;");
(2)ODBC连接Access系统数据库
conGoodDay.Open("Driver={MicrosoftAccessDriver(*.mdb)};"+"Dbq=C:\a.mdb;"+
"SystemDB=Admin;"+"Pwd=;");
(3)ODBC连接Access系统数据库
conGoodDay.Open("Driver={MicrosoftAccessDriver(*.mdb)};"+"Dbq=\\server\share\a.mdb;");
(4)ODBC连接Excel系统数据库
conGoodDay.Open("Driver={MicrosoftAccessDriver(*.xls)};"+"DriverId=790;"+
"Dbq=C:\a.xls;"+"DefaultDir=c:\somepath;");
(5)ODBC连接Oracle系统数据库
conGoodDay.Open("Driver={MicrosoftODBCfororacle};"+"Server=OracleServer.world;"+
"Uid=Admin;"+"Pwd=password;");
(6)ODBC连接SqlServr
conGoodDay.Open("Driver={SqlServer};"+"Server=myServer;"+"Database=myDatabaseName;"
"Uid=Admin;"+"Pwd=password;");
(7)ODBC连接VisualFoxPro
conGoodDay.Open("Driver={MicrosoftVisualFoxProDriver};"+
"SourceType=DBC;"+"SourceDB=c:a.dbc;"+"Exclusive=No;");
本文源自:翔宇亭——IT乐园(),转载请保留此信息!