void GetCustomerDetails() { var ds = new BLSales().GetSupCustUnPaidInvoices(lookupcustomer.EditValue.ToString()); if(ds.Rows.Count > 0) { var bal = ds.Compute("SUM(balance)",""); txtoutstanding.EditValue = bal; ledgers1.Merge(ds); } else { XtraMessageBox.Show("Data Not found", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information); } }