1. Look up INFORMATION.SCHEMA in the Sql Server manual (known as books online) Assuming your database is Sql server, that will help you get a dataset of columns.

2. Use the dataset of columns as the DataSource of a ListBox WebControl, set MultiSelect property to true.

3. Concatenatet the users selections in the ListBox control into a SQL statement.

4. Use ADO.NET to execute the SQL and return a dataset, pass the the dataset to a datagrid or gridView WebControls' datasource, whos AutoGenerateColumns property is set to true

hi,

thanks for your help.

but i want to generate the reports in dynamic by selecting a set of columns in a table.

is it possible

pl help me on this

thanks in advance
sridhar