how to populate two dropdown list?when i select state city is automatically filled.

[rachna gandhi]

i have use this code when i select state city is automatically filled in 2nd dropdown according to the value of 1st dropdown.but it is not working.

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int countryid;
        countryid = DropDownList1.SelectedIndex;
        string cmdtxt = "select cid , [city_name] from city where sid=" + DropDownList1.SelectedIndex;
        SqlDataAdapter da1 = new SqlDataAdapter(cmdtxt, connection.conn);
        DataSet ds1 = new DataSet();
        da1.Fill(ds1, "city");
        ddlcity.DataSource = ds1.Tables["city"];
        ddlcity.DataTextField = "statename";
        ddlcity.DataValueField = "stateid";
        ddlcity.DataBind();
    }

[PsychoCoder]

Before we go any further can you let us know what is going wrong, just saying it doesn't work isn't very helpful :)

[rachna gandhi]

it gives error like
Incorrect syntax near ','.

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 ','.

[MrMancunian]

What happens if you put a breakpoint on

DataSet ds1 = new DataSet();

and evaluate cmdtxt on the line above it. Check if your query is correct. If you're not sure, paste it in your SQL Management Studio and see if it executes without a problem.