private void SearchData() { string SQL = ""; grdSearchResults.DataSource = null; grdSearchResults.DataBind(); if ((txtSearchQuotationNo.Text == "") && (txtSearchVehicleNo.Text == "")) { ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Search text cannot be blank');", true); return; } if (txtSearchQuotationNo.Text != "") { SQL = "(LOWER(QUOTATION_NO) LIKE '%" + txtSearchQuotationNo.Text.ToLower() + "%') AND"; } if (txtSearchVehicleNo.Text != "") { SQL = "(LOWER(VEHICLE_NO) LIKE '%" + txtSearchVehicleNo.Text.ToLower() + "%') AND"; } SQL = SQL.Substring(0, SQL.Length - 3); ProposalUploadController proposalUploadController = new ProposalUploadController(); grdSearchResults.DataSource = proposalUploadController.GetUploadedProposals(SQL); if (grdSearchResults.DataSource != null) { grdSearchResults.DataBind(); } pnlSearchGrid.Visible = true; }