SQL链接语句
1 string dataDir=AppDomain.CurrentDomain.BaseDirectory; 2 if(dataDir.EndsWith(@"\bin\Debug")||dataDir.EndsWith(@"\bin\Release")) 3 { 4 dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName; 5 AppDomain.CurrentDomain.SetData("DataDirectory",dataDir); 6 7 } 8 Using(SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\VS2010\Test\ADO\Database1.mdf; 9 Integrated Security=True;User Instance=True"))//在VS中可右栏可直接查到Data Source
{conn.Open()} ////所有ADO.NET接口资源都实现了IDisposable接口,可以试用using 进行资源管理
11 Console.WriteLine("数据库连接成功"); 12 Console.ReadKey();