Click here to Skip to main content
15,868,016 members
Articles / Database Development / SQL Server

GridView Order Page Shopping Cart Page ASP.NET SQL

Rate me:
Please Sign up or sign in to vote.
4.47/5 (17 votes)
23 Feb 2007CPOL2 min read 301.8K   59   38
GridView Image order page shopping cart page

Introduction

This article discusses how to create an order page and shopping cart page using GridView ASP.NET C# and SQL Server

  1. Create three tables:

    Screenshot - P11.gif

  2. Create a web Project
  3. Create an Images Folder in the project solution
  4. Add some image file into the Images folder
  5. Screenshot - P2.gif

  6. Rename the Default.aspx web page to OrderPage.aspx
  7. Drag and drop GridView object from the toolbox on to the web form.
  8. Create the following GridView Columns and set the GridView AutoGenerateColumn to false.
  9. Screenshot - p3.gif

  10. Where AddToCart is a button, Picture ID, Title and Date Added are text fields and PictureURL is Image field.
  11. GridView will look like this:

    Screenshot - p4.gif

  12. When the order page is loaded, all the items have to be loaded to the GridView for the user to select, copy the following code to the load page event:
    C#
    string Sel = "Select * from ItemTable"; 
    SqlConnection Con = new SqlConnection(Cn); 
    SqlCommand cmd = new SqlCommand(Sel, Con); 
    Con.Open(); 
    DataTable dt = new DataTable(); 
    dt.Columns.Add(new DataColumn("PictureID", typeof(int))); 
    dt.Columns.Add(new DataColumn("PictureURL", typeof(string))); 
    dt.Columns.Add(new DataColumn("Title", typeof(string))); 
    dt.Columns.Add(new DataColumn("DateAdded", typeof(DateTime))); 
    SqlDataReader reader = cmd.ExecuteReader(); 
    while (reader.Read()) 
    { 
    DataRow dr = dt.NewRow(); 
    dr["PictureID"] = Convert.ToInt32(reader["PictureId"]); 
    dr["PictureURL"] = ResolveUrl("~/Images/" +reader["PictureURL"]); 
    dr["Title"] = reader["Title"]; 
    dr["DateAdded"] = reader["DateAdded"]; 
    dt.Rows.Add(dr); 
    } 
    Con.Close(); 
    GridView1.DataSource = dt; 
    GridView1.DataBind(); 

    Where Cn Is the connection string.

  13. Enter some data to the SQL table:

    Screenshot - p5.gif

    Screenshot - p6.gif

  14. Build and run the application.
  15. The following result will be displayed:

    Screenshot - p7.gif

  16. AddToCart button click event:

    Screenshot - p8.gif

    Set the AddToCart button property.

  17. Add this to the GridView property using the source page or the HTML page
    OnRowCommand="GridView1_RowCommand"
  18. Add these lines of code to the page code behind:
    C#
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) 
    { 
    if (e.CommandName == "AddToCart") 
    { 
    int index = Convert.ToInt32(e.CommandArgument); 
    GridViewRow row = GridView1.Rows[index]; 
    AddShopCart(row.Cells[1].Text.ToString()); 
    } 
    } 
  19. After you click the AddToCart button, you need to move the item to the shopping cart. To do that, you need to write code to make a data entry to OrderTable, since ItemId is unique. Based on ItemId we insert a data entry to the OrderTable.
  20. Before we make an entry to the table we need order Number, we can get the order number from ControlTable since ControlTable holds the last used order number.
  21. The method to insert selected item to shopping cart will get the last used order number from ControlTable, and after inserting the values to the OrderTable will update the order number in the ControlTable.
    C#
    private void AddShopCart(string ItemId) 
    { 
    string ord = OrderNumber(); 
    if (ord != "Bad order") 
    { 
    int ordernumber = Convert.ToInt32(ord); 
    ordernumber += 1; 
    SqlConnection C_n = new SqlConnection(Cn); 
    SqlCommand cm = new SqlCommand("Insert INTO OrderTable VALUES
    	('" + ordernumber + "', '" + ItemId + "', '" + "101" + 
    	"', '" + Convert.ToDateTime("2/19/2007") + "','" + "1" + "')", C_n); 
    C_n.Open(); 
    SqlDataReader dr = cm.ExecuteReader(); 
    C_n.Close(); 
    UpdateOrderNumber(ordernumber); 
    } 
    } 
  22. The method to get the last used order number.
    C#
    private string OrderNumber() 
    { 
    SqlConnection Or_Cn = new SqlConnection(Cn); 
    SqlCommand Or_Cm = new SqlCommand("Select OrderNumber from ControlTable", Or_Cn); 
    Or_Cn.Open(); 
    SqlDataReader Or_rd = Or_Cm.ExecuteReader(); 
    if (Or_rd.Read()) 
    { 
    return Or_rd["OrderNumber"].ToString(); 
    } 
    else 
    { 
    return "Bad order"; 
    } 
    } 
  23. The method to update the order number in the ControlTable:
    C#
    private void UpdateOrderNumber(int UpdatedNumber) 
    { 
    SqlConnection Op_Cn = new SqlConnection(Cn); 
    SqlCommand Op_Cm = new SqlCommand
    	("Update ControlTable Set OrderNumber=" + UpdatedNumber, Op_Cn); 
    Op_Cn.Open(); 
    SqlDataReader Op_rd = Op_Cm.ExecuteReader(); 
    Op_Cn.Close(); 
    } 
  24. Add new page to the project and name it ShoppingCart.aspx.
  25. Drag and drop GridView object from the toolbox on to the web form.
  26. Create the following GridView columns and set the GridView AutoGenerateColumn to false.

    Screenshot - p9.gif

  27. Where Delete is a button, Picture ID, Title, Price and Date Added are text fields and PictureURL is Image field.
  28. GridView will look like this:

    Screenshot - p10.gif

  29. Under page load event, copy the following code:
    C#
    string Sel = "Select a.* from ItemTable as a INNER JOIN 
    		OrderTable as b ON a.PictureId=b.ItemId"; 
    SqlConnection Con = new SqlConnection(Cn); 
    SqlCommand cmd = new SqlCommand(Sel, Con); 
    Con.Open(); 
    DataTable dt = new DataTable(); 
    dt.Columns.Add(new DataColumn("PictureID", typeof(int))); 
    dt.Columns.Add(new DataColumn("Title", typeof(string))); 
    dt.Columns.Add(new DataColumn("Price", typeof(string))); 
    dt.Columns.Add(new DataColumn("DateAdded", typeof(DateTime))); 
    dt.Columns.Add(new DataColumn("PictureURL", typeof(string))); 
    SqlDataReader reader = cmd.ExecuteReader(); 
    while (reader.Read()) 
    { 
    DataRow dr = dt.NewRow(); 
    dr["PictureID"] = Convert.ToInt32(reader["PictureId"]); 
    dr["Title"] = reader["Title"]; 
    dr["Price"] = reader["Price"]; 
    dr["DateAdded"] = reader["DateAdded"]; 
    dr["PictureURL"] = ResolveUrl("~/Images/" + reader["PictureURL"]); 
    dt.Rows.Add(dr); 
    } 
    Con.Close(); 
    GridView1.DataSource = dt; 
    GridView1.DataBind(); 
  30. Build and run. After placing some order, make the shopping cart startup page and you will see all the orders you have placed listed there.

License

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


Written By
Chief Technology Officer Compuacademy.net
United States United States
More than 15 years of experience in design, architecture and development of various commercial objects oriented application.Other Specialties

Data Migration:
• MS Access database to SQL 2005/2008
• MS Access database to Oracle
• MS Access database to My SQL
• FoxPro to SQL

Application Migration:
• Converted MS Access application to .net web application (Asp.net)
• Excel Application to .net 3.5 web application
• FoxPro application to .net 3.5
Reporting development and support
• MS access reports
• Crystal reports
• SQL Reports(SSRS)
• DevExpress reports
• Cognos reports
Application development and support
• .net Application web /Win forms
• SharePoint
• MS Access
• Website
• Ecommerce
• WCF
• Web Services
3rd Party Control Support
• DevExpress
• .netForum
• Telerik
Version controls Support
• Team Foundation Server
• Source Safe
• CVS
• SVN

Comments and Discussions

 
AnswerRe: please put your next code and give me that link if already placed Pin
T.Ashraf31-Oct-07 23:41
T.Ashraf31-Oct-07 23:41 
GeneralSql server Image datatype problem Pin
Srinivas Vasireddy12-Sep-07 0:38
Srinivas Vasireddy12-Sep-07 0:38 
GeneralRe: Sql server Image datatype problem Pin
T.Ashraf27-Sep-07 15:16
T.Ashraf27-Sep-07 15:16 
GeneralCart Items in Session Pin
nonintrusive9-Aug-07 13:54
nonintrusive9-Aug-07 13:54 
GeneralRe: Cart Items in Session Pin
T.Ashraf10-Aug-07 5:41
T.Ashraf10-Aug-07 5:41 
Questionhow to create table Pin
reddyamar_uk8-Mar-07 12:01
reddyamar_uk8-Mar-07 12:01 
AnswerRe: how to create table Pin
T.Ashraf8-Mar-07 12:08
T.Ashraf8-Mar-07 12:08 
Generalneeds improving Pin
GaryWoodfine 17-Feb-07 11:47
professionalGaryWoodfine 17-Feb-07 11:47 
I feel your article needs improving upon.
Most notable thing is that you need to wrap your sample code in <pre> tags.
You should then also elaborate on your explanation of the code
This is always tricky when writing articles as some things you think as trivial my be completely new to some readers. It's always hard to get the right balance.
I am going through that same learning curve myself Smile | :)



Kind Regards,
Gary


My Website || My Blog || My Articles

GeneralRe: needs improving Pin
T.Ashraf17-Feb-07 23:39
T.Ashraf17-Feb-07 23:39 
GeneralRe: needs improving Pin
GaryWoodfine 19-Feb-07 11:04
professionalGaryWoodfine 19-Feb-07 11:04 

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

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