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

 

[MLK]

Hi arcanist, Have you considered using data-bound classes to solve this problem. You can make your DB access class a data source and your middle-tier a data consumer. You can then directly bind your grids to the approiate data member in your data source.


Good Luck MLK