Use switch statement inside foreach?

[penguin14]

in this scenario I'm dealing with two gridviews (gvSnacks and gvSnackCart). gvSnacks contains a fixed list of items with a template button column to "add" the item to gvSnackCart. The foreach comes into play because I want to make sure that the item hasn't already been placed in the cart. If the user selects an item twice, I want to execute a sql command and make the gvSnackCart quantity of that item go up by 1 (instead of generating a new record).If the record isn't in the gvSnackCart, the foreach should loop all the way to its default and insert it.Here's the sql command to insert\[code\]string sqlInsert = "INSERT INTO ShoppingCart