C#链接数据库时的两种情况

第一，当sqlserver服务为MSSQLSERVER 用如下方式链接

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();

string connectionString="server=.;database=Sql;uid=sa; pwd=123456";

conn.ConnectionString = connectionString;

conn.open();

第二，当sqlserver服务为SQLEXPRESS 用如下方式链接

SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();

scsb.DataSource = @"(local)\SQLExpress";

scsb.IntegratedSecurity = true;

scsb.InitialCatalog = sqlName;

SqlConnection conn = new SqlConnection(scsb.ConnectionString);

conn.open();