I am trying to calculate the total amount of shopping cart by multiplying the quantity with the product price and then sum up the sub results.I am doing this but it does not make the multiplication.
[Code]....
decimal? TotalAmount = (from shopCart in dc.KP_ShoppingCarts
String conn = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(); // for connection
SqlDataAdapter adp = new SqlDataAdapter(); // for fetch the records acc. to condition
DataTable dt = new DataTable(); // fill the fetched records
DataTable tb; // will store the session
[Code] .....
How will I get the total number of quantity....
i am making a shopping cart and i am receiving this error when tryin to add a product to an order. Incorrect syntax near the keyword 'Order'. 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.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'Order'. Source Error:
[Code]....
Source File: c:UsersPerk-OnDocumentsVisual Studio 2008WebSitesestApp_CodeCart.cs Line: 69 Stack
Trace:
[Code]....
Here is my createorder method in the cart class:
[Code]....
public string CreateOrder (string userid)
We have a demand system where customer can demand the quantity they want for a particular deal.
For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity
I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.
However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?
I have 5 fields i want when i enter rupess n 4 fields it will someup n give me total in fifth field how can i do this?
View 1 RepliesI have a nested gridview like the code quoted below. How to retrieve the counter of each child gridview elements and display it as a field of the parent gridview ?
<asp:GridView ID="GridViewMaster" runat="server" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:GridView ID="GridViewSlave" runat="server" >
[Code] ...
Calculate Row Total and Grand Total in ASP.Net GridView using jQuery
what if the price column is a template field i.e. it takes input from the user before multiplying with quantity..
how can i cart items for shopping cart application ...i am really new to web development and i want to create a shopping cart and want to cart items in it. how should i cart items.
View 2 RepliesHow would I determine the amount of time in weeks between two dates and compare that value to another value in Linq, for example:
Where the amount of time in weeks between (startdate and enddate) = value x
I have a existing gridview in asp.net+vb web . i am willing to add a shopping cart to it how is to be done
View 1 Repliesi want to know how to add cart in datalist..
View 1 RepliesAnyways i am having some serious trouble with a datalist. im sure it is probably pretty easy but im am just not very good at all with the codebehind. Basically i have a datalist connected to sqldatasource and it pulls a list of items. I want to be able to select a record from the datalist and store that value in some sort of shopping cart.
<asp:DataList ID="DataList1" runat="server" CellPadding="4"
DataSourceID="SqlDataSource1" ForeColor="#333333">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingItemStyle BackColor="White" ForeColor="#284775" />
<ItemStyle BackColor="#F7F6F3" ForeColor="#333333" />
[Code]....
I have a listview displaying my products and an "Add to Cart" button in the item template. the button fires 2 functions that should add that specific products information and the order details to two SQL database tables(Orders and Quantity(intersection entity between Orders and Products tables)) then you get redirected to the shopping cart page and it should display the item(s) according the specific key in the Quantity table(key is foreign key in Orders)My problem is that i cannot pull any information from the specific item template when i click that button. Need a way to find that specific controls information in my listview. Can anyone help with this?Below is my item template...
<ItemTemplate>\
<td id="Td2" runat="server">
<table ID="Prodtable" runat="server" width="130px" height="95px">
[code]...
After I complete an order and return to my products area my shopping cart still shows the items that were ordered. I have checked the database and the items are not there anymore. somehow my code is remembering the data.
View 3 RepliesI have some experience in developing a shopping cart in Dreamweaver. Now I wanna develop a fully functional shopping cart with Paypal payment integration in Visual Developer Express Edition 2010. My question is - Is there any nice tutorial to develop fully functional Shopping cart with Paypal Integration in ASP.NET?...
I have seen some tutorial some of them are without Payment System and Some of them are content management systems. I wanna develop my own. what is best Tutorial to develop fully functional shopping cart with Payment System in Visual Developer Express Edition 2010.
I am building a shopping cart with datatable in C#.net.As i select the product again for shopping cart,besides inceasing the quantity of the product.it is showing the product again in gridview.
View 4 Repliescan i get a good example.. in order to get started with shopping cart.. how long it's gonna take while implementing it..?
View 5 RepliesWhat is the easy way to create shopping cart?
View 8 Repliesoffer a good shopping cart tutorial?This looked like just the thing: http://net.tutsplus.com/tutorials/other/build-a-shopping-cart-in-aspnet/There are postive and negative comments though.I'm a C# beginner so know how to put it mostly together, but I'm not experience enough to know anything about "singletons" and other performance issues that above code may have.
View 5 RepliesWhat is the most common or preferred control to build the shopping cart? By this, I mean the actual control that contains the product image, description, price & checkbox to select the item.
View 8 RepliesHow to create a simple shopping cart in asp.net/c#
View 4 RepliesI am making progress on my shopping cart page. I want to show the contents of my shopping cart but I am puzzled on how to do this.
Here is the code :
Cart Class (Cart.cs)
[Code]....
Default.aspx ( I would like the cart to show up on a label on this page at the bottom)
[Code]....
[Code]....
I'm looking for a free shopping cart source code to start creating customized chart.MSC Musicstore sample code is too simple. NOPCommerce requires adding link into it in every page.Where so find such source code ?
View 4 RepliesSay i have a Laptop for 600.00. Say i change it to $650.00. How do shopping carts handle that? Like do they store the price in the cart or the item? How do they make sure they get the price they wanted but not bill the customer the new change without asking them? Or do most store them in both?
I was thinking maybe i could store it in both.So if the current price is over the cart price for a item, don't remove it/bill them from their cart. Then after, tell them what was billed/email a receipt for the items that didn't change that was billed(say they had more then one item) and remove it from the cart. For the items that did change, say something like "Items left in cart due to price change, check if you still want to buy the items at the new price." So leave the items that changed in the cart but update the price in the cart.
I don't think the language should matter. Guess this is more of a logical type question. Do most shopping carts do it this way or is there a better way?
I have a master page where in one ContentPlaceHolder I put my shopping cart:
<asp:ContentPlaceHolder ID="continutMeniuContulMeu" runat="server">
asp:UpdatePanel runat="server" ID="updatePanelCos" UpdateMode="Conditional">
<ContentTemplate>
<user:ShoppingCart ID="shoppingCartControl" runat="server" />
</ContentTemplate>
</asp:UpdatePanel>
</asp:ContentPlaceHolder>