I'm not sure why you're doing an update call in the dal_search method, at that point you're just populating data and returning a dataset....it should probably read...
public DataSet dal_search(stdprops p)
{
DataSet searchResults = new DataSet();
string query = "SELECT * FROM info";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
using (OleDbCommand command = New OleDbCommand(query, connection))
{
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
adapter.Fill(searchResults);
return searchResults;
}
}
}
}
You only need to use the command builder object if you were going to modify the data and commit the results within the same procedure, have a look here
http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspx[
^]
If you're just returning data from the method, you don't need this