iam getting error in defaul.aspx.cs page

Question

1.00/5 (1 vote)

See more:

Line 18: string CheckUser="select count(*) from UserData where UserName='" +TextBoxUN.Text + "'";
Line 19: SqlCommand com = new SqlCommand(CheckUser, con);
Line 20: int temp = Convert.ToInt32(com.ExecuteScalar().ToString ());
Line 21: if (temp == 1)
Line 22:

error in line 20

Posted 26-Feb-14 17:10pm

harshavardhan12345678

Updated 27-Jan-18 19:29pm

Add a Solution

Comments

Tom Marvolo Riddle 26-Feb-14 23:28pm

what's the error?

harshavardhan12345678 26-Feb-14 23:30pm

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser="select count(*) from UserData where UserName='" +TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString ());
if (temp == 1

harshavardhan12345678 26-Feb-14 23:30pm

error in line 20

Priya Dharshini Aug2022 4-Aug-22 4:36am

Incorrect syntax near','

Karthik_Mahalingam 26-Feb-14 23:31pm

what error message you are getting ?

harshavardhan12345678 26-Feb-14 23:32pm

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser="select count(*) from UserData where UserName='" +TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString ());
if (temp == 1)

Karthik_Mahalingam 26-Feb-14 23:35pm

Error Message ???

harshavardhan12345678 26-Feb-14 23:47pm

this was the program

public partial class Registrationaspx : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser = "select count(*) from UserData where User Name='" + TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("User already Exists");
}
con.Close();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string insertQuery = "insert into UserData(User Name,Email,Password,country)values(@Uname,@email,@password,@country)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Uname", TextBoxUN.Text);
com.Parameters.AddWithValue("@email", TextBoxEmail.Text);
com.Parameters.AddWithValue("@password", TextBoxPass.Text);
com.Parameters.AddWithValue("@country", DropDownListCountry.SelectedItem.ToString());

com.ExecuteNonQuery();
Response.Redirect("Mnager.aspx");
Response.Write("Registration is Successfull..........");

con.Close();
}
catch (Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
}
}

harshavardhan12345678 27-Feb-14 0:01am

now error in

User already ExistsError:System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'User'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Registrationaspx.Button1_Click1(Object sender, EventArgs e) in c:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Registrationaspx.aspx.cs:line

harshavardhan12345678 26-Feb-14 23:39pm

An expression of non-boolean type specified in a context where a condition is expected, near 'Name'.

harshavardhan12345678 27-Feb-14 2:00am

Thank so much brother.........

Prasad Avunoori 26-Feb-14 23:33pm

What value you are passing in TextBoxUN.Text ?

Karthik_Mahalingam 26-Feb-14 23:36pm

try this and tell me what error message u r getting

try
{
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
}
catch (Exception)
{

throw;
}

3 solutions

Solution 3

Columns in the SQL queries should be enclosed in Square Bracket if the Column Name contains special character or Space . So use [User Name] in your Select and insert queries.

Posted 26-Feb-14 18:08pm

JoCodes

Comments

Karthik_Mahalingam 27-Feb-14 1:43am

5, for providing information.

JoCodes 27-Feb-14 2:00am

Thanks alot Karthik.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2014-02-26T17:52:00

Solution 1

Try this

C#

string checkuser = "select count(*) from UserData where [User Name]='" + TextBoxUN.Text + "'";

Posted 26-Feb-14 17:52pm

Karthik_Mahalingam

Comments

JoCodes 27-Feb-14 2:01am

5 , for the code :)

Karthik_Mahalingam 27-Feb-14 2:04am

:)

Siva Hyderabad 28-Feb-14 6:58am

+5

Ramug10 · Accepted Answer · 2014-02-26T18:04:00

Try the below code..

protected void Page_Load(object sender, EventArgs e)
       {
           if (IsPostBack)
           {
               try
               {
                   SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
                   con.Open();
                   string checkuser = "select count(*) from UserData where [User Name]='" + TextBoxUN.Text + "'";
                   SqlCommand com = new SqlCommand(checkuser, con);
                   int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
                   if (temp == 1)
                   {
                       Response.Write("User already Exists");
                   }

               }

               catch (Exception ex)
               {
                   Response.Write(ex.Message);
               }
               finally
               {
                   con.Close();
               }
           }
       }

iam getting error in defaul.aspx.cs page

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

iam getting error in defaul.aspx.cs page

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us