private void ShowData() { try { DataSet ds = vendor.GetVendorData(VendorId); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { txtVendorCode.Text = item["VendorCode"].ToString(); txtName.Text = item["VendorName"].ToString(); txtPhoneNumber.Text = item["PhoneNumber"].ToString(); txtFax.Text = item["Fax"].ToString(); txtContactPerson.Text = item["ContactPerson"].ToString(); txtCity.Text = item["City"].ToString(); txtAdress.Text = item["Address"].ToString(); txtEmail.Text = item["Email"].ToString(); txtVat.Text = item["VAT"].ToString(); if (item["VendorTypeId"].ToString() != "0") { lstVendorType.EditValue = Convert.ToInt32(item["VendorTypeId"].ToString()); } if (item["CountryId"].ToString() != "0") { lstCountry.EditValue = Convert.ToInt32(item["CountryId"].ToString()); } txtCRNo.Text = item["CrNo"].ToString(); txtGosiNo.Text = item["GosiNo"].ToString(); txtZakaat.Text = item["Zakaat"].ToString(); txtChamberNo.Text = item["ChamberNo"].ToString(); txtVATExpiry.Text = item["VATExpiry"].ToString() != "" ? Convert.ToDateTime(item["VATExpiry"].ToString()).ToString("dd/MMM/yyyy"):""; txtChamberExpiry.Text = item["ChamberNoExpiry"].ToString() != "" ? Convert.ToDateTime(item["ChamberNoExpiry"].ToString()).ToString("dd/MMM/yyyy"):""; txtCRExpiry.Text = item["CrNoExpiry"].ToString() != "" ? Convert.ToDateTime(item["CrNoExpiry"].ToString()).ToString("dd/MMM/yyyy") : ""; txtGosiExpiry.Text = item["GosiNoExpiry"].ToString() != "" ? Convert.ToDateTime(item["GosiNoExpiry"].ToString()).ToString("dd/MMM/yyyy") : ""; txtZakaatExpiry.Text = item["ZakaatExpiry"].ToString() != "" ? Convert.ToDateTime(item["ZakaatExpiry"].ToString()).ToString("dd/MMM/yyyy") : ""; } } } catch (Exception ex) { MessageBox.Show(ex.InnerException != null ? ex.InnerException.Message : ex.Message); } }