Line 165: string query = "delete b from shopbasket b INNER JOIN shopproducts p on p.id=b.pid where @id=b.guid and p.count<b.count";
Line 166: SqlCommand scon = new SqlCommand(query, conn);
Line 167: scon.Parameters.AddWithValue("@id", Request.Cookies["shoppingcart"].Value.ToString());
Line 168: SqlDataReader dr = scon.ExecuteReader();
Line 169: dr.Read();
|