日期:2014-05-18  浏览次数:20574 次

新手请教ASP.NET问题,为什么在下面代码中,数据入不了库,最好能给我段代码,谢谢
//插入个人注册资料
  string sql = string.Format("INSERT INTO people(name,password,qq,msn,youxiang,phone) VALUES({0},{1},{2},{3},{4},{5})", this.txtzhanghao.Text, this.txtpass1.Text, this.txtqq.Text, this.txtmsn.Text, this.txtyouxiang.Text, this.txtphone.Text); 
   
  SqlConnection con = new SqlConnection("server=RANDY-PC;uid=sa;pwd=happy;database=blog");
  SqlCommand com = con.CreateCommand();
  com.CommandText = sql;
  con.Open();
  int result = 0;
  try
  {
  result = com.ExecuteNonQuery();
  }
  catch (Exception ex)
  {
  }
  finally
  {
  con.Close();
  }
  if (result == 1)
  {
  this.Response.Write("<script type='text/javascript' language='javascript'>alert('注册成功')</script> ");
  }

------解决方案--------------------
字段名name是关键字改成[name]