C # Summary of connecting to various databases.

1. Connect to Access

 

Code 1 public static OleDbConnection getConn ()
2 {
3 OleDbConnection Conn = null;
4 string StrConn = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source = D: \ AccessDataBase \ GuangXi. mdb ";
5 try
6 {
7 if (File. Exists (@ "D: \ AccessDataBase \ GuangXi. mdb "))
8 {
9 Conn = new OleDbConnection (StrConn );
10 Conn. Open ();
11}
12 return Conn;
13}
14 catch
15 {
16 return null;
17}
18}

2. Connect to Oracle

 

Code 1 public static OracleConnection getConn ()
2 {
3 string strConn = "Data Source = hvmdata; Persist Security Info = True; User ID = sysadmin; Password = adminsys; Unicode = True ";
4 try
5 {
6 OracleConnection Conn = new OracleConnection (strConn );
7 if (Conn. State! = ConnectionState. Open)
8 {
9 Conn. Open ();
10}
11 return Conn;
12}
13 catch
14 {
15 return null;
16}
17}

3. Connect to SQL Server2005

Code 1 public static SqlConnection getConn ()
2 {
3 string strConn = "Data Source = JFD \ SQLEXPRESS; database = mydayta; uid = sa; pwd = 123456 ;";
4 try
5 {
6 SqlConnection Conn = new SqlConnection (strConn );
7 if (Conn. State! = ConnectionState. Open)
8 {
9 Conn. Open ();
10}
11 return Conn;
12}
13 catch
14 {
15 return null;
16}
17}