جستجو در فایل اکسل با ADO.NET

private DataSet _ds;
private DataTable _tb;
private BindingSource _bs;

public Form1()
InitializeComponent();
{
}
private void Form1Load(object sender, EventArgs e)

{
_ds = new DataSet();
_tb = new DataTable();
var myConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=yes");
_bs = new BindingSource();

_ds.Tables.Add(_tb);
var myCommand = new OleDbDataAdapter("SELECT * FROM [Foglio1$]", myConnection);
myCommand.Fill(_tb);
if (ReferenceEquals(sender, txtName))
_bs.DataSource = _ds.Tables[0];
}
private void TextBoxValidated(object sender, EventArgs e)
{
{
else if (ReferenceEquals(sender, txtCountry))
Trova((TextBox)sender, "Name");
}
else if (ReferenceEquals(sender, txtFamily))
{
Trova((TextBox)sender, "Family");
_bs.Filter = String.Concat(nomeColonna, " ", "LIKE '", textBox.Text, "*'");
}
{

Trova((TextBox)sender, "Country");
}
}

private void Trova(Control textBox, string nomeColonna)
{

DataGridView1.DataSource = _bs;
} } }