SQL 连接字符串 connStr

SQL 连接字符串 connStr

string connStr = "Data Source = 127.0.0.1; Initial Catalog = MyTest; User ID = sa;Password = 654321";

OR

"server=.;uid=sa;pwd=123456;database=MyTest";

OR(Windows 身份验证)

"Server=.;Initial Catalog=MyTest;Integrated Security=SSPI";

 

写在配置文件夹中

App.config

<connectionStrings>
<add name="dbConnStr" connectionString="Data Source = 127.0.0.1; Initial Catalog = MyTest; User ID = sa;Password = 654321"/>
</connectionStrings>

C#    先添加引用System.Configration

private static string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;

 

 

 Sqlite 连接字符串

"data source=C:\mytest.db;version=3"