Showing posts with label recordset. Show all posts
Showing posts with label recordset. Show all posts

Monday, March 19, 2012

Help needed with method for SQL

I have been using VB6 for a long time now and had no problems using ADODB.Recordset.

I had a module to which I would send my recordset (byref) and the SQL command (byval) and use the resultant recordset for adding, modifying or deleting records.

How can I do the same with VS2005? This is a major problem as there are dataadapters, grids, datareaders etc.

Does someone have a simple method to get the recordset so that I can modify the record using the code (eg: .Addnew/.Delete/.Update) and Close the connection?

Please note that I do not need to display anything and have to run 40/50 AddModDel for every click of the program.

Any help is greately appreciated. Thanks in Advance.:: Bump ::
Is there a solution?