Search in Microsoft Access database
-
I have connected my application with the Microsoft Access database, via ADO.NET OLEDB. I can insert and edit data, but I have no idea how to search the database, or just to select some record and to insert that into some string. Here is a example for inserting a new record
String ^strData = "INSERT INTO Continents VALUES('Abcd',12345678,87654321);"; OleDbCommand ^cmdDatabase=gcnew OleDbCommand(strData, oleDbConnection1); cmdDatabase->ExecuteNonQuery();Please help. -
I have connected my application with the Microsoft Access database, via ADO.NET OLEDB. I can insert and edit data, but I have no idea how to search the database, or just to select some record and to insert that into some string. Here is a example for inserting a new record
String ^strData = "INSERT INTO Continents VALUES('Abcd',12345678,87654321);"; OleDbCommand ^cmdDatabase=gcnew OleDbCommand(strData, oleDbConnection1); cmdDatabase->ExecuteNonQuery();Please help.