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

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 

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 

What's the value in your DropDownList3.SelectedItem.Value?

 

Try like below

st = "select * from tbl_city where State_ID= '" + DropDownList3.SelectedItem.Value +"'";