ado.net连接Mssqlserver数据库

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();

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!