<asp:ImageButton ID="ImageButton1"  runat="server" ImageUrl='<%#Eval("PictureURL","~/ProductImages/{0}") %>'  />

 <asp:ImageButton ID="ImageButton1"  runat="server" ImageUrl='<%#Bind("ImageURL","~/ProductImages/{0}") %>' />

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ShoppingCart.ascx.cs" Inherits="ShoppingCart" %>
<asp:GridView ID="CartGrid" AutoGenerateColumns="False" DataKeyNames="ProductID" runat="server" OnRowCancelingEdit="CartGrid_RowCancelingEdit" OnRowDeleting="CartGrid_RowDeleting" OnRowUpdating="CartGrid_RowUpdating" OnRowEditing="CartGrid_RowEditing">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Image ID="Image1" runat="server" ImageUrl='<%# Bind("ProductImageUrl", "~/ProductImages/{0}") %>' Width="100" />
            </ItemTemplate>
        </asp:TemplateField>
       
      
        <asp:BoundField DataField="ProductName" HeaderText="Product" ReadOnly="True" />
        <asp:BoundField DataField="Quantity" HeaderText="Quantity" />
         <asp:BoundField DataField="Price" HeaderText="Price" ReadOnly="True" DataFormatString="{0:c}" />
         <asp:BoundField DataField="LineTotal" HeaderText="Total" ReadOnly="True" DataFormatString="{0:c}" />


        <asp:CommandField ShowEditButton="True" ShowDeleteButton="True" />
    </Columns>
    <EmptyDataTemplate>
        There is nothing in your shopping cart. You can buy items from the <a href="Shop.aspx">Shop.</a>
    </EmptyDataTemplate>
</asp:GridView>
<br />
<asp:Label ID="TotalLabel" runat="server"></asp:Label>

 protected void btnAddToCart_Click(object sender, ImageClickEventArgs e)
    {
        double Price = double.Parse(((Label)DataList1.Controls[0].FindControl("PriceLabel")).Text);
        string ProductName = ((Label)DataList1.Controls[0].FindControl("NameLabel")).Text;
        string PictureURL = ((Label)DataList1.Controls[0].FindControl("PictureUrlLabel")).Text;
        int ProductID = int.Parse(Request.QueryString["ProductID"]);


        if (Profile.Cart == null)
        {
            Profile.Cart = new Royal.Commerce.RoyalShoppingCart();
        }
        Profile.Cart.Insert(ProductID, Price, 1, ProductName, PictureURL);
        Server.Transfer("Shop.aspx");

    }

  Server Error in '/Royal' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error: 


Line 105:        try
Line 106:        {
Line 107:            conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Royal"].ConnectionString);
Line 108:            conn.Open();
Line 109:            trans = conn.BeginTransaction();
 

Source File: e:\Marathi\Royal\Checkout.aspx.cs    Line: 107 

Stack Trace: 


[NullReferenceException: Object reference not set to an instance of an object.]
   Checkout.Wizard1_FinishButtonClick1(Object sender, WizardNavigationEventArgs e) in e:\Marathi\Royal\Checkout.aspx.cs:107
   System.Web.UI.WebControls.Wizard.OnFinishButtonClick(WizardNavigationEventArgs e) +75
   System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +619
   System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +86
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4921

 protected void Wizard1_FinishButtonClick1(object sender, WizardNavigationEventArgs e)
    {
        // Insert the order and order lines into the database
        SqlConnection conn = null;
        SqlTransaction trans = null;
        SqlCommand cmd;

        try
        {
            conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Royal"].ConnectionString);
            conn.Open();
            trans = conn.BeginTransaction();

            cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.Transaction = trans;

            // set the order details
            cmd.CommandText = "INSERT INTO Orders(MemberName, OrderDate, Name, Address, County, PostCode, Country, SubTotal, Discount, Total) " + "VALUES (@MemberName, @OrderDate, @Name, @Address, @County, @PostCode, @Country, @SubTotal, @Discount, @Total)";
            cmd.Parameters.Add("@MemberName", SqlDbType.VarChar, 50);
            cmd.Parameters.Add("@OrderDate", SqlDbType.DateTime);
            cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50);
            cmd.Parameters.Add("@Address", SqlDbType.VarChar, 255);
            cmd.Parameters.Add("@PostalCode", SqlDbType.VarChar, 15);
            cmd.Parameters.Add("@Country", SqlDbType.VarChar, 50);
            cmd.Parameters.Add("@SubTotal", SqlDbType.Money);
            cmd.Parameters.Add("@Discount", SqlDbType.Money);
            cmd.Parameters.Add("@Total", SqlDbType.Money);

            cmd.Parameters["@MemberName"].Value = User.Identity.Name;
            cmd.Parameters["@OrderDate"].Value = DateTime.Now;
            cmd.Parameters["@Name"].Value = ((TextBox)Wizard1.FindControl("txtName")).Text;
            cmd.Parameters["@Address"].Value = ((TextBox)Wizard1.FindControl("txtAddress")).Text;
            cmd.Parameters["@PostalCode"].Value = ((TextBox)Wizard1.FindControl("txtPostalCode")).Text;
            cmd.Parameters["@Country"].Value = ((TextBox)Wizard1.FindControl("txtCountry")).Text;
            cmd.Parameters["@Total"].Value = Profile.Cart.Total;

            int OrderID = Convert.ToInt32(cmd.ExecuteScalar());

            // change the query and parameters for the order lines
            cmd.CommandText = "INSERT INTO OrderLines(OrderID, ProductID, Quantity, Price) " +
              "VALUES (@OrderID, @ProductID, @Quantity, @Price)";
            cmd.Parameters.Clear();
            cmd.Parameters.Add("@OrderID", SqlDbType.Int);
            cmd.Parameters.Add("@ProductID", SqlDbType.Int);
            cmd.Parameters.Add("@Quantity", SqlDbType.Int);
            cmd.Parameters.Add("@Price", SqlDbType.Money);

            cmd.Parameters["@OrderID"].Value = OrderID;
            foreach (CartItem item in Profile.Cart.Items)
            {
                cmd.Parameters["@ProductID"].Value = item.ProductID;
                cmd.Parameters["@Quantity"].Value = item.Quantity;
                cmd.Parameters["@Price"].Value = item.Price;

                cmd.ExecuteNonQuery();
            }

            // commit the transaction
            trans.Commit();



        }
        catch (SqlException SqlEx)
        {
            // some form of error - rollback the transaction 
            // and rethrow the exception
            if (trans != null)
                trans.Rollback();



            // Log the exception
            // Tools.log("An error occurred while creating the order", SqlEx)
            throw new Exception("An error occurred while creating the order", SqlEx);
        }
        finally
        {
            if (conn != null)
                conn.Close();
        }

        // we will only reach here if the order has been created sucessfully
        // so clear the cart
        Profile.Cart.Items.Clear();
  
    }