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

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

 

posted @ 2013-08-23 15:33  -112  阅读(289)  评论(0编辑  收藏  举报