Datagrid or MSFLexGrid or something else

[tfstom]

I need to get data from a couple of tables (using sql join) that will give
me a list of columns.

I will be using the data as a lookup table to get pieces of data as I
process my screen. The data won't be visible on the screen. But I will be
using an employee number to get the persons data, such as city or dollars
spent.

It will be a look up table with multiple columns.

I assume a grid would be the best bet. I don't want to hit the database for
each employee. I want to get the employees I will be needing all at once
(probably about 200 at one crack). I then will need to search through the
grid to get each employee (which will probably not be in any order - I may
hit the same employee multiple times).

If the grid is the best way, then which would be better the data grid or the
MSFLexGrid.

Thanks,

Tom.

 

[northrd]

checkout sgrid2 on vbaccelerator. Nice, easy to use and should do the trick.

Cheers