Onchange of dropdownlist say "country" loaded,it must load all "states" for that country in another drop downlist.

[S.Guhananth]

I need to capture a country from dropdown list and use that in sql query.

How to do this

protected DataSet GetCountry()
{

I have the code for this block

}

From http://www.developmentnow.com/g/8_20...ork-aspnet.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

[Alvin Bruney [Microsoft MVP]]

handle the selectionchange event and fire your query using the selected item
as part of your where clause if you are going against a database. if the
data is in a dataset, use a filter made up of the selecteditem

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------
"S.Guhananth" <gu*********@hotmail.com> wrote in message
news:a1**********************************@msnews.m icrosoft.com...

I need to capture a country from dropdown list and use that in sql query.

How to do this

protected DataSet GetCountry()
{

I have the code for this block

}

From
http://www.developmentnow.com/g/8_20...ork-aspnet.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com