I bind my data to say GridView or Datagrid or Repeater and give user the ability to remove columns and save his preference and to show the saved preference when he logs back again. (In nutshell Customizable Grid.) How to go about it? Please throw some light.
Try FastSQLDataSource. It helps when you need faster display of large amounts of MS SQL Server data in your web application using grids, lists and other bound controls.
It supports automatic paging and sorting and performs very quickly on large amounts of data
It can work almost without coding or sometimes with no coding at all.