>Does anyone know of a listing of what controls are bindable to ADO recordsets, and the proper syntax. I know grids are not, and the MSDATA Grid is working just ducky. Using the FOXCOM.dll method rsToCursor() to convert to Recordsets to Fox cursors is SLOOOOOW, it took 12 seconds to convert a recordset of 3000 records, on my Pentium 933 with 256 megs of RAM connected to SQL Server 2000, when the query of 500,000 took less than 1 second. The FOXCOM conversion is slowing the down the whole UI, I can't blame SQL server for this one. I'd like to bind all controls, listboxes, combos, checkboxes directly to ADO. Microsoft in usual fashion has nothing, I've tried Wiki, VFUG, nothing.

Hi John,

It was once recommended to me to use either cursors or ADO, but not both. Conversions are slow and limited. You may have better results. I believe COMCodeBook (www.comcodebook.com) has routines for ADO/Cursor conversions, but I'm not sure if they are usuable outside of the framework. Besides grids, I think all other controls will bind to ADO control sources, but you'll have to get record sources for listboxes and comboboxes another way.

So, what is your situation? Are you being handed an ADO recordset to work with? Or is there some other reason you are using ADO?