Error

ALOK SHARMA

Hi , I need a help on the below error . I am trying to insert values into table and also want to update Gridview simultaneously.

protected void btnSubmit_Click(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection(@"Data Source=SONY-VAIO\SQLEXPRESS;Initial Catalog=Employee;Integrated Security=True");
SqlCommand cmd = new SqlCommand("insert into Employe(Employee_Name,Gender,Mobile,Address,ity,State) values(@Employee_Name,@Gender,@Mobile,@Address,@City,@State",con);
con.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Employee_Name",txtEmpName.Text.ToString());
cmd.Parameters.AddWithValue("@Gender",RdGender.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@Mobile",txtMobile.Text.ToString());
cmd.Parameters.AddWithValue("@Address",txtAddress.Text.ToString());
cmd.Parameters.AddWithValue("@City",ddlCity.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@State",ddlState.SelectedValue.ToString());

int result = cmd.ExecuteNonQuery();
if (result > 0

{

FillGridView();
}

else{
Response.Write("Wrong insertion");
}

pasting

Incorrect syntax near '@State'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '@State'.

Source Error:

Line 38:        cmd.Parameters.AddWithValue("@State",ddlState.SelectedValue.ToString()); Line 39:        Line 40:        int result = cmd.ExecuteNonQuery(); Line 41:         if (result > 0) Line 42:         {

Source File: c:\Website_Project\mtEmployee\Employeemt.aspx.cs Line: 40

3 Replies

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

Vulpes12y ago
Well, there was definitely a syntax error in the query but I can't find anything wrong with this line at all:

cmd.Parameters.AddWithValue("@State",ddlState.SelectedValue.ToString());

If the SelectedValue property returned 'null' then this would obviously be a problem but I think you'd get a different error.

If you haven't tried it already, I'd still try correcting the query to see whether the error disappears.
ALOK SHARMA12y ago
Hi Vulpes , Ty for your reply. But error is shown in 37th line of state dropdownlist and cmd.ExecutenonQuery is highlighted belowas : Line 37: cmd.Parameters.AddWithValue("@State",ddlState.SelectedItem.Text.ToString()); Line 38: Line 39: int result = cmd.ExecuteNonQuery();
Vulpes12y ago
I think the error is actually in your query as there's no closing bracket after @State. So it should be:

SqlCommand cmd = new SqlCommand("insert into Employe(Employee_Name,Gender,Mobile,Address,ity,State) values(@Employee_Name,@Gender,@Mobile,@Address,@City,@State)",con);

Error

else{Response.Write("Wrong insertion");}

pasting

else{
Response.Write("Wrong insertion");
}