插不进去数据

Question

  string dataDir = AppDomain.CurrentDomain.BaseDirectory;
            if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith
                (@"\bin\Release\"))
            {
                dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData("DataDirectory ", dataDir);            }            Console.WriteLine("请输入 用户名:");
            string username = Console.ReadLine();
            Console.WriteLine("请输入密码:");
            string password = Console.ReadLine();            using (SqlConnection conn = new SqlConnection
                (@"Data Source=.\SQLEXPRESS;AttachDBFilename=
                 |DataDirectory|\Database1.mdf;
                  Integrated Security=True;User Instance=True;"))
            {
                conn.Open();
                Console.WriteLine("第一步连接数据库成功");
                using (SqlCommand cmd = conn.CreateCommand())
                {
        cmd.CommandText = "Insert into Table1 (Name,Password) values('" + username + "','" + password + "')";
                    cmd.ExecuteNonQuery();
                    Console.WriteLine("插入成功");
                }
            }
没有错误,但是在数据库表中显示不出来插入的数据.为啥?

Answer 1

如果没有错误，应该是可以的，调试下ExecuteNonQuery的返回值，另外检查自己是否查错数据库了

Answer 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);
            }我把上面这段删除再粘一段和它一样的上去,就可以看到数据了,为啥