Could someone please help me learn how to build the following app. I need a Grid that displays information from a query. I then want to have a series of checkboxes that determines the columns that are shown in the grid.

I have been trying this for the past two days, and I can't get it to work. I have the connection, and I can populate the grid just fine. I just don't know how to make the checkboxes change the sql query to display just the items checked.

Thanks in advance.

Is this is rigid query? (Are you building something that hopes to work with any sql query or a specific one?)

Instead of trying to manipulate the sql query, it would probably be easier to manipulate the grid. After you bind the grid, you could modify the column settings in the grid to turn on/off the columns according to the checkbox states.

-Peter

How would one go about doing that? haha

Go thru the grid's Columns collection and set each column's properties according to whatever tests you make against the checkboxes.

-Peter

Hope this helps..

http://ganeshprof.blogspot.com/2005/...s-in-grid.html

Regards
Ganesh