From access db (*.accdb) i retrieve 4 column of result set & store 1 column in list box. I have 3 labels.When i select a single row from list box, i want to get another 3 data which are comes with result set and try to put it in the specific label. How i will do it?
Please help me.
Thank you in advance!
Loading
Madhu KPosted Feb 7, 2011, 12:29 AM
You can do this on ListBox SelectedIndexChanged event.
//select * from table where listitemcolumn='ListBoxItem'
The above query returns all the rows for that listitem.
Use a datareader to get the values and display in the labels.