Help with ADO.net 2.0 ....

[_vfc]

I use to Program with Visual Basic 6.0 + DAO 3.6 + Access, now, I have to migrate to : Visual Basic 2005 + ADO.net 2.0 + Access, and I'm having some problems :

I already know how to make a conection string, to conect to the database, and execute sql commands (select, insertinto, update ....), but I don't know how to show the data !

I mean, how do I put the data in the text boxes ?
How do I go to a specific row using a criteria ?
How do I check if there is a specific value in column ?
Is sql commands the only way to manipulate the data base ?

Thank you very much for your help guys !
sorry for the bad english ...

[jmcilhinney]

You will normally retrieve your data into a DataTable, then you have all sorts of options. The DataTable has a Select method, it's Rows collection has a Find method, its DefaultView property has RowFilter, RowStateFilter and Sort properties and a Find method. You can bind a DataTable to controls either directly or, preferably in 2005, via a BindingSource object. I suggest that you read about the BindingSource class and its members, as that's the key to data display and manipulation in VB 2005.