devxlogo

ADO Disconnected Recordsets

ADO Disconnected Recordsets

Question:
I am designing a three tier architecture framework. For passing data from one tier to another, I am using ADO disconnected recordsets. For Reading, Updation and Deletion, I create recordsets at the data layer, pass them to the presentation(user layer) and with the update batch method, I get the functionality.

But for Adding a new record, I have to roundtrip. Data -> Business -> User-> Add the record-> Business -> Data. Is there any way to create recordset at the user layer?

Answer:
You can programmatically create a recordset by instantiating a new recordset and appending fields to the Fields collection. After you’ve added the fields, open it, and add records. You can then pass it to the middle tier and process it there.

See also  5 Tips for Choosing the Right Medical Software for Your Practice
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist