Hi there, been coding in VB for ages, and just moving over to .net. Thing i ive always coded using random access files to save data, yeah i know realy bad way to code. Id like to move across to using DB and have done for a long time but have never been able to find what i want. Maybe if i tell you what i would like to do someone could advise me on the best way to go about this or where to look for more details.

I basically would like to be able to use a db in a similar way to datafiles, therefore read from the database and load the details into varibles so i can play about with them before displaying them. I guess this is to be done using a record set. I would idealy like to be able to query the DB and make changes to it using SQL and use SQL for inserting and editing data as well. Is this possible or am i totally barking up the wrong tree. Hope someone can help me out or advise me what route to take. Most tutorials ive found seem to be all based on databinding, and im not a great fan of that at all. There must be better ways!!!

Regards

JP