Hide Columns in Query Result based on Text Box Value

[deepanadhi]

Hi All,



As a Result of a query i ll get around 15 columns in the output.
Out of which I need to display First 5 columnns all the time & The One among the rest 10 columns depending upon the value entered in the Text box.

The connection is pretty simple.
If "1" is entered in the text box and Button is pressed, First 5 columns should be dislayed and the 6th Column shud be displayed, and rest should be hidden from the view.
If "2" is entered in the text box and Button is pressed, First 5 columns should be dislayed and the 7th Column shud be displayed, and rest should be hidden from the view.

and so on
If "10" is entered in the text box and Button is pressed, First 5 columns should be dislayed and the 15th Column shud be displayed , and rest should be hidden from the view.

Need help in VB coding to acheive this,
Thanks in advance...


- Deepan

[Robeen]

I don't know if this is the most elegant way to do this, but in the On Click Event, you could use a Case Statement and then for each possible selection in the Text Box - create the appropriate SQL string.

Where are you displaying this data?