I need code to navigate data without using Vb6 Adodb.recordset

I have used for navigation code. But It takes a long time.

I can't used stored procedure because my condition changes...

I need code to navigate data without using Vb6 Adodb.recordset

I have used for navigation code. But It takes a long time.

what is SP. (You can do all your insert/update/delete/Select...