C#中连接各种数据库方法.docx
《C#中连接各种数据库方法.docx》由会员分享，可在线阅读，更多相关《C#中连接各种数据库方法.docx（11页珍藏版）》请在冰点文库上搜索。
C#中连接各种数据库方法
SQLServer
ODBC
StandardSecurity:
"Driver={SQLServer};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
Trustedconnection:
"Driver={SQLServer};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
Promptforusernameandpassword:
oConn.Properties（"Prompt"）=adPromptAlways
oConn.Open"Driver={SQLServer};Server=Aron1;DataBase=pubs;"
OLEDB,OleDbConnection（.NET）
StandardSecurity:
"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;"
TrustedConnection:
"Provider=sqloledb;DataSource=Aron1;InitialCatalog=pubs;IntegratedSecurity=SSPI;"
（useserverName\instanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000）
Promptforusernameandpassword:
oConn.Provider="sqloledb"
oConn.Properties（"Prompt"）=adPromptAlways
oConn.Open"DataSource=Aron1;InitialCatalog=pubs;"
ConnectviaanIPaddress:
"Provider=sqloledb;DataSource=190.190.200.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=asdasd;"
（DBMSSOCN=TCP/IPinsteadofNamedPipes,attheendoftheDataSourceistheporttouse（1433isthedefault））
SqlConnection（.NET）
StandardSecurity:
"DataSource=Aron1;InitialCatalog=pubs;UserId=sa;Password=asdasd;"
TrustedConnection:
"DataSource=Aron1;InitialCatalog=pubs;IntegratedSecurity=SSPI;"
（useserverName\instanceNameasDataSourcetouseanspecifikSQLServerinstance,onlySQLServer2000）
ConnectviaanIPaddress:
"DataSource=190.190.200.100,1433;NetworkLibrary=DBMSSOCN;InitialCatalog=pubs;UserID=sa;Password=asdasd;"
（DBMSSOCN=TCP/IPinsteadofNamedPipes,attheendoftheDataSourceistheporttouse（1433isthedefault））
DeclaretheSqlConnection:
C#:
usingSystem.Data.SqlClient;
SqlConnectionoSQLConn=newSqlConnection（）;
oSQLConn.ConnectionString="myconnectionstring";
oSQLConn.Open（）;
VB.NET:
ImportsSystem.Data.SqlClient
DimoSQLConnAsSqlConnection=NewSqlConnection（）
oSQLConn.ConnectionString="myconnectionstring"
oSQLConn.Open（）
Access
ODBC
StandardSecurity:
"Driver={MicrosoftAccessDriver（*.mdb）};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
Workgroup:
"Driver={MicrosoftAccessDriver（*.mdb）};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin",""
OLEDB,OleDbConnection（.NET）
Standardsecurity:
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\somepath\mydb.mdb;UserId=admin;Password=asdasd;"
Workgroup（systemdatabase）:
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\somepath\mydb.mdb;JetOLEDB:
SystemDatabase=system.mdw;","admin",""
Withpassword:
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=\somepath\mydb.mdb;JetOLEDB:
DatabasePassword=MyDbPassword;","admin",""
Oracle
ODBC
Newversion:
"Driver={MicrosoftODBCforOracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
Oldversion:
"Driver={MicrosoftODBCDriverforOracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"
OLEDB,OleDbConnection（.NET）
Standardsecurity:
"Provider=msdaora;DataSource=MyOracleDB;UserId=UserName;Password=asdasd;"
Thisone'sfromMicrosoft,thefollowingarefromOracle
StandardSecurity:
"Provider=OraOLEDB.Oracle;DataSource=MyOracleDB;UserId=Username;Password=asdasd;"
TrustedConnection:
"Provider=OraOLEDB.Oracle;DataSource=MyOracleDB;OSAuthent=1;"
OracleConnection（.NET）
Standard:
"DataSource=Oracle8i;IntegratedSecurity=yes";
ThisoneworksonlywithOracle8irelease3orlater
DeclaretheOracleConnection:
C#:
usingSystem.Data.OracleClient;
OracleConnectionoOracleConn=newOracleConnection（）;
oOracleConn.ConnectionString="myconnectionstring";
oOracleConn.Open（）;
VB.NET:
ImportsSystem.Data.OracleClient
DimoOracleConnAsOracleConnection=NewOracleConnection（）
oOracleConn.ConnectionString="myconnectionstring"
oOracleConn.Open（）
DataShape
MSDataShape:
"Provider=MSDataShape.1;PersistSecurityInfo=False;DataProvider=MSDAORA;DataSource=orac;userid=username;password=mypw"
MySQL
ODBC
Localdatabase:
"Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"
Remotedatabase:
"Driver={mySQL};Server=;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
OLEDB,OleDbConnection（.NET）
Standard:
"Provider=MySQLProv;DataSource=mydb;UserId=UserName;Password=asdasd;"
MySqlConnection（.NET）
EID:
"DataSource=server;Database=mydb;UserID=username;Password=pwd;CommandLogging=false"
ThisoneisusedwitheInfoDesignsdbProvider,anadd-onto.NET
DeclaretheMySqlConnection:
C#:
usingEID.MySqlClient;
MySqlConnectionoMySqlConn=newMySqlConnection（）;
oMySqlConn.ConnectionString="myconnectionstring";
oMySqlConn.Open（）;
VB.NET:
ImportsEID.MySqlClient
DimoMySqlConnAsMySqlConnection=NewMySqlConnection（）
oMySqlConn.ConnectionString="myconnectionstring"
oMySqlConn.Open（）
IBMDB2
OLEDB,OleDbConnection（.NET）fromms
TCP/IP:
"Provider=DB2OLEDB;NetworkTransportLibrary=TCPIP;NetworkAddress=XXX.XXX.XXX.XXX;InitialCatalog=MyCtlg;PackageCollection=MyPkgCol;DefaultSchema=Schema;UserID=MyUser;Password=MyPW"
APPC:
"Provider=DB2OLEDB;APPCLocalLUAlias=MyAlias;APPCRemoteLUAlias=MyRemote;InitialCatalog=MyCtlg;PackageCollection=MyPkgCol;DefaultSchema=Schema;UserID=MyUser;Password=MyPW"
Sybase
ODBC
Standard:
"Driver={SYBASESYSTEM11};Srvr=Aron1;Uid=username;Pwd=password;"
Intersolv3.10:
"Driver={INTERSOLV3.1032-BITSybase};Srvr=Aron1;Uid=username;Pwd=password;"
Informix
ODBC
Informix3.30:
"Dsn='';Driver={INFORMIX3.3032BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username;PWD=myPwd
Informix-CLI2.5:
"Driver={Informix-CLI2.5（32Bit）};Server=myserver;Database=mydb;Uid=username;Pwd=myPwd"
DSN
ODBC
DSN:
"DSN=myDsn;Uid=username;Pwd=;"
FileDSN:
"FILEDSN=c:
\myData.dsn;Uid=username;Pwd=;"
Excel
ODBC
Standard:
"Driver={MicrosoftExcelDriver（*.xls）};DriverId=790;Dbq=C:
\MyExcel.xls;DefaultDir=c:
\mypath;"
OLEDB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:
\MyExcel.xls;ExtendedProperties=Excel8.0;HDR=Yes;"
"HDR=Yes;"indicatesthatthefirstrowcontainscolumnnames,notdata
DBF/FoxPro
ODBC
standard:
"Driver={MicrosoftdBASEDriver（*.dbf）};DriverID=277;Dbq=c:
\mydbpath;"
OLEDB,OleDbConnection（.NET）
standard:
"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:
\folder;ExtendedProperties=dBASEIV;UserID=Admin;Password="
Pervasive
ODBC
Standard:
"Driver={PervasiveODBCClientInterface};ServerName=srvname;dbq=@dbname"
常用连接:
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;"）;
升级会员 