[SQL] How to bind dynamic SQL data to a web page control?

I need help with returning data to a web page in ASP.NET.

To summarize: I have a SQL query that returns a table of data with 20 columns. It does some manipulation within SQL to return only columns that the user has specified, so for example, user may not find some of the data returned useful so I don't want that returned in the front end.

All manipulation happens within SQL so if they don't want a certain 5 columns the script works fine in returning the relevant 15 columns.

My question is how can I get my data binding working on the web page. I've got the code to get the datatable run the script. I want it to show the header of each column and the table of data that's being returned.

Any help would be greatly appreciated or any articles that would be useful for me to read.

Thanks Rob

Continue reading...