Asp .net : Populate items in dropdown list based on another drop down list

[peerraghu]

hi
i am developing website which is a online shoping
i want to populate two dropdownlist, in which the first dropdownlist should place the list of a paticular product and the next dropdownlist should populate with the models of corresponding product of first dropdownlist1 and the price should be placed on the textbox
please sought out my problem its urgent,my boss kept knife on my throat
thanku in advance

[Shashi Sadasivan]

Hi peerraghu,
Welcome to TSDN.

When you select an item in the drop down list you can opt for an event handler to be triggered.
Use that to populate the other drop down list.

The evnt handler should be called something like Editvaluechanged. (sorry I have been working with Windows application for a bit too long, forgot the ASP .Net stuff)

Do give our regards to your boss :D

[Usha Reddy]

hi
i am developing website which is a online shoping
i want to populate two dropdownlist, in which the first dropdownlist should place the list of a paticular product and the next dropdownlist should populate with the models of corresponding product of first dropdownlist1 and the price should be placed on the textbox
please sought out my problem its urgent,my boss kept knife on my throat
thanku in advance

Hi Raghu,

you can write a query in the SelectedIndexChanged event of the first DropDownList to fill your Second dropdown. I guess this will work.

[peerraghu]

Hi Raghu,

you can write a query in the SelectedIndexChanged event of the first DropDownList to fill your Second dropdown. I guess this will work.

hi usha thanks for your reply but my problem is
if i select a country from dropdownlist1 then it should give all states of selected country in dropdownlist2 and its capital should be placed in the textboxt box..
but i am getting all list of states of all country,if v select one country..

please sought out my problem
thank you in advance

[mzmishra]

Hi Raghu,

I think you are following the steps said by Usha and Shashi.
The only reason I can see to your problem is your select query for the state is wrong.You have probably missed the where clause

[peerraghu]

Hi Raghu,

I think you are following the steps said by Usha and Shashi.
The only reason I can see to your problem is your select query for the state is wrong.You have probably missed the where clause

just explain in detail its urgent

[peerraghu]

Hi Raghu,

I think you are following the steps said by Usha and Shashi.
The only reason I can see to your problem is your select query for the state is wrong.You have probably missed the where clause

hi mishra
just look at my code where i did mistake

  protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
            SqlDataAdapter da = new SqlDataAdapter("select countyr_id,countryname from country_master", con);
            DataSet ds1 = new DataSet();
            da.Fill(ds1, "country_master");
            dd1.DataSource = ds1.Tables["country_master"];
            dd1.DataTextField = "countryname";
            dd1.DataValueField = "countyr_id";
            dd1.DataBind();
        }
     }
 protected void dd1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string countryid;
        countryid = dd1.SelectedValue;
        SqlConnection con = new SqlConnection("user id=sa;password=vubrain;database=raghu;data source=vubrain4");
        SqlDataAdapter da1 = new SqlDataAdapter("SELECT StateID,StateName FROM tblSate_Master S INNER JOIN tblStateCountryRelation SC ON S.StateID=SC.StateId WHERE CountryId='" & countryid & "'");
        DataSet ds1 = new DataSet();
        da1.Fill(ds1, "countrystate");
        dd2.DataSource = ds1.Tables["countrystate"];
        dd2.DataTextField = "statename";
        dd2.DataValueField = "stateid";
        dd2.DataBind();
 
 
    }

it showing two error report

1.
The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapt er

2. cannot convert from 'string' to 'System.Data.SqlClient.SqlCommand'

please sought out my mistake

thank you