Best way to do it

[Kiran]

Hi Guys,

I have three textboxes which I use for filling text, value and link. And I have an Add button in the same form which will add these values to a table in DB and I then bind a listbox to this table.

so every time you add an entry, the items in listbox increases.

when an item in listbox is selected, I would like to fill the three textboxes: text, value and link.

I have value and text in the listbox itself but I don't have the link. My doubt is Do I have to make a call to DB everytime an item of listbox is selected. Is this the only way to do it.

Any help on this would be appreciated

Thanks
Kiran

[Eliyahu Goldin]

Kiran,

Make a hidden listbox with the same text as the first one but use the link as a value. When you select an item in your text-value listbox, select an item with the same index in the text-link listbox and get the link from there.

Eliyahu

"Kiran" <ki**********@gmail.com> wrote in message news:u0*****************@TK2MSFTNGP12.phx.gbl...
Hi Guys,

I have three textboxes which I use for filling text, value and link. And I have an Add button in the same form which will add these values to a table in DB and I then bind a listbox to this table.

so every time you add an entry, the items in listbox increases.

when an item in listbox is selected, I would like to fill the three textboxes: text, value and link.

I have value and text in the listbox itself but I don't have the link. My doubt is Do I have to make a call to DB everytime an item of listbox is selected. Is this the only way to do it.

Any help on this would be appreciated

Thanks
Kiran

[Kiran]

Thanks a lot
"Eliyahu Goldin" <re*************@monarchmed.com> wrote in message news:uj**************@TK2MSFTNGP14.phx.gbl...
Kiran,

Make a hidden listbox with the same text as the first one but use the link as a value. When you select an item in your text-value listbox, select an item with the same index in the text-link listbox and get the link from there.

Eliyahu

"Kiran" <ki**********@gmail.com> wrote in message news:u0*****************@TK2MSFTNGP12.phx.gbl...
Hi Guys,

I have three textboxes which I use for filling text, value and link. And I have an Add button in the same form which will add these values to a table in DB and I then bind a listbox to this table.

so every time you add an entry, the items in listbox increases.

when an item in listbox is selected, I would like to fill the three textboxes: text, value and link.

I have value and text in the listbox itself but I don't have the link. My doubt is Do I have to make a call to DB everytime an item of listbox is selected. Is this the only way to do it.

Any help on this would be appreciated

Thanks
Kiran