C#在VisualStudio中操作SQL数据库文件

1. 要在项目中添加一个基于服务的数据库或本地数据库文件；

2. 在代码执行开始先运行如下代码，否则数据库表中看不到执行的语句

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

3. 定义连接字符串：@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"

4. 编写程序：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace 数据库1
{
    class Program
    {
        static void Main(string[] args)
        {
            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);
            }


            string connStr=@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    string username = Convert.ToString(System.DateTime.Now.Millisecond);
                    cmd.CommandText = "insert into t_user (username,password) values ('" + username + "', '3333')";
                    cmd.ExecuteNonQuery();
                    Console.WriteLine("执行成功");


                    cmd.CommandText = "select * from t_user where username='" + username + "'";
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            string password = reader.GetString(reader.GetOrdinal("password"));
                            Console.WriteLine("用户： " + username + ", 密码： " + password);
                        }
                        else
                        {
                            Console.WriteLine("没有这个用户 " + username);
                        }
                    }

                }
            }

            Console.ReadKey();


        }
    }
}