protected void Page_Load(object sender, EventArgs e) { LastADEntities entities = new LastADEntities(); var c = entities.AdjVouchers.Where(p => p.Status == "PendingDHAuthorisation") .Join(entities.ItemLists, m => m.ItemId, f => f.ItemId, (m, f) => new { AdjVoucherId = m.AdjVoucherId, Datechecked = m.SubmitDate, ItemId = m.ItemId, Item = f.Description, QuantityAdjusted = m.QuantityAdj, Reason = m.Reason }) .ToList(); DataTable dt = new DataTable(); if (dt.Columns.Count == 0) { dt.Columns.Add("AdjVoucherId", typeof(int)); dt.Columns.Add("DateChecked", typeof(DateTime)); dt.Columns.Add("Item", typeof(string)); dt.Columns.Add("QuantityAdjusted", typeof(int)); dt.Columns.Add("Cost", typeof(decimal)); dt.Columns.Add("Reason", typeof(string)); } for (int i = 0; i < c.Count(); i++) { DataRow NewRow = dt.NewRow(); NewRow[0] = c[i].AdjVoucherId; NewRow[1] = c[i].Datechecked.Value.Date; NewRow[2] = c[i].Item; NewRow[3] = c[i].QuantityAdjusted; decimal Cost = Math.Round((decimal)(Business.Findavgitempricebyid(c[i].ItemId) * c[i].QuantityAdjusted), 2); NewRow[4] = Cost; NewRow[5] = c[i].Reason; dt.Rows.Add(NewRow); } GridView2.DataSource = dt; GridView2.DataBind(); }