indradeo says:
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            BindGridView(TextBox1.Text);
        }
        private void BindGridView(string searchVal)
        {
            SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ToString());
            try
            {
                DataTable objdt = new DataTable();
                string query = searchVal == "" ? "select * from tbl_Employees;" : "select * from tbl_Employees where EmpCode like '%" + searchVal + "%';";
                SqlDataAdapter da = new SqlDataAdapter(query, con);
                con.Open();
                da.Fill(objdt);
                con.Close();
                if (objdt.Rows.Count > 0)
                {
                    GridView1.DataSource = objdt;
                    GridView1.DataBind();
                }
            }
            catch
            {
                con.Close();
            }
        }
Replace with below code.
protected void btnSearch_Click(object sender, EventArgs e)
{
    BindGridView(TextBoxSearch.Text);
}
private void BindGridView(string searchVal)
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
    try
    {
        DataTable objdt = new DataTable();
        string query = "select * from tbl_Employees ";
        if (!string.IsNullOrEmpty(searchVal))
        {
            query += " where EmpCode like '%" + searchVal + "%';";
        }
            
        SqlDataAdapter da = new SqlDataAdapter(query, con);
        con.Open();
        da.Fill(objdt);
        con.Close();
        if (objdt.Rows.Count > 0)
        {
            GridView1.DataSource = objdt;
            GridView1.DataBind();
        }
    }
    catch
    {
        con.Close();
    }
}