Data Insertion Updation Deletion in Multiple DBs
I am developing an application in VS.net 2002 or 2003 using VB.net that will have the facility of connecting to Access, SQL Server or MySql depending on criteria.
What will be the best way to connect to DBs?
I am making few generic functions that will return me Connection and Adapter objects of relevant database.
What is the best way to Inert , Update and Delete data? Should I populate Datasets? or should I use Command object for data manipulation?
is something like ds("") = value (old ADO style code) is still in use?
Any code suggestion or link to some example will be ppreciated.
Thanks

