Click here to Skip to main content
Click here to Skip to main content

Simple Shopping Cart

, 31 Dec 2010
Rate this:
Please Sign up or sign in to vote.
Simple shopping cart with session
ShoppingCart.jpg

Introduction

This is a simple basket or shopping cart, that user can select some goods from list and add them to shopping cart. Also a user can remove or change the count of each good. In this article, I use session for storing the shopping cart user can submit for buying and shopping cart saved in database.

Using the Code

In Web, if you need to have common variable in all pages, you must save in session. Session variables store in server and for each user webserver creates a new session ID and session variables. You can store any object in session. I create a DataTable for storing shopping cart and set it in session variable.

Creating a session is very simple:

Session["variable-name"] = variable-value;

Session variable will remove after session time out (default time is 20 minutes), but if you want to remove a session variable:

Session.Remove("variable-name");

In this project, I store DataTable in session. In Page_Load, if there is session variable it reads and if not, it creates an empty DataTable.

if (Session["basket"] != null)
	///read Basket_DataTable from session if exist
	Basket_DataTable = (DataTable)Session["basket"];
else
{
	//create an empty DataTable and Add some columns to it
	Basket_DataTable = new DataTable();
	Basket_DataTable.Columns.Add("id");
	Basket_DataTable.Columns.Add("name");
	Basket_DataTable.Columns.Add("price");
	Basket_DataTable.Columns.Add("pic");
	Basket_DataTable.Columns.Add("count");
	Basket_DataTable.Columns.Add("total");
}

After this, all changes will be made on Basket_DataTable and finally Basket_DataTable saved in session.

Session["basket"] = Basket_DataTable; 

For adding items to shopping cart, I first search for item in Basket_DataTable and if it not found, item will add to shopping cart:

//search item in DataTable
bool Found = false;
for (int i = 0; i < Basket_DataTable.Rows.Count; i++)
    if (Basket_DataTable.Rows[i][0].ToString() == 
    Request["ID"].ToString())
        Found = true;

In the above code, Request["ID"] is ID of Item.

Before adding Item, I search item ID in database and if it finds item, add to basket.

//add item to DataTable
if (Found == false)
{
    //search item in database
    DataAcess data = new DataAcess();
    string sql = "SELECT * FROM kala where id=" + Request["ID"];
    DataTable ret= data.exe_select(sql);
    //if it found in database add it to basket
    if (ret != null && ret.Rows.Count == 1)
    {
        Basket_DataTable.Rows.Add(new object[] 
        { Request["ID"],ret.Rows[0]["name"].ToString()
                                  ,ret.Rows[0]["price"].ToString(),
                                  ret.Rows[0]["pic"].ToString()
                                 ,"1",ret.Rows[0]["price"].ToString()});
    }
}

For removing items from shopping cart, I add a link in each Item that send item id. To remove I search item and if it is found, it will be removed.

if (Request["DelID"] != null)
{
    //search and remove
    for (int i = 0; i < Basket_DataTable.Rows.Count; i++)
        if (Basket_DataTable.Rows[i][0].ToString() == 
        Request["DelID"].ToString())
            Basket_DataTable.Rows.Remove(Basket_DataTable.Rows[i]);
}

Also I add a TextBox for each item, for item count. User can change item count and click update button and item count will change in DataTable.

for (int i = 0; i < GridView2.Rows.Count; i++)
{
    TextBox Tb=(TextBox) GridView2.Rows[i].FindControl("TextBoxCount");
    Basket_DataTable.Rows[i]["count"] = Tb.Text;
    Basket_DataTable.Rows[i]["total"] = Convert.ToInt32(Tb.Text)*
		Convert.ToInt32(Basket_DataTable.Rows[i]["price"]);
}

I also add some code for saving shopping cart in database, I save item id and item count in database.

DataAcess data = new DataAcess();
for (int i = 0; i < GridView2.Rows.Count; i++)
{
	String ID = GridView2.Rows[i].Cells[0].Text.ToString(); ;
	TextBox Tb = (TextBox)GridView2.Rows[i].FindControl("TextBoxCount");
	string sql = "INSERT INTO Basket (count, id)VALUES ({0}, {1})";
	sql = string.Format(sql, Tb.Text, ID);
	data.exe_cmd(sql);
}

Summary

In this article, I describe a simple shopping cart with session. It is simple but I hope it helps you. Also, you can find a simple and useful class for connecting to database (I don't mention in the article).

Have fun with C# coding.

History

  • 31st December, 2010: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

mohammad hajibegloo
Engineer neyshabur azad univeristy
Iran (Islamic Republic Of) Iran (Islamic Republic Of)
I had worked as programmer,project manager,web developer for more than 3 years, and have worked on programming personaly for more than 10 years.
I have worked in university as a teacher for 8 years.
my favorite langueges are : VC++,C#,ASP.NET,PHP

Comments and Discussions

 
SuggestionPutting shopping cart items in session that will cost your more memory and slow down your website performance. Pinmemberpfsze26-May-14 8:06 
QuestionThanks PinmemberMember 1083938323-May-14 3:03 
Questionthanks and q to u? Pinmembershajahansaju15-May-14 18:32 
QuestionNot saving in database Pinmemberajay.shetti4-May-14 4:01 
QuestionHow to calculate sum of totalprice column PinmemberMember 104991625-Feb-14 0:33 
QuestionProject doesn't build. Pinmemberpitlab13-Jan-14 5:01 
QuestionSimple Shopping Cart Project PinmemberMember 102478026-Oct-13 3:24 
Questionsalam Pinmembermorteza66m30-Jun-13 20:35 
GeneralMy vote of 1 PinmemberMorteza Khaalili23-Jun-13 7:15 
GeneralMy vote of 3 PinmemberJe79-Apr-13 8:53 
Questionhi Pinmembersteffit15-Mar-13 4:10 
AnswerRe: hi Pinmembermohammad hajibegloo16-Mar-13 22:41 
Questionshopping cart PinmemberYakov Dmitriy16-Nov-12 23:24 
GeneralMy vote of 1 PinmemberGalva_Delphi20-May-12 6:00 
Suggestion[My vote of 1] Not good Pingroupwidestination30-Mar-12 2:03 
GeneralRe: [My vote of 1] Not good Pinmembermohamad hajibegloo30-Mar-12 21:52 
GeneralRe: [My vote of 1] Not good Pinmemberlida.y28-Aug-12 22:18 
GeneralMy vote of 5 Pinmemberasdf1234hn6-Jan-11 21:03 
GeneralMy vote of 5 PinmemberSunasara Imdadhusen4-Jan-11 23:17 
GeneralMy vote of 1 Pinmemberg0got231-Dec-10 10:45 
RantRe: My vote of 1 Pinmembermohamad hajibegloo1-Jan-11 8:10 
GeneralRe: My vote of 1 PinmemberSunasara Imdadhusen4-Jan-11 23:17 
General[My vote of 2] Using SQL in UI PingroupGagan111831-Dec-10 7:13 
GeneralMy vote of 1 PinmvpMark Nischalke31-Dec-10 7:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 31 Dec 2010
Article Copyright 2010 by mohammad hajibegloo
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid