Visual Studio 2012 (Databese Connectivity)

Abhijit Chougule

I am getting the follpwing error

Error:System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'where'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection

I have writtrn the code for connction as

SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
            con.Open();
            string checkuser = "select count(*) from Userdata where Username = '" + txtUserName.Text + "'";
            SqlCommand com = new SqlCommand(checkuser, con);
            int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
            if (temp == 1)
            {
                Response.Write("User Already Exists");
            }

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Chadha4y ago
check if the connection string returns the valid connection using debug mode
+1
Richel Debalucos4y ago
Same problem
+1
Manish Kumar Choudhary11y ago
It's working.
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);
con.Open();
string checkuser = "select count(*) from Userdata where Username ='"+TextBox1.Text+"'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar());
if (temp == 1)
{
Response.Write("User Already Exists");
}
else
{
Response.Write("User No Exist Exists");
}
0
Jitendra Kumar11y ago
Hello Abhijit,

Check select query. in sql server run the query and check error. if any problem plz let me know.

select count(*) from Userdata where Username = '"' + txtUserName.Text + '"'
+1