Custom Tables

delstar

Well-known member
Joined
Jun 9, 2006
Messages
59
Programming Experience
1-3
I'm working on a project to view data in a particular database we have (the database's associated software has a disorganized UI). One of the features in the db software package is that it allows for a large amount of customization. Everything from custom fields to custom tables. I have the custom field display working in my project, but the custom tables are creating a problem.

The data looks like this in the table:
ASIT.png

I pull that out and place each row into a custom object (which is contained in a list) with the following definition:
VB.NET:
Public Class ASITCell
    Property ASITName As String
    Property RowNum As Integer
    Property Label As String
    Property Value As String
End Class

I'm trying to figure out how to display that data like this in multiple dgv's (depending on the values in ASITCell.ASITName):

ASIT2.png

Considering that these are custom tables, I need to generate the dgv's in code. Assume that I do not know beforehand what the table names or column names are going to be, nor how many of them there are (there can be multiple tables per RecordID).


Any ideas? I am not locked into my ASITCell data structure, so if that needs to change for this to work let me know.
 
Back
Top