using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.IO;namespace firstmdf
{
    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.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();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "insert into T_Users(UserName,Password)values('" + username + "','" + password + "')";
                  //  cmd.CommandText = "Insert into T_Users(UserName,Password)values('username','password')";
                    cmd.ExecuteNonQuery();
                    Console.WriteLine("插入成功");
                }
            }
            Console.WriteLine("打开数据库连接成功");
            Console.ReadKey();
        }
    }
}
//执行后,插入的数据不能显示出来,各位高手帮下忙哈!

解决方案 »

  1.   

    using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=
    |DataDirectory|\Database1.mdf;Integrated Security=true;User Instance=true;"))数据库路径是否正确。先用一个固定的路径试试看。
      

  2.   

    呵呵,解决了, dataDir = System.IO.Directory.GetParent(dataDir).Parent.FullName改为
    dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName就行了