private void cmdSimpleOleSearch_Click(object sender, EventArgs e)
{
var ops = new OledbCode.Operations();
var fileName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Customers.xlsx");
var(Table, Success) = ops.ReaDataTable(fileName, "Sales Representative");
if (Success)
{
if (Table.Rows.Count > 0)
{
MessageBox.Show("Done");
}
else
{
MessageBox.Show("Done, nothing for search");
}
}
else
{
MessageBox.Show($"Encountered an issue: {ops.LastExceptionMessage}");
}
}
