If I correctly understand your problem, I'd recommend to use BindingSource and it's filter
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
MyDBDataSet ds = new MyDBDataSet();
BindingSource bs ;
private void Form1_Load(object sender, EventArgs e)
{
MyDBDataSetTableAdapters.ClientsTableAdapter adapter = new WindowsFormsApplication48.MyDBDataSetTableAdapters.ClientsTableAdapter();
bs = new BindingSource(ds, "Clients");
adapter.Fill(ds.Clients);
this.dataGridView1.DataSource = bs;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
bs.Filter =String.Format("Customer like '%{0}%'",textBox1.Text);
}
}