I am write the update query in asp.net. when i update it shows the
Incorrect syntax near '@
error is here
Line 82: cmd.Parameters.AddWithValue("@repass", repass.Text);
Line 83: cmd.Parameters.AddWithValue("@imagelink", imagelink);
Line 84: cmd.ExecuteNonQuery();
Line 85: con.Close();
Line 86:
my table definition is:
Regist_ID numeric(18, 0) Unchecked
Name nvarchar(100) Unchecked
ParentsName nvarchar(100) Checked
DOB nvarchar(MAX) Checked
Gender nvarchar(MAX) Checked
ContactsNo nvarchar(50) Checked
EmailID nvarchar(100) Checked
Address nvarchar(MAX) Checked
Hobbies nvarchar(MAX) Checked
Password nvarchar(50) Checked
Re_Password nvarchar(50) Checked
Profile_IMG nvarchar(MAX) Checked
What I have tried:
SqlConnection con = new SqlConnection(@"Data Source=Home-PC\SQLEXPRESS;Initial Catalog=KARATE-ACADEMY;Integrated Security=True");
con.Open();
String update = "update StdRegistration_db set Name= @name,ParentsName= @parentsname,DOB= @DOB,Gender=@Gender,ContactsNo= @contacts ,EmailID= @email,Address=address @,Hobbies= @activity,Password= @password,Re_Password= @repass ,Profile_IMG= @imagelink where Name='" + Session["Name"].ToString() + "'";
SqlCommand cmd = new SqlCommand(update, con);
cmd.Parameters.AddWithValue("@name", name.Text);
cmd.Parameters.AddWithValue("@parentsname", parentsname.Text);
cmd.Parameters.AddWithValue("@DOB", DOB.Text);
cmd.Parameters.AddWithValue("@Gender", Gender);
cmd.Parameters.AddWithValue("@contacts", contacts.Text);
cmd.Parameters.AddWithValue("@email", email.Text);
cmd.Parameters.AddWithValue("@address", address.Text);
cmd.Parameters.AddWithValue("@activity", activity);
cmd.Parameters.AddWithValue("@password", password.Text);
cmd.Parameters.AddWithValue("@repass", repass.Text);
cmd.Parameters.AddWithValue("@imagelink", imagelink);
cmd.ExecuteNonQuery();
con.Close();