Vb to vb.net

[Mage]

Can any one help me out I have been programming in vb but have now started to move over to vb.net have some problems

in vb if you wanted to execute a sql statement it was easy one line.... connection.execute "Insert Into...."

how do i just do something simple like this in .net?????

... using Access for the mo

thanks

[ayan]

like this?

Dim cn As New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" & Application.StartupPath & "\northwind.mdb")
        cn.Open()
        Dim cmdText = "insert into territories values('yo','mage',1)"
        Dim cm As OleDb.OleDbCommand = New OleDb.OleDbCommand(cmdText, cn)
        cm.ExecuteNonQuery()

if not, sorry...

[Mage]

I keep getting a "Operation must use an updateable query."

[ayan]

i don't know about the previous vb, sorry. but this might help