Databinding of drop down list

See more:

.NET2.0

C#

.NET

SQL-Server

I am beginner in this field. i have problem with databinding of drop down list.Problem is that when i select an item in drop down list1 then drop down list2 doesn't show data related to selected value in 1st drop down list.problem is in databinding of drop down list2. What to do, plz help me.

  public SqlConnection conn = new SqlConnection("Data Source=.; uid=sa; password=123456; database=GD_Test");


    public void BindCountry()
    {
        conn.Open();
        SqlCommand cmd = new SqlCommand("Select * from Country", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        DDList1.DataSource = dr;
        DDList1.Items.Clear();
        DDList1.Items.Add("--Please Select country--");
        DDList1.DataTextField = "Country";
        DDList1.DataValueField = "CountryId";
        DDList1.DataBind();
        conn.Close();
    }
    public void BindState()
    {
        conn.Open();
        SqlCommand cmd = new SqlCommand("Select State,StateID from State where CountryID='" + DDList1.SelectedValue + "", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        DDList2.DataSource = dr;
        DDList2.Items.Clear();
        DDList2.Items.Add("--Please Select State--");
        DDList2.DataTextField = "State";
        DDList2.DataValueField = "StateID";
        DDList2.DataBind();
        conn.Close();
    }
    public void BindCity()
    {
        conn.Open();
        SqlCommand cmd = new SqlCommand("Select* from City where StateID='" + DDList2.SelectedValue + "", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        DDList3.DataSource = dr;
        DDList3.Items.Clear();
        DDList3.Items.Add("--Please Select City--");
        DDList3.DataTextField = "City";
        DDList3.DataValueField = "CityID";
        DDList3.DataBind();
        conn.Close();
    }

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
            BindCountry();
    }
    

    protected void DDList2_SelectedIndexChanged(object sender, EventArgs e)
{
    
        BindCity();
    }



    protected void DDList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindState();

    }

Following is the error its showing in case of BindState() method near 'SqlDataReader dr = cmd.ExecuteReader();'...

Unclosed quotation mark after the character string '101'.
Incorrect syntax near '101'.