private void GetOrderData() { DataSet ds = _objSalesOrder.GetDataOrderVoucher(lblOrderNo.Text); DataTable dtdetails = ds.Tables[1]; int j = 1; decimal.TryParse(lblTotalQtyPrimary.Text, out decimal primaryQty); foreach (DataRow drDetails in dtdetails.Rows) { for (int i = 0; i < Convert.ToDecimal(drDetails["Qty"].ToString()); i++) { Grid.Rows.Add(); Grid.Rows[Grid.Rows.Count - 1].Cells["SNo"].Value = j; Grid.Rows[Grid.Rows.Count - 1].Cells["ProductDesc"].Value = drDetails["ProductDesc"].ToString(); Grid.Rows[Grid.Rows.Count - 1].Cells["ProductId"].Value = drDetails["ProductId"].ToString(); Grid.Rows[Grid.Rows.Count - 1].Cells["Qty"].Value = "1"; Grid.Rows[Grid.Rows.Count - 1].Cells["Rate"].Value = drDetails["SalesRate"].ToString(); Grid.Rows[Grid.Rows.Count - 1].Cells["Note"].Value = drDetails["ResOrderNotes"].ToString(); Grid.Rows[Grid.Rows.Count - 1].Cells["TermDetails"].Value = drDetails["TermDetails"].ToString(); j++; } primaryQty += Convert.ToDecimal(drDetails["Qty"].ToString()); } lblTotalQtyPrimary.Text = ClsGlobal.DecimalFormate(primaryQty, 1, ClsGlobal._CurrencyDecimalFormat).ToString(); }