protected void btnSearch_Click(object sender, EventArgs e) { try { string searchText; if (ddlSearch.SelectedValue == "1") { searchText = "A.[Code] like '%" + txtSearch.Text.Trim() + "%'"; } else { searchText = "A.[Name] like '%" + txtSearch.Text.Trim() + "%'"; } DataSet dSet = provider.GetAllByFilterExpression(searchText); if (dSet != null && dSet.Tables[0].Columns.Count > 0) { gvProduct.DataSource = dSet.Tables[0]; gvProduct.DataBind(); } else { MessageHelper.ShowAlertMessage("Data Not Found."); LoadData(); } } catch (Exception ex) { MessageHelper.ShowAlertMessage(ex.Message); } }