Search results for query: *

  • Users: tata
  • Order by date
  1. T

    Adding New Record to access database

    jimcilhinney, Super, now successful. Actually the changing of MessageBox.Show("Data Access Error.") to MessageBox.Show(ex.ToString() assisted very much because it showed me that I misspelt the table I was working with. Please accept my sincere thanks. Tata
  2. T

    Adding New Record to access database

    jimcilhinney, Dim Connection As New OleDb.OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source = C:/candidates.mdb") Dim insertCommand As New OleDb.OleDbCommand("INSERT INTO tblCandidates (CandidateID, Name, Course, Address, CourseID) VALUES ('Maganizo','Monawe','MMT','NNT2','SRT')"...
  3. T

    Adding New Record to access database

    jimcilhinney, Thanks very much for the timely response, you have given me a good direction. I am rather confused with this line in the reply. Dim insertCommand As New OleDbCommand("INSERT INTO Table1 (KeyField, Field1) VALUES ('keyValue', 'value1'), connection) My database name is...
  4. T

    Adding New Record to access database

    Netters, I am confident with vb6. Could anyone give me a step by step on how to add a new record to access database using vb.net. I am able to open and close connection to the database. I have looked at several sites but they are not comprehensive for a .net newbie and are concentrating on...
Back
Top