C # connect to each database

The following items are used at work and are indeed available.

Of course there are still many methods, as well as other databases. I will continue to make up...

 

1. C #ConnectionAccess

Using System. Data. oledb;
Provider = Microsoft. Jet. oledb. 4.0 ; Data Source = Filepath
// Data source is the access data file in the corresponding path.

 2. C #Connect to SQL Server

Using System. Data. sqlclient;
Server = . \ Sqlexpress; Database = Databasename; uid = Username; pwd = Secret
// Server can also use data source; database can also use initial Catalog; window authentication can also be used: Integrated Security = sspi.

3. C #Connect to MySQL

Using MySQL. Data. mysqlclient; // Add mysql. Data. dll reference
Server = Localhost; Database = Databasename; uid = Username; pwd = Secret

Download mysql. Data. dll:Mysql.data.rar (my version is 5.0.8.1)

4. C #ConnectionSybase(Sqlanywhere)

Using System. Data. ODBC;
Driver = {SQL Anywhere 10 }; Uid = Username; pwd = Secret; DSN = Dsnname
// DSN is the name of the database.