Matt Matt - 9 days ago 6
Vb.net Question

How to add specific SQL result values to specific cells in a HTML table in Visual Studio 2012

I have a series of totals in a resultset see below:

SQL Results

What I would like to do is populate these results in a HTML table, but specific results need to go into specific cells ie split across different columns and different rows eg:

Tables of Results

Is there a Visual Studio control I can use for this or should I set up a html table with multiple data sources connecting to the database and then split up my query?

Answer

Thanks for the mock, I was wondering how the cell is determined, I didnt explain that well at all! From what you have shown so far I can't think of a control other than a table that will hold that. If there is a set logic behind which cell is used for each value it may be worth doing a custom control.

Good luck with it, Cheers