Question

用户代码未处理 System.ArgumentException,Message="不支持关键字: “pws”

出错的代码如下:
SqlConnection objConnection = new SqlConnection(strConnect);
SqlCommand objCommand = new SqlCommand("", objConnection);
objCommand.CommandText = "SELECT USERNAME FORM USERS WHERE USERNAME=@USERNAME";
objCommand.Parameters.Add("USERNAME", SqlDbType.VarChar);
objCommand.Parameters["USERNAME"].Value = tbxUserName.Text.Trim();

SqlConnection objConnection = new SqlConnection(strConnect);
SqlCommand objCommand = new SqlCommand("", objConnection);
objCommand.CommandText = "INSERT INTO USERS" + "(USERNAME,NICKNAME,USERPASSWORD,USEREMAIL,USERROLE,CREATDATE,LASTMODIFYDATE)" + "VALUES" + "(@USERNAME,@NICKNAME,@USERPASSWORD,@USEREMAIL,@USERROLE,@CREATDATE,@LASTMODIFYDATE)";
objCommand.Parameters.Add("USERNAME", SqlDbType.VarChar);
objCommand.Parameters.Add("NICKNAME", SqlDbType.VarChar);
objCommand.Parameters.Add("USERPASSWORD", SqlDbType.VarChar);
objCommand.Parameters.Add("USEREMAIL", SqlDbType.VarChar);
objCommand.Parameters.Add("USERROLE", SqlDbType.Int);
objCommand.Parameters.Add("CREATDATE", SqlDbType.DateTime);
objCommand.Parameters.Add("LASTMDIFDATE", SqlDbType.DateTime);

objCommand.Parameters["USERNAME"].Value = tbxUserName.Text.Trim();
objCommand.Parameters["NICKNAME"].Value = tbxNickName.Text.Trim();
objCommand.Parameters["USERPASSWORD"].Value = tbxPassword.Text.Trim();
objCommand.Parameters["USEREMAIL"].Value = tbxEmail.Text.Trim();
objCommand.Parameters["USERROLE"].Value = 5;
objCommand.Parameters["CREATDATE"].Value = DateTime.Now;
objCommand.Parameters["LASTMDIFDATE"].Value = DateTime.Now;

Answer 1

objCommand.Parameters["USERNAME"].Value = tbxUserName.Text.Trim();
应该写成
objCommand.Parameters["@USERNAME"].Value = tbxUserName.Text.Trim();
其它的错误目前还没有留意，你先这样试试看吧