A Newbie from Access 2000

[TheRealDeal]

I am stepping into VB .Net 2003 for the first time and want to start-off in the right direction. What is the best/appropriate procedure to connect to my Access 2000 databases and how would I step into to learning these procedures quickly?

 

[RiverGuy]

You may want to get a book on ADO.Net. ADO.Net is much different than ADO or DAO--and you're going to want to understand a good chunk of it before starting it at all. Also do some searches at MSDN.Microsoft.com.

As a quick overview, be aware of the fact that all your data access will be segmented into specific objects. For example, you make an OleDBConnection Object to connect to the database--you can't use a string to pass into a recordset's Open method to implicitly make a connection like VB 6.

You will need OleDBCommands to execute any sql against the database--no RecordSet.Open functions.

Speaking of Recordsets--they do not exist in ADO.Net. You will use an OleDBDataAdapter to fill up DataSets which are collections of DataTables, or using a forward only DataReader.

I hope that helps.

 

[chrissie1]

and lets not forget that ado.net is disconnected unlike ado. Wich means that data are copied to the client and then when updated recopied to the database.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]