How to quickly create a database connection string

1. New txt file, change suffix named UDL

2. Right-click to open in OLE DB Core Services mode

3, fill in the corresponding server name, login method, data source

4, open the file in TXT mode, the connection string has been generated, how, give Force bar

[OLE DB]
; Everything after the "is" an OLE DB initstring
Provider=SQLOLEDB.1; password=123456; Persist Security info=true; User id=sa;initial Catalog=dyanmsoftwebsite;data source=yygy\sqlexpress

5. Write the project configuration file

   <add key="sqlconnectionstring" value="Persist Security info=false; User Id=sa; Password=123456;initial catalog=dyanmsoftwebsite;data source=yygy\sqlexpress"></add>