Help please with moving from ADO to ADO.NET...

[Bum_Holo]

Afternoon all,

I am new to VB.NET and I need to add, edit and delete records from an access database. In VB6 I used the connection and recordset objects but now that I'm using VB.NET I'm not sure what to use now that there is an oledbconnection, oledbadapter, oledbreader objects etc...

Can anyone tell me which I should use. I am redeveloping my application under VB.NET from the previouse VB6 version so all this is very confussing.

Thanks in advance,

B.

[Andy Tacker]

I recommend you to carefully see

system.data.sqlclient namespace for SQL
system.data.oledb namespace for anyother db.

you will find all the required classes to work with databases there.

luck!

[kristine2002]

Can be more specific on how to update, delete and add?

I have a datagrid in my form but i cant transfer the changes i made from datagrid to SQL table.

Can anyone, show me an example? I tried using dataadapter.update method but no luck.


Thanks,