private void textSearch_TextChanged(object sender, EventArgs e) { string keywords = textSearch.Text; //filter the categories baser on keywords if (keywords != null) { //use search method to display categories DataTable dt = GroupDAL.Search(keywords); dgvGroup.DataSource = dt; } else { //Select method to display all categories DataTable dt = GroupDAL.Select(); dgvGroup.DataSource = dt; } }