Need urgent help with datagrid display

Joined
Feb 10, 2010
Messages
1
Reaction score
0
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
 

Attachments

  • sql_dataset.GIF
    sql_dataset.GIF
    8.8 KB · Views: 301
  • results_I_want.GIF
    results_I_want.GIF
    5.7 KB · Views: 255

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,432
Messages
2,571,681
Members
48,796
Latest member
Greg L.

Latest Threads

Top