private void OrderDetailForm_Load(object sender, EventArgs e) { Item item = new Item(); item.LoadByPrimaryKey(_itemID); txtItemName.Text = item.FullItemName; ItemUnit iu = new ItemUnit(); iu.LoadByPrimaryKey(_unitID); txtUnit.Text = iu.Text; BLL.Balance balance = new Balance(); gridApprovedPrinted.DataSource = balance.GetApprovedValueForFacility(CurrentContext.UserId, item.ID, iu.ID); gridPicklistPrinted.DataSource = balance.GetPicklistedValueForFacility(CurrentContext.UserId, item.ID, iu.ID); var activities = new Activity(); activities.LoadByUserID(CurrentContext.UserId); DataTable dtbl = null; while (!activities.EOF) { DataTable dt = balance.GetSOHForAnItem(activities.ID, item.ID, iu.ID); if (dt != null && dt.Rows.Count > 0) { dt.Columns.Add("Account"); dt.Rows[0]["Account"] = activities.FullActivityName; if (dtbl == null && Convert.ToInt32(dt.Rows[0]["SOH"]) > 0) { dtbl = dt; } else if (Convert.ToInt32(dt.Rows[0]["SOH"]) > 0) { dtbl.ImportRow(dt.Rows[0]); } } activities.MoveNext(); } gridItemStockStatus.DataSource = dtbl; this.Text = string.Format("({0} - {1}) Details of : {2}", _itemID, _unitID, item.FullItemName); }