消息='Userdata'附近的语法不正确 [英] Message=Incorrect syntax near 'Userdata'

问题描述

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
conn.Open();
string checkUser = " select count(*) form Userdata where Username='" + TextBoxUN.Text + "' ";
SqlCommand cmd = new SqlCommand(checkUser,conn);

***获得异常---

*** getting exception ---

System.Data.SqlClient.SqlException was unhandled by user code
  HResult=-2146232060
  Message=Incorrect syntax near 'Userdata' 

此行

at this line

int temp= Convert.ToInt32(cmd.ExecuteScalar().ToString()); // ***

if (temp==1)
{
   Response.Write("User Already Exists");
}
conn.Close();

推荐答案

FROM，而非FORM：

"FROM", not "FORM":

string checkUser = " select count(*) form Userdata where Username='" + TextBoxUN.Text + "' ";

应该是：

Should be:

string checkUser = " select count(*) FROM Userdata where Username='" + TextBoxUN.Text + "' ";

这篇关于消息='Userdata'附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！