ado.net连接Mssqlserver数据库

概述string dateDir = AppDomain.CurrentDomain.BaseDirectory; if (dateDir.EndsWith(@"/Bin/DeBug/")||dateDir.EndsWith(@"/Bin/Release/")) { dateDir = System.IO.Direc

string dateDir = AppDomain.CurrentDomain.BaseDirectory; if (dateDir.EndsWith(@"/Bin/DeBUG/")||dateDir.EndsWith(@"/Bin/Release/")) { dateDir = System.IO.Directory.GetParent(dateDir).Parent.Parent.Fullname; AppDomain.CurrentDomain.SetData("DataDirectory",dateDir); } sqlConnection conn = new sqlConnection(); conn.ConnectionString = @"Data Source=./sqlEXPRESS;AttachDBfilename=|DataDirectory|/Database1.mdf;Integrated Security=True;User Instance=True"; conn.open(); Console.Writeline("打开成功"); sqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Insert into Person(name) values('ac')"; cmd.ExecuteNonquery(); cmd.dispose(); conn.dispose();

总结

以上是内存溢出为你收集整理的ado.net连接Mssqlserver数据库全部内容，希望文章能够帮你解决ado.net连接Mssqlserver数据库所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。