ADO and Grids on a 3-tier architechture. 1

[RACaluste]

I have a question, and this is the scenario,

I am a beginner to using a 3-tier arch programming using classes.

I am trying to load a recordset to a grid, (i've tried both flexi and dbgrids). however, i don't want to use an ADO control. All the data access should be away from my user interface layer, and might be a return from a class from the business logic layer from a call to the data access layer.

from my ui layer, i make a method call from my Employee class which processes my request and retrives the data from my SQL server.

set rs = Employee.GetChildren

so the question is, how to i put the value of the rs (my recordset) to a grid?

i am really stumped, and i am already thinking of dynamically adding a textbox for every record found.

thanks in advance!

arcanist

 

[NickISD]

Hi Arcanist,
Have a look at Janus grid control, it's much faster to load then standard MS grid and is more flexible too. You can pass your ADO recordset to it by doing one SET statement.

You could loop your recordset and manually load it in code, just increment row counter and set the col position to add each row. This would be slow to load though.

Hope this helps.

Nick W

 

[RACaluste]

Thanks, I searched the net and found articles on data classes and consumers. i will also take a look at the janus grid control.

arcanist

 

[dilettante]

Sounds like you need to disconnect the recordset and return it to your client. This of course means your client needs to use ADO, but doesn't need to talk directly to the database.