how to parse unknown data into array
Posted on 2006-04-17
I need to allow a user to execute a sql statement such as
"SELECT FirstName, LastName, Company from ContactTable"
The SQL Statement is passed to a 3rd Party application via an API call. I do not have direct acess to the data (can't use ADO or ODBC, etc.).
The data is then returned to me in a buffer as a string with fields delimited by "|" and records deliimited by CRLF
I can use Split to parse the buffer and put the data into a user-defined type.
The challenge is, the user can "SELECT" from many different fields. I will not know which fields they are going to be picking. So I am trying to figure out how to dynamically store the data in such a way that it could be displayed in a grid control.
Keep in mind, non of this can happen with data-bound controls. It all has to happen in memory with arrays and UDT's.
Also, it does not have to happen in VB. If C++ or a .NET language would be more appropriate, then I could do that also.