[RESOLVED] listview v datagrid v flexgrid

i am trying to display data from a database stored in various tables in my form

i have managed to use the listview control to dynamically add the correct number of columns, rows etc and populate them with the correct data

i have now heard about the datagrid and flexgrid controls and i was wondering what the differences were and which is the best to use?

i would like to have as much functionality as possible so that i could format the data, export it, sort it etc

any links or comments would be most appreciated

I have always used DataGrid. All you need is a recordset to populate it.
You can update, delete, add new records etc.
Also with the recordset you can export you data to EXCEL for instance.

Dim rs as new adodb.recordset
rs.cursorlocation=ADUSECLIENT 'it is important, without it you won't have the
'records in the grid
rs.OPEN SQL,connection,....
set DataGrid.DataSource = rs.DataSource
AND THAT's it.
Look at the properties of the DATAGRID for formatting, alignment of the cells ...
GOOD LUCK!

thanks for the advice, i managed to find an article about the different controls and i've decided to use flexgrid because i don't need the user to be able to change the data

You can of cource uncheck the boxes "UPDATE"
"DELETE", "ADD" and again use the datagrid in future;)