privatevoid button1_Click(object sender, EventArgs e)//button click event
{
DataTable dt= new DataTable;//creation of datatable which will be reflected in
//the datagrid view
SqlDataAdapter adpt = new SqlDataAdapter("Select <field> from <table> where <field> like '" + textbox.Text + "%'",connectionobject); //query for database
adpt.Fill(dt);//datatable to catch the fields from the database
datagridview.DataSource = dt;
}</field></table></field>