＋设为首页 ＋添加到收藏夹
String insertCmd = "insert into UserInfo (NickName,TrueName,Password,Sex,Birthday,Email,Telephone,registerTime,University,ForumSignName,ForumImage,QQ,ICQ,ClubID) values(@nickname,@TrueName,@password,@sex,@birth,@email,@tel,,@registerTime,@university,@ForumSignName,@ForumImage,@QQ,@ICQ,@ClubID)";
SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
myCommand.Parameters.Add(new SqlParameter("@nickname", SqlDbType.NVarChar, 30));
myCommand.Parameters["@nickname"].Value=this.txtNickname.Text;
myCommand.Parameters.Add(new SqlParameter("@TrueName", SqlDbType.Char,10));
myCommand.Parameters["@TrueName"].Value=name.Text;
myCommand.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar,20));
myCommand.Parameters["@password"].Value=password.Text;
myCommand.Parameters.Add(new SqlParameter("@sex", SqlDbType.TinyInt, 1));
myCommand.Parameters["@sex"].Value=this.sex.SelectedIndex;
myCommand.Parameters.Add(new SqlParameter("@birth", SqlDbType.DateTime, 8));
myCommand.Parameters["@birth"].Value=birthday;
myCommand.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, 50));
myCommand.Parameters["@email"].Value=email.Text;
myCommand.Parameters.Add(new SqlParameter("@tel", SqlDbType.NVarChar, 30));
myCommand.Parameters["@tel"].Value=tel.Text;
myCommand.Parameters.Add(new SqlParameter("@registerTime", SqlDbType.DateTime, 8));
myCommand.Parameters["@registerTime"].Value=registerTime;
myCommand.Parameters.Add(new SqlParameter("@university", SqlDbType.NVarChar, 50));
myCommand.Parameters["@university"].Value=txtUniv.Text;
myCommand.Parameters.Add(new SqlParameter("@ForumSignName", SqlDbType.Text, 100));
myCommand.Parameters["@ForumSignName"].Value=txtSignature.Text;
myCommand.Parameters.Add(new SqlParameter("@ForumImage", SqlDbType.NVarChar, 100));
myCommand.Parameters["@ForumImage"].Value=this.listImage.SelectedIndex+1;
myCommand.Parameters.Add(new SqlParameter("@QQ", SqlDbType.NVarChar, 20));
myCommand.Parameters["@QQ"].Value=this.TextBox1.Text.Trim();
myCommand.Parameters.Add(new SqlParameter("@ICQ", SqlDbType.NVarChar, 20));
myCommand.Parameters["@ICQ"].Value=this.TextBox2.Text.Trim();
myCommand.Parameters.Add(new SqlParameter("@ClubID", SqlDbType.Int, 4));
myCommand.Parameters["@ClubID"].Value=Convert.ToInt32(this.clubList.SelectedValue.Trim());
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
提示异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: , 附近有语法错误。，不知道是什么原因
String insertCmd = "insert into UserInfo (NickName,TrueName,Password,Sex,Birthday,Email,Telephone,registerTime,University,ForumSignName,ForumImage,QQ,ICQ,ClubID) values(@nickname,@TrueName,@password,@sex,@birth,@email,@tel,,@registerTime,@university,@ForumSignName,@ForumImage,@QQ,@ICQ,@ClubID)"; //* 多了个逗号
