VS 2005 / VB.Net
Simple Insert Query.
Using Execute Non Query -
I am not able to insert a simple query.
Table has only two columns ( StatesId which is AutoNumber and StateShortName which is Text DataType ).
Dim myOleCommand As OleDbCommand
Dim myConn As New OleDbConnection("C:\Enrollment Form\EnrollmentApp\EnrollmentApp\EnrollmentDB.mdb")
Dim strCommand As String
strCommand = "Insert into tmpStates (StateShortName) values('Chokka')"
myOleCommand = New OleDbCommand(strCommand, myConn)