VB6 to VB.Net

[shakizil]

I am new to VB.Net and I having some difficulty with the new codes. I wrote the following code in VB6 and trying to implement the same technique in VB.Net. autosql = "select * from orders" Set myorder = mydb.OpenRecordset(autosql, dbOpenDynaset) If myorder.EOF Then x = 1 Else myorder.MoveLast x = myorder!autono + 1 End If addordstring = "insert into orders values(" & x & ",'" & mebdate & "','" & txtaccount & "','" & phone & "','" & coname & "','" & psgname & "','" & cabno & "','" & authname & "','" & driver & "','" & mebpick & "','" & wait & "','" & mebdrop & "','" & from & "','" & txtto & "','" & fare & "')" Set addorder = mydb.CreateQueryDef("", addordstring) addorder.Execute MsgBox "New entry has been added", vbOKOnly + vbExclamation, "Success" clear End Sub Can someone help please. Thanks.

[Kevin McFarlane]

Have a look at the ADO.NET examples here http://samples.gotdotnet.com/quickstart/howto/[^] Kevin