.net 中数据库连接字符串怎么写

数据库连接字符串有2种方式：

1：sql字符串 如下：

string connStr = "server=.;uid=sa;pwd=123456;database=LPS";

2：sqlConnectionString对象

当不记得sqlConnectionString怎么写时，可以用下面的方法，还显的高大上

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();

builder.DataSource = "(local)";
builder.InitialCatalog = "Northwind";
builder.UserID = "user1";
builder.Password = "P@ssw0rd";
Console.WriteLine(builder.ConnectionString);