«

Hi.

Say a the query behind a dropdown list lists various fields -- i.e.,
ID, State, City. The dropdownlist will display the state and store
the ID. How do I retrieve the associated city?

Thanks!

Cindy

Your query will result in populating some object (data source) with data
and the ddl will databind to that object. You will need to persist the data
source between postbacks. You can do it in a session variable. Or you may
choose running the query on every postback to re-populate the data source.
Once you know the selected id, you can search your data source to locate the
data item and get the city from the data item.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


"Cindy" <> wrote in message
news: oups.com...
> Hi.
>
> Say a the query behind a dropdown list lists various fields -- i.e.,
> ID, State, City. The dropdownlist will display the state and store
> the ID. How do I retrieve the associated city?
>
> Thanks!
>
> Cindy
>

"Cindy" <> wrote in message
news: oups.com...

> Say a the query behind a dropdown list lists various fields -- i.e.,
> ID, State, City. The dropdownlist will display the state and store
> the ID. How do I retrieve the associated city?

Several ways...

1) Unless your DataSet is quite large, you can store it in a client-side
JavaScript array - this would allow you to retrieve the associated city
client-side without any postback / callback...

2) Concatenate the ID and city with a separator charactor and use that as
the value of the dropdown e.g.

1¬London
2¬Paris
3¬New York

Then, when you need to, you can simply split the value on your character
separator e.g.

MyDropDown.SelectedValue.Split('¬')[1];

3) Use AJAX to either look the data up from the database as and when
required or, (maybe) more efficiently, persist the data in Session or
Application cache if it's unlikely to change very often...

I'd go for the third option, personally...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Hey. Do you have an example of this? All I wanted was to be able to
say, whatever=dropdownlist.column(2) and it returns the information.
Simple. I do not have enough experience to understand everything you
just wrote.

Thanks!

Cindy

On Aug 29, 10:49 am, "Eliyahu Goldin"
<REMOVEALLCAPITALSeEgGoldD...@mMvVpPsS.org> wrote:
> Your query will result in populating some object (data source) with data
> and the ddl will databind to that object. You will need to persist the data
> source between postbacks. You can do it in a session variable. Or you may
> choose running the query on every postback to re-populate the data source.
> Once you know the selected id, you can search your data source to locate the
> data item and get the city from the data item.
>
> --
> Eliyahu Goldin,
> Software Developer
> Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net
>
> "Cindy" <cindyc...@hotmail.com> wrote in message
>
> news: oups.com...
>
>
>
> > Hi.
>
> > Say a the query behind a dropdown list lists various fields -- i.e.,
> > ID, State, City. The dropdownlist will display the state and store
> > the ID. How do I retrieve the associated city?
>
> > Thanks!
>
> > Cindy- Hide quoted text -
>
> - Show quoted text -

On Aug 29, 10:19 am, Cindy <cindyc...@hotmail.com> wrote:
> Hi.
>
> Say a the query behind a dropdown list lists various fields -- i.e.,
> ID, State, City. The dropdownlist will display the state and store
> the ID. How do I retrieve the associated city?
>
> Thanks!
>
> Cindy

string stateid = StateList.SelectedItem.Value;
string sql = "SELECT cityid, city FROM cities WHERE stateid='" +
stateid + "'";

On Aug 29, 10:53 am, "Mark Rae [MVP]" <m...@markNOSPAMrae.net> wrote:
> "Cindy" <cindyc...@hotmail.com> wrote in message
>
> news: oups.com...
>
> > Say a the query behind a dropdown list lists various fields -- i.e.,
> > ID, State, City. The dropdownlist will display the state and store
> > the ID. How do I retrieve the associated city?
>
> Several ways...
>
> 1) Unless your DataSet is quite large, you can store it in a client-side
> JavaScript array - this would allow you to retrieve the associated city
> client-side without any postback / callback...
>
> 2) Concatenate the ID and city with a separator charactor and use that as
> the value of the dropdown e.g.
>
> 1¬London
> 2¬Paris
> 3¬New York
>
> Then, when you need to, you can simply split the value on your character
> separator e.g.
>
> MyDropDown.SelectedValue.Split('¬')[1];
>
> 3) Use AJAX to either look the data up from the database as and when
> required or, (maybe) more efficiently, persist the data in Session or
> Application cache if it's unlikely to change very often...
>
> I'd go for the third option, personally...
>
> --
> Mark Rae
> ASP.NET MVPhttp://www.markrae.net

Thanks! The splitting ought to do it!