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