用户注册问题
sql = "insert into users(uid,username,userpwd,E_mail) ";
sql = sql + " Values( ";
sql = sql + " ' " + id + " ', ";
sql = sql + " ' " + name + " ', ";
sql = sql + " ' " + passwd + " ', ";
sql = sql + " ' " + E_mail + " ') ";
comm = new SqlCommand(sql, Conn);
comm.ExecuteNonQuery();
dr.Close();
sql1 = "insert into usertemp(zsname,sex,mobile,dianhua,tongxun,post) ";
sql1 = sql1 + " Values( ";
sql1 = sql1 + " ' " + zs + " ', ";
sql1 = sql1 + " ' " + sex + " ', ";
sql1 = sql1 + " ' " + moblie + " ', ";
sql1 = sql1 + " ' " + dh + " ', ";
sql1 = sql1 + " ' " + tx + " ', ";
sql1 = sql1 + " ' " + post + " ') ";
comm = new SqlCommand(sql1, Conn);
comm.ExecuteNonQuery();
dr.Close();
label1.Text = "注册成功! ";
Session[ "username "] = name;