I have a similar difficulty. I learnt VB 6 in school where data handling was very easy with the recordset. However, i have decided to do my coursework in vb 2008, but they aren't teaching it, so i must figure out how to handle data in vb 2008.
I got this connection string from connectionstrings.com, and tried to write some commands of my own. Btw, i'm trying to link to a database in the access 2003 format, with a table called classes.
Is this method for connecting correct? is there any method simpler than sql, as my project is very basic and it would help if i didnt have to write such complex programming. And plus, how do i navigate records? like in vb 6 it would be something like booksdat.recordset.next....
CODE
Dim myConnection As SqlConnection
Dim insert As SqlCommand
Dim delete As SqlCommand
myConnection = New SqlConnection(Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\vb08sbs\chap18\students.mdb;Persist Security Info=False;)
insert = New SqlCommand("INSERT INTO Classes (Class Name, Department, Prof, Section Number, Term, Units, Year, Location, Days/Times) values ('Test Class', 'Computer Science', 'Satra, Neil', 3, 'Fall', 98, 102, 'MWF 8:00')", myConnection)
delete = New SqlCommand("DELETE FROM Classes WHERE Class Name = 'Test Class'", myConnection)
| 