电脑上已安装SQL Server Management Studio,并且可以连接成功NorthWind数据库,但在C#中无法连接,试了以下这么多种,都不正确,求教连接字符串应该怎么写?
string source = " Data Source = LENOVO-PC; Initial Catalog = NorthWind.MDF; Integrated Security = SSPI;";
string source = "Data Source= C:\\SQL Server 2000 Sample Databases\\NORTHWIND.MDF;Initial Catalog=NORTHWIND.MDF;Integrated Security=SSPI;";
string source = " Server = LENOVO-PC; Database = NorthWind.MDF; User ID = lenovo-PC\\lenovo;Trusted_Connection = true;";
string source = "Server = lenovo-PC\\SQLEXPRESS; Database = NORTHWIND.MDF;integrated security=true;";
string source = "Data Source = MSSQLSERVER; Initial Catalog = NORTHWIND.mdf; User Id =lenovo-PC\\lenovo;";
string source = " Data Source = LENOVO-PC; Initial Catalog = NorthWind.MDF; Integrated Security = SSPI;";
string source = "Data Source= C:\\SQL Server 2000 Sample Databases\\NORTHWIND.MDF;Initial Catalog=NORTHWIND.MDF;Integrated Security=SSPI;";
string source = " Server = LENOVO-PC; Database = NorthWind.MDF; User ID = lenovo-PC\\lenovo;Trusted_Connection = true;";
string source = "Server = lenovo-PC\\SQLEXPRESS; Database = NORTHWIND.MDF;integrated security=true;";
string source = "Data Source = MSSQLSERVER; Initial Catalog = NORTHWIND.mdf; User Id =lenovo-PC\\lenovo;";
public void SqlConnectionOpen()
{
SqlConnection conn= new SqlConnection();
conn.ConnectionString = "user id=sa;password=;initial catalog=northwind;datasource=localhost;connect Timeout=20";
conn.Open();
} 2. Windows 身份验证public void SqlConnectionOpen()
{
SqlConnection conn= new SqlConnection();
conn.ConnectionString = "Integrated Security=SSPI;initial catalog=northwind;datasource=localhost;connect Timeout=20";
conn.Open();
}
你的写法在数据库上有问题,无需加 .mdf string source = " Data Source = LENOVO-PC; Initial Catalog = NorthWind; Integrated Security = SSPI;";即可
//SQL2005 express版
private string connString = @"server=.\sqlExpress;database=taianDB;uid=sa;pwd=djx1218;pooling=false";
//Windows身份验证:
private string connString = "Data Source=IP\数据库实例名;Initial Catalog=Labeldb;Integrated Security=True";
//SQL SERVER身份验证
private string connString = @"server=.\MainServer;database=taianDB;uid=sa;pwd=djx1218";