Good day!

I have this datasets format in sql server!

AccountID   AccountName    1/30/2013  2/30/2013  3/30/2013
   4        Credit Cards    20,000      30,000     12,000
   5        Loans Payable   5,000       6,000      5,000

How can I load all this data to listview? The colums are dynamic. It could be 6, 7, 8, or 12, or higher. The listview should display all the columns on the dataset dynamically. The column name of the dataset should be the column header name in each column in the listview.

Thank you for helping!

Edited 3 Years Ago by blocker

I have this solution and it seems its working!

dim rsheaders as new adodb.recordset
dim counter as integer
dim rsfields as field

for each rsfields in rsheaders
   msgbox   'get the header name

'loading dynamic data. This can be applied to any datagrid. Just modify the code
while not rsheaders.eof
  for counter=0 to rpt.columns.count - 1 'the columncount of the datagrid or any grid you used
      fielddata.value=rsheaders.fields(counter).value   'getting data, wahtever format applicable to your datagrid

Thank you!

Edited 3 Years Ago by blocker

This question has already been answered. Start a new discussion instead.