Drop down control.

[dan sh]

Are you hitting database everytime country selection is changed? That will slow things down. Unless you show some code about how you are doing this, it would be tough to help.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[0x3c0]

Which code is populating the dropdown boxes? What part of the code is slow? If you're searching through a database, have you used the WHERE clause, or are you just iterating over the results when the list is populated?

OSDev :)

[0x3c0]

Just beat me to it :-D

OSDev :)

[dan sh]

This has happenned with me a few times earlier as well. Fortunately, I was lucky enough to come out as a winner every single time. :)

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Sasmi_Office]

thanks for your quick response me using following query to fill dropdown "select CountryName, CountryID from CountryTable" "select CityName, CityID from CityDetails where CountryID = 1" "select LocationName, LocationID from LocationDetails wherer CityID = 1" this way the data has been retrive from database but before that i want to clearify at page Load it initialize each control DropDown1.Items.Clear() ListItem _Item = new ListItem("-Select Country-",0) DropDown1.Items.Insert(_Item, 0) DropDown2.Items.Clear() ListItem _Item = new ListItem("-Select City-",0) DropDown2.Items.Insert(_Item, 0) DropDown3.Items.Clear() ListItem _Item = new ListItem("-Select Location-",0) DropDown3.Items.Insert(_Item, 0) when i change selection of Country drop down again DropDown2.Items.Clear() ListItem _Item = new ListItem("-Select City-",0) DropDown2.Items.Insert(_Item, 0) DropDown3.Items.Clear() ListItem _Item = new ListItem("-Select Location-",0) DropDown3.Items.Insert(_Item, 0) this way its coded.. hope you get what i coded on my form sasmi

[Sasmi_Office]

thanks for your quick response me using following query to fill dropdown "select CountryName, CountryID from CountryTable" "select CityName, CityID from CityDetails where CountryID = 1" "select LocationName, LocationID from LocationDetails wherer CityID = 1" this way the data has been retrive from database but before that i want to clearify at page Load it initialize each control DropDown1.Items.Clear() ListItem _Item = new ListItem("-Select Country-",0) DropDown1.Items.Insert(_Item, 0) DropDown2.Items.Clear() ListItem _Item = new ListItem("-Select City-",0) DropDown2.Items.Insert(_Item, 0) DropDown3.Items.Clear() ListItem _Item = new ListItem("-Select Location-",0) DropDown3.Items.Insert(_Item, 0) when i change selection of Country drop down again DropDown2.Items.Clear() ListItem _Item = new ListItem("-Select City-",0) DropDown2.Items.Insert(_Item, 0) DropDown3.Items.Clear() ListItem _Item = new ListItem("-Select Location-",0) DropDown3.Items.Insert(_Item, 0) this way its coded.. sasmi

[Lost User]

It seems you are hitting the database everytime a country or city is changed, that's why it is so slow. Load your lists in a JavaScript array and rewrite your logic using JavaScript.

[Nguyen Thanh Quyen]

Check valid field when pass to Controls

Công ty Đất Quảng - Cong ty Dat Quang - http://datquangda.com.vn Bất động sản, mua bán nhà đất khu đô thị mới Nam An Khánh Hà Nội. Trụ sở: Phòng 303 nhà N6E – Trung Hoà Nhân Chính – Thanh Xuân – Hà Nội - Vietnam Văn phòng giao dịch: Số nhà 10, ngách 23, ngõ 61, Trần Duy Hưng, Trung Hòa, Cầu Giấy, Hà Nội, Vietnam Điện thoai: 04.3556 2516 - 3556 2552 - 2247 5733 Fax: 04.3556 2566 - 3556 2140 Email:datquangda@gmail.com Website: http://www.datquangda.com.vn

[dan sh]

:confused:

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[dan sh]

You seem to hitting database all the time. Get the list in one go and cache it. Then, all you need is to filter the datasource for second and third dropdowns. BTW give your controls a descriptive name.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!