public void GetSearchResults()
{
const string sqlFormat = "SELECT * FROM BoxDetails WHERE ClientName LIKE '%{0}%' AND ClientNumber LIKE '%{1}%' AND ClientLeader LIKE '%{2}%'";
string sql = string.Format(sqlFormat,
GetFieldValue(view.ClientName),
GetFieldValue(view.ClientNumber),
GetFieldValue(view.ClientPrincipal));
view.searchResults = dataAccess.FillDataSet(sql, CommandType.Text);
}