Hi i have written an Dll for a project that takes care of all the database activity. I open the connection in the Class Initialize and use the same connection object for all methods in the DLL.
Some of the methods return a disconnected recordset and some of the methods should just return True or false. Now to the problem I can´t get the hang of how I check that the Boolen set if I for example deletes a record. I have tried to use withevents on the connection object but I cant get it to work. If I have 3 methods accessing a equipment table in the db.
1 . InsertEQ
2. UpdateEQ
3 . DeleteEQ

All the actions should return booleans but the ExecuteCompleted method just checks the connection object not the individual methods, it would be good to have som error handeling also.
Any ideas on how to do this..?

/Henrik