What is the best data "grid" type component to use? My users need to edit, insert and delete records. I am using ADO recordsets pulled from a mySQL data base. It is a hard requirement that I rearrange the order of the columns\fields. When the user sees the grid, the columns need to be in the specified order, which is NOT the same as the field order of the underlying table.

I have tried a datagrid and made some of the columns invisible, but don't know how to rearrange the remaining columns. I'm trying MSFlexGrid now, but don't think I can rearrange columns in it either.

HELP!

Thank you.
John