searching in a gridview using like keyword

refer to this link

http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html

or you can use dataview to filter the rows using like operator.

Go to this link

public void fill_grid()

{

try

{

Conn = new SqlConnection(ConnString);

if (Conn.State == ConnectionState.Closed)

{

Conn.Open();

}

string query = "select model_name,part_no,comp_name,descripation from model_master where comp_name like

'%"+cmb_comb.text+"%' and model_name like'%"+txt_search.tex+"%' ";

Cmd = new SqlCommand(query, Conn);

Adp = new SqlDataAdapter(Cmd);

DataSet ds = new DataSet();

Adp.Fill(ds);

grid_model_info.DataSource = ds.Tables[0];

Conn.Close();

}

catch (Exception ex)

{

MessageBox.Show();

}

}

Call This Function of textchange event of searching text box...
OR on Button Click Event..