Unable to show total sum in datalist

shrish pulkit

11y2.8k.NET

Hi people i am working on a e-commerce project, to store items in shopping cart i have use DataTable with session as given below

(Creating Shopping Cart on page load)

if (Session["basket"] == null)

{

dtcart.Columns.Add(new DataColumn("Productimg", typeof(string)));

dtcart.Columns.Add(new DataColumn("ProductID", typeof(int)));

dtcart.Columns.Add(new DataColumn("Name", typeof(string)));

dtcart.Columns.Add(new DataColumn("Quantity", typeof(int)));

dtcart.Columns.Add(new DataColumn("Price", typeof(string)));

Session["basket"] = dtcart;

}

else

{

dtcart = (DataTable)Session["basket"];

}

(For Adding items to cart i have use following code)

Boolean blnMatch = false;

dtcart = (DataTable)Session["basket"];

foreach (DataRow row in dtcart.Rows)

{

if (int.Parse(row["ProductID"].ToString()) == Convert.ToInt32(lblprodid.Text))

{

row["Quantity"] = (int)row["Quantity"] + 1;

string script = "alert(\"Item Already Added to Shopping Cart.!\");";

ScriptManager.RegisterStartupScript(this, GetType(),"ServerControlScript", script, true);

Session["basket"] = dtcart;

blnMatch = true;

break;

}

if (!blnMatch)

{

int qty = 1;

//dtcart.Rows.Add(new object[] { lblprodid.Text, lblprodname.Text, prodImage.ImageUrl.Trim().ToString(), lblprodprice.Text });

dtcart.Rows.Add(new object[] { lblimgsrc.Text, lblprodid.Text, lblprodname.Text,Convert.ToString(qty),lblprodprice.Text});

Session["basket"] = dtcart;

}

On View Cart Page i have used DataList control to view items in shopping cart, However i am able to view all item details except the total amount of shopping cart, it will get updated when i update the quantity, although i already have tried datalist OnItemCommand and OnItemDataBound properties but i am unable to get the desired output.

screen shot of cart is as :

I want this total to be calculated as soon as the product is added to cart, as this is only working with onupdatecommand="DataList1_UpdateCommand"

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

shrish pulkit11y ago
i have made custom function like this:

private void totalamount()
{
if (dtcart != null && dtcart.Rows.Count > 0)
{
int amount = (from DataRow drCart in dtcart.AsEnumerable()
where drCart.RowState != DataRowState.Deleted
select (Convert.ToInt32(drCart["Quantity"]) * Convert.ToInt32(drCart["Price"]))).Sum();

sum = Convert.ToString(amount);
}
else
{
sum = "0.0";

}
}

but the problem is that it is only updating the grand total once i update item quantity or if i delete any item from shopping cart, it is not working if item is added or when i refresh the page after adding item
shrish pulkit11y ago
I already followed this concept but i am only able to sum last row only not the all rows.
Upendra Pratap Shahi11y ago
on the basis of index value you can sum all the value in rows.

http://www.c-sharpcorner.com/UploadFile/rohatash/adding-values-in-column-and-sum-of-the-column-values-in-grid/
Vignesh Mani11y ago
Hi You can calculate total all row value using index value.
shrish pulkit11y ago
Thank you Vignesh Mani, I got some help but not get the exact result , i was able to calculate the total amount but it is only calculating sum of last row only and also i was using datalist control instead of gridview.
Vignesh Mani11y ago
Hi refer below link

http://www.c-sharpcorner.com/UploadFile/rohatash/adding-values-in-column-and-sum-of-the-column-values-in-grid/