Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP .Net (http://www.velocityreviews.com/forums/f29-asp-net.html)
-   -   Need urgent help with datagrid display (http://www.velocityreviews.com/forums/t714489-need-urgent-help-with-datagrid-display.html)

joelmortin 02-10-2010 05:21 AM

Need urgent help with datagrid display
 
2 Attachment(s)
I have a stored proc that return the data in the attached image called sql_dataset.GIF

The proc name is called "sp_getReport"

Results I'd like to have is a screen shot @ "results_I_want.GIF"
Here's the markup
Code:

<table width="450" border="1">
                <tr>
                    <td></td>
                    <td></td>
                    <td bgcolor="Gray">Tru_Name A</td>                 
                </tr>
                <tr>
                    <td bgcolor="Gray">Cust_Name A</td>
                    <td>Low</td>
                    <td bgcolor="Gray">LowPrice A</td>             
                </tr>
                <tr>
                    <td></td>
                    <td>High </td>
                    <td bgcolor="Gray">HighPrice A</td>             
                </tr>         
          </table>

Bascially I'd like to display information by Cust_Name (row) with LowPrice and HighPrice by Tru_Name (columns)

Each Cust_Name row with LowPrice and HighPrice must loop
The same is true for Tru_Name

Please provide guidance on how to accomplish this in vb

Thank you very much for your help in advance.

Joel


All times are GMT. The time now is 01:41 AM.

Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.