I have the code below. But I dont know how to get the info out.
Lets say I find the thing I was searching for.....how can I get it out? And will the return value be null if it doesnt exist?
Boolean flag = false;
String myConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\Documents and Settings\\MFL\\Dokumenter\\Visual Studio 2005\\WebSites\\WebSite\\WebSite\\Tenta1\\Nwind.mdb";
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
string myInsertQuery = "SELECT * FROM Customers WHERE (CustomerID) ='" + SearchTextBox.Text + "'";
OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
myCommand.Connection = myConnection;