//允许用户输入账号密码，将新账户数据插入数据库

 Console.WriteLine("请输入要插入的用户名：");
            string username = Console.ReadLine();
            Console.WriteLine("请输入密码");
            string pwd = Console.ReadLine();
            using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\VS2010\Test\ADO\Database1.mdf;
Integrated Security=True;User Instance=True"))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {   //User是关键字，表名以T_开头，字段F_开头
                    cmd.CommandText = "Insert into T_User(UserName,Password)values('" + username + "','" + pwd + "')";
                    //cmd.CommandText = "Insert into T_User(UserName,Password) vaules('username','password')";
                    cmd.ExecuteNonQuery();
                    Console.WriteLine("插入成功");
                }
            }
            Console.WriteLine("打开数据库连接成功");
            Console.ReadKey();

 

转载于:https://www.cnblogs.com/xudaxia/p/3277631.html