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
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:
Source File: c:UsersPerk-OnDocumentsVisual Studio 2008WebSitesestApp_CodeCart.cs Line: 69 Stack Trace:
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?
Anyways 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.
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...
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.
I 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.
offer 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.
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 ?
Say 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?