private void GetLOADetails(string LOANo)
{
foreach (DataRow dr in ClsPEZAData.GetClientLOAlistByLOANo(LOANo).Rows)
{
tbPEZALOANoDateExpired.Text = Convert.ToDateTime(dr["LOAdate"]).ToString("dd/MMM/yyyy");
tbLOABondNo.Text = dr["LOAbondNo"].ToString().Trim();
tbBondExpirationDate.Text = Convert.ToDateTime(dr["LOAbondExpDate"]).ToString("dd/MMM/yyyy");
tbLOAQtyApplied.Text = string.Format("{0:#,###0.#}", Convert.ToDecimal(dr["LOAqty"]));
tbLOAQtyUsed.Text = string.Format("{0:#,###0.#}", Convert.ToDecimal(dr["LOAqtyDelivered"]));
tbLOAQtyBalance.Text = string.Format("{0:#,###0.#}", Convert.ToDecimal(dr["LOAbalanceQty"]));
}
tb8106ItemNo.Text = "1";
}