Problem in code while doing serach from datgridview.

Question

I am doing search from Datagridview. But no search is undertook. please help me. i am searching by First Name. here is code.

Umesh Kumar · Answer

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 (); }