protected void BindApprovedPaymentInvoice() { try { int rowcount = ucCustomPagerItems.isCountRecord; DataTable dtType = new DataTable(); objChangeReqstMerge.AddMergedColumns(new int[] { 4, 5 }, "Payment Planned", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 6, 7 }, "Priority", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 8, 9 }, "Overdue", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 10, 11 }, "0 To 7 Days", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 12, 13 }, "8 to 14 Days", "HeaderStyle-center"); objChangeReqstMerge.AddMergedColumns(new int[] { 14, 15 }, "After 15 Days", "HeaderStyle-center"); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } Int16 AutoCheck = 0; if (chkAuto.Checked == true) { AutoCheck = 1; } else { AutoCheck = 0; } DataTable dt = BLL_POLOG_Register.POLOG_Get_Payment_Processing_Invoice_Search(UDFLib.ConvertStringToNull(ddlCurrency.SelectedValue), Convert.ToInt16(AutoCheck), UDFLib.ConvertIntegerToNull(GetSessionUserID()), sortbycoloumn, sortdirection , ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } //if (dt.Rows.Count > 0) //{ divApprovedinvoice.Visible = true; gvApprovedPaymentinvoice.DataSource = dt; gvApprovedPaymentinvoice.DataBind(); gvApprovedPaymentinvoice.Rows[0].BackColor = System.Drawing.Color.Yellow; BindSupplierInvoice(dt.Rows[0]["Supplier_Code"].ToString()); BindSupplierDetails(dt.Rows[0]["Supplier_Code"].ToString()); txtSupplierCode.Text = dt.Rows[0]["Supplier_Code"].ToString(); //} //else //{ // divApprovedinvoice.Visible = false; // gvApprovedPaymentinvoice.DataSource = dt; // gvApprovedPaymentinvoice.DataBind(); //} } catch { } { } }