System.Data.SqlClient.SqlException: Incorrect syntax near '=

Question

DropDownList4.Items.Clear() DropDownList4.Items.Add(--Select City--) Dim st As String st = select * from tbl_city where State_ID= + DropDownList3.SelectedItem.Value Dim cm As New SqlCommand(st con) Dim da As New SqlDataAdapter(cm) Dim d As New DataTable() da.Fill(d) DropDownList4.DataSource = d DropDownList4.DataBind() this is my code i got error Incorrect syntax near '='. please help me i got error at this line da.Fill(d) thanks in advance please reply fast i really want help

Amit Gupta · Answer

Hey Saurabh Consider the following points: 1. You cannot use dropdownlist.Items.Add(..) when you are using its DataSource 2. To clear the items of Dropdownlist use Dropdownlist.DataSource = null; 3. As you are clearing the dropdownlist items and on the next line you are fetching its dropdownlist.SelectedItem.Value which its seems to be null thats why you are getting exxeption Update your code with the above points to resolve your issue. Feel free to ask Good Luck

Ranjit Powar · Answer

If you are using string in where condition then enclose value in single quotes as belowst = select * from tbl_city where State_ID=' + DropDownList3.SelectedItem.Value+'

saurabh tadvi · Answer

TextBox1.Text =  TextBox10.Text =  TextBox2.Text =  TextBox3.Text =  TextBox5.Text =  TextBox7.Text =  TextBox8.Text =  TextBox9.Text =  If RadioButton1.Checked Then RadioButton1.Checked = False ElseIf RadioButton2.Checked Then RadioButton2.Checked = False End If DropDownList3.Items.Clear() DropDownList3.Items.Add(-- Select State --) s = select * from tbl_state Dim cmd As New SqlCommand(s con) Dim sda As New SqlDataAdapter(cmd) Dim dt As New DataTable() sda.Fill(dt) DropDownList3.DataSource = dt DropDownList3.DataBind() DropDownList4.Items.Clear() DropDownList4.Items.Add(--Select City--) Dim st As String st = select * from tbl_city where State_ID=  + DropDownList3.SelectedItem.Value Dim cm As New SqlCommand(st con) Dim da As New SqlDataAdapter(cm) Dim d As New DataTable() da.Fill(d) DropDownList4.DataSource = d DropDownList4.DataBind() i wrote this code for clear all web controls and after clearing i want all data back which is in dropdown list

saurabh tadvi · Answer

value of dropdown is state names gujarat maharastra rajasthan

Amit Gupta · Answer

What's the value in your DropDownList3.SelectedItem.Value? Try like below st = select * from tbl_city where State_ID= ' + DropDownList3.SelectedItem.Value +';