SqlConnection connection = new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+
"Initial Catalog = NorthWind"); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT EmployeeID, FirstName,LastName from Employees"; SqlDataReader reader = command.ExecuteReader(); while(reader.Read())
{
Console.WriteLine("\t{0}\t{1}\t{2}",reader["EmployeeID"],reader["FirstName"],reader["LastName"]); } reader.Close();
connection.Close();以上代码出现“不存在或访问被拒绝”,那个数据库已经放在同一个目录下面了,是不是没有安装sqlserver造成的这个原因阿?
"Initial Catalog = NorthWind"); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = "SELECT EmployeeID, FirstName,LastName from Employees"; SqlDataReader reader = command.ExecuteReader(); while(reader.Read())
{
Console.WriteLine("\t{0}\t{1}\t{2}",reader["EmployeeID"],reader["FirstName"],reader["LastName"]); } reader.Close();
connection.Close();以上代码出现“不存在或访问被拒绝”,那个数据库已经放在同一个目录下面了,是不是没有安装sqlserver造成的这个原因阿?
SqlConnection connection= new SqlConnection(cString);
试试
汗!-_-
当然要先安装数据库才能访问的,就一个数据库文件那是不行的哦~~