Easily obtain various database connection strings of C # ADO. net

Sometimes, do you have a headache because you forget the connection string of a database?
Haha! The following describes how to easily obtain the database connection string.

The following uses access as an example:

1. First, create a text file TXT and set its suffix to udl. The name can be any one.
2. Double-click to open it! You can see the following interface:

3. Select the provider you want to connect to the database. for access, select Microsoft JET 4.0 ole db provider, and then click the next step or select the connection tab. Shown as follows:

4. Select or enter the database name. Click OK.
5. The connection to the database has actually been completed. The last step is to obtain the connection string. Use NotePad to open the udl file we just created. You will see:
 

[Oledb]
; Everything after this line is an ole db initstring
Provider = Microsoft. Jet. oledb.4.0; Data Source = E:/desktop/xhzd. mdb; persist Security info = false

The red is the connection string you want.

Haha, That's easy! Try it now!

Go directlyHttp://www.connectionstrings.com/
All the connection strings you want can be found ..

From: http://www.chinaret.com/user/topic_view.aspx? U = jianfangkk & id = 04ff850e-f851-43b2-b8b4-e9422f3833fd