博客

C#连接数据库的代码

  • Post author:
  • Post category:其他


            string dataDir = AppDomain.CurrentDomain.BaseDirectory;
            if(dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
            {
                dataDir=System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData("DataDirectory",dataDir);
            }

            using(SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\db1.mdf;Integrated Security=true;User Instance=true"))
            {
                conn.Open();
                Console.WriteLine("aaa");
            }

c#链接ado.net