Problem in code while doing serach from datgridview.

dataGridView1.DataMember = ds.Tables[0].TableName; //or if you want to use DataTable as DataSource for your grid dataGridView1.DataSource = ds.Tables[0];

  modify it 
 string name = txtsearch.Text;             string query = "select * from Customer where [First Name] like '%" + name + "%'";             DataManager dtmanger = new DataManager();             dataGridView1.DataSource = null; 
dataGridView1.DataMember = ds.Tables[0].TableName;
             DataTable dt = dtmanger.LoadData(query);
if(dt.Rows.count>0)
{             dataGridView1.AutoGenerateColumns = true;             dataGridView1.DataSource = dt;
 dataGridView1.Refresh();


}