I'm writing a basic VB 2008 application to report data from my SQL server. The requested layout needs to look similar to outlook - I have a DataGridView on the left to display "Message Titles" and on the right I have a large texbox. I would like to have the textbox display the results of a query (18 fields) one on top of the other. ie. if the query is:
SELECT MR_ID, MR_RequestorName, MR_ItemNum, MR_Description,
MR_Quantity, MR_UM ,MR_Location, MR_Priority, MR_AreaType, MR_AreaSide, MR_ItemNum2, MR_Description2, MR_Quantity2, MR_UM2, MR_ItemNum3,
MR_Description3, MR_Quantity3, MR_UM3, MR_TimeStamp
WHERE MR_ID = (I haven't finished this part yet - waiting for the result of this question)
Can I display the results in the textbox as:
Any help would be greatly appreciated.