public static void Qy() {
string strConn = "Data Source=DESKTOP-QDQS9F8;Initial Catalog=QQ用户信息;User ID=sa;pwd =root";
SqlConnection conn = null;
try
{
conn = new SqlConnection(strConn);
conn.Open();
Console.WriteLine("请输入用户昵称");
string op7 = Console.ReadLine();
Console.WriteLine("请输入用户密码");
string op8 = Console.ReadLine();
Console.WriteLine("请输入邮箱");
string op9 = Console.ReadLine();
string op10 = string.Format("insert into userinfo values ('{0}','{1}','{2}','{3}','{4}','{5}') ",default, op7,op8,default,op9,default );
SqlCommand comm = new SqlCommand(op10, conn);
int eow = comm.ExecuteNonQuery();
if (eow > 0)
{
Console.WriteLine("添加成功");
}
else
{
Console.WriteLine("添加失败");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally {
conn.Close();
}
}
自增的字段不需要赋值,sql中不需要增加这个字段的。数据库会自动新增,从sql语句中去掉自增的字段