Registeration form Problem

Question

0.00/5 (No votes)

See more:

I m making a registration page, but getting below error:
Please help me out.

asp.net with C#, sql server 2008 r2

Error message is:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate.Button1_Click(Object sender, EventArgs e) ClientConnectionId:ee7557ca-0c9a-4ce2-9e47-de086c1357d4Thanks for Applying, We will response on your application shortly

My C# code is as follows:

C#

protected void Button1_Click(object sender, EventArgs e)
    {
         try
        {
            string str ="Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
            SqlConnection con = new SqlConnection(str);
            con.Open();
            string insertQuery = "insert into EnquiryTable (Name,Emailaddress,Contact,Highestqualification,Specialization,Institutename,Description,) values (@Name,@Emailaddress,@Contact,@Highestqualification,@Specialization,@Institutename,@Description)";
            SqlCommand com = new SqlCommand(insertQuery, con);
            com.Parameters.AddWithValue("@Name", txtName.Text);
            com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
            com.Parameters.AddWithValue("@Contactno", txtContactno.Text);
            com.Parameters.AddWithValue("@Highestqualification", txtHighestqualification.Text);
            com.Parameters.AddWithValue("@Specialization", ddlspecialization.SelectedItem.ToString());
            com.Parameters.AddWithValue("@Institutename", txtInstitutename.Text);
            com.Parameters.AddWithValue("@Description", txtDescription.Text);
            
            com.ExecuteNonQuery();

            con.Close();
        }

        catch (Exception ex)
        {
            Response.Write("Error Occured! Try Again" + ex.ToString());
        }
    }

Posted 3-Mar-14 18:12pm

manishmns12

Updated 3-Mar-14 18:18pm

Ankur^\m/

v2

Add a Solution

Comments

Tom Marvolo Riddle 4-Mar-14 0:18am

you're right.post it as a solution

5 solutions

Solution 4

It should be same name variables

make sure variable name is same

C#

protected void Button1_Click(object sender, EventArgs e)
    {
         try
        {
            string str ="Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
            SqlConnection con = new SqlConnection(str);
            con.Open();
            string insertQuery = "insert into EnquiryTable (Name,Emailaddress,Contact,Highestqualification,Specialization,Institutename,Description,) values (@Name,@Emailaddress,@Contact,@Highestqualification,@Specialization,@Institutename,@Description)";
            SqlCommand com = new SqlCommand(insertQuery, con);
            com.Parameters.AddWithValue("@Name", txtName.Text);
            com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
            <big>com.Parameters.AddWithValue("@Contact", txtContactno.Text);</big>
            com.Parameters.AddWithValue("@Highestqualification", txtHighestqualification.Text);
            com.Parameters.AddWithValue("@Specialization", ddlspecialization.SelectedItem.ToString());
            com.Parameters.AddWithValue("@Institutename", txtInstitutename.Text);
            com.Parameters.AddWithValue("@Description", txtDescription.Text);
            
            com.ExecuteNonQuery();
 
            con.Close();
        }
 
        catch (Exception ex)
        {
            Response.Write("Error Occured! Try Again" + ex.ToString());
        }
    }

Posted 3-Mar-14 18:36pm

Amalraj Ramesh

Updated 4-Mar-14 17:48pm

v4

Solution 5

you can remove , after Description.

string insertQuery = "insert into EnquiryTable (Name,Emailaddress,Contact,Highestqualification,Specialization,Institutename,Description,) values (@Name,@Emailaddress,@Contact,@Highestqualification,@Specialization,@Institutename,@Description)";

Posted 4-Mar-14 19:30pm

Mehul Thummar

Comments

manishmns12 5-Mar-14 1:40am

thank you sir...
sir can u please look for this issue of mine...

eroor message is:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'Current'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate2.Button1_Click(Object sender, EventArgs e) ClientConnectionId:734911b1-d058-4fcb-a9aa-0bcb2e233ac6Thanks for Applying, We will response on your application shortly

my.cs code is:

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into Current (Name,Emailaddress,Contactno,Qualification,Institute) values (@Name,@Emailaddress,@Contactno,@Qualification,@Institute)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
com.Parameters.AddWithValue("@Contactno", txtContactno.Text);
com.Parameters.AddWithValue("@Qualification", txtQualification.Text);
com.Parameters.AddWithValue("@Institute", txtInstitute.Text);

com.ExecuteNonQuery();

con.Close();

}

sql datatype is:
Name nvarchar(50)
Emailaddress nvarchar(50)
Contactno varchar(50)
Qualification nvarchar(50)
Institure nvarchar(MAX)

Mehul Thummar 5-Mar-14 2:15am

add CommandType

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into Current (Name,Emailaddress,Contactno,Qualification,Institute) values (@Name,@Emailaddress,@Contactno,@Qualification,@Institute)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.CommandType=CommandType.Text; // add the command type is Text.
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
com.Parameters.AddWithValue("@Contactno", txtContactno.Text);
com.Parameters.AddWithValue("@Qualification", txtQualification.Text);
com.Parameters.AddWithValue("@Institute", txtInstitute.Text);

com.ExecuteNonQuery();

con.Close();

}

manishmns12 5-Mar-14 1:53am

please sir...looo at this proble...
n in last it was:
Institute nvarchar(MAX)

Amalraj Ramesh 5-Mar-14 4:22am

give the exception details???

Mehul Thummar 5-Mar-14 4:40am

add CommandType

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into Current (Name,Emailaddress,Contactno,Qualification,Institute) values (@Name,@Emailaddress,@Contactno,@Qualification,@Institute)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.CommandType=CommandType.Text; // add the command type is Text.
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
com.Parameters.AddWithValue("@Contactno", txtContactno.Text);
com.Parameters.AddWithValue("@Qualification", txtQualification.Text);
com.Parameters.AddWithValue("@Institute", txtInstitute.Text);

com.ExecuteNonQuery();

con.Close();

}
catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}
}

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Siva Hyderabad · Accepted Answer · 2014-03-03T18:20:00

Solution 2

C#

(Name,Emailaddress,Contact,Highestqualification,Specialization,Institutename,Description)values (@Name,@Emailaddress,@Contact,@Highestqualification,@Specialization,@Institutename,@Description)

remove comma after Description

Posted 3-Mar-14 18:20pm

Siva Hyderabad

Updated 3-Mar-14 18:24pm

v2

Comments

manishmns12 4-Mar-14 0:30am

Sir what does this error means...how cn i overcome it...please help me out

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@Contact". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate.Button1_Click(Object sender, EventArgs e) ClientConnectionId:835d11f0-b699-4386-b653-0c4bf6ed1bf7Thanks for Applying, We will response on your application shortly

Siva Hyderabad 4-Mar-14 0:32am

com.Parameters.AddWithValue("@Contactno", txtContactno.Text);

replace this line with

com.Parameters.AddWithValue("@Contact", txtContactno.Text);

manishmns12 4-Mar-14 0:36am

Thanks alot....

sir i had another page n there is one more option of uploading file...
n i want that the file should be saved in database so hw cn i do that..
what codings and in database which dtatype shld i use...as i had never done it before..uploading a file...so cn u please help me..

Siva Hyderabad 4-Mar-14 0:46am

http://www.aspdotnet-suresh.com/2013/01/aspnet-download-and-upload-files-to.html

see this link ...firstly You should create Table for that requirement..

Ankur^\m/ · Accepted Answer · 2014-03-03T18:19:00

Solution 1

You have an extra comma (,) after description in this line.

<br />
(Name,Emailaddress,Contact,Highestqualification,Specialization,Institutename,Description,)

Remove it and it should be fine.

Posted 3-Mar-14 18:19pm

Ankur^\m/

Comments

manishmns12 4-Mar-14 0:30am

Sir what does this error means...how cn i overcome it...please help me out

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@Contact". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate.Button1_Click(Object sender, EventArgs e) ClientConnectionId:835d11f0-b699-4386-b653-0c4bf6ed1bf7Thanks for Applying, We will response on your application shortly

Ankur^\m/ 4-Mar-14 0:35am

Ah, you gotta learn the fundamentals first.
You are using @Contact in the query that you have created but you pass @contactno as parameter. They MUST be same.

manishmns12 4-Mar-14 0:36am

Thanks alot....

sir i had another page n there is one more option of uploading file...
n i want that the file should be saved in database so hw cn i do that..
what codings and in database which dtatype shld i use...as i had never done it before..uploading a file...so cn u please help me..

Amalraj Ramesh · Accepted Answer · 2014-03-03T18:20:00

try this let me know any other issue

C#

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str ="Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable (Name,Emailaddress,Contact,Highestqualification,Specialization,Institutename,Description) values (@Name,@Emailaddress,@Contact,@Highestqualification,@Specialization,@Institutename,@Description)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
com.Parameters.AddWithValue("@Contactno", txtContactno.Text);
com.Parameters.AddWithValue("@Highestqualification", txtHighestqualification.Text);
com.Parameters.AddWithValue("@Specialization", ddlspecialization.SelectedItem.ToString());
com.Parameters.AddWithValue("@Institutename", txtInstitutename.Text);
com.Parameters.AddWithValue("@Description", txtDescription.Text);

 
com.ExecuteNonQuery();


 
con.Close();

}
 
catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Registeration form Problem

5 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us