protected void btnSaleReport_Click(object sender, EventArgs e) { string fromDate, toDate; total_sale.Visible = true; fromDate = datepicker1.Value; toDate = datepicker2.Value; DataTable sale = stock.GetSalesReport(fromDate, toDate); sale_total.Visible = true; Decimal finalamount = 0; foreach (DataRow dr in sale.Rows) { finalamount += Convert.ToDecimal(dr["TOTAL_AMOUNT"].ToString()); } Label_Total_sale.Text = finalamount.ToString(); SaleStockTrans.DataSource = sale as DataTable; SaleStockTrans.DataBind(); }