private void LoadProduct() { try { DataTable dt = new DataTable(); dt.Load(mOrder.USP_OrderDetailTemp_GetAllOrderID(Session["WOrderID"].ToString())); if (dt.Rows.Count > 0) { lblTax.Text = dt.Compute("SUM(VAT)", string.Empty).ToString(); //lblSumOrder.Text = dt.Compute("SUM(Price)", string.Empty).ToString(); //lblTotal.Text = dt.Compute("SUM(TotalPrice)", string.Empty).ToString(); lblSumOrder.Text = Convert.ToInt32(dt.Compute("SUM(SubTotal)", String.Empty)).ToString("#,##"); lblTotal.Text = Convert.ToInt32(dt.Compute("SUM(TotalPrice)", String.Empty)).ToString("#,##"); btnBuy.Visible = true; // Load rptOrder.DataSource = dt; rptOrder.DataBind(); } } catch { } }
private void LoadProduct() { try { DataTable dt = new DataTable(); dt.Load(mOrder.USP_OrderDetailTemp_GetAllOrderID(Session["WOrderID"].ToString())); if (dt.Rows.Count > 0) { lblQuantity.Text = dt.Compute("SUM(Quantity)", string.Empty).ToString(); } // Load rptOrder.DataSource = dt; rptOrder.DataBind(); } catch { } }