hello Tushar..
You can try this..
In the button click event(private void button1_Click(object sender, EventArgs e)) you can create a datatable or dataset in which you can pass the query to find the data from the database and reflect the data in the datagridview.
code will be like this..
private void button1_Click(object sender, EventArgs e)
{
DataTable dt= new DataTable;
SqlDataAdapter adpt = new SqlDataAdapter("Select <field> from <table> where <field> like '" + textbox.Text + "%'",connectionobject);
adpt.Fill(dt);
datagridview.DataSource = dt;
}</field></table></field>