DataReader Query

rsm42 · April 26th, 2007, 12:23 PM

Hi,

Can anyone advise why the following code is failing ? The code is

written in asp.net1.1 using vb.net and connected to an access

database. The following code is taken from a function and the purpose

of this code is to check to see if an item has already been added to

the shopping cart.

The cart takes the form of a datagrid and if the item located by the

productID, already exists in the cart, then I just want the quantity

value increased by one in the datagrid. This is achieved by calling

the "IncrementCartItem" function. Otherwise the item is inserted as a

new row in the datagrid by calling the "UpdatetblCartItems" function.

I get no errors but I've tried testing the code and it seems to be

failing on the IF DataReader code. I don't think it gets as far as the

IncrementCartItem or UpdatetblCartitems functions - any ideas why,

thanks.....?

Code:

 If DataReader.Read() = true

                'Set datareader values
               intmyCartID = dataReader("intCartID")
                intmyProdID = dataReader("intProductID")
                intmyQuantity = dataReader("intQuantityOrder")

                'Call function to increase quantity by one if 

productID already found in cart
                IncrementCartItem(intmyCartID, intmyProdID, 

intmyQuantity)

                'Otherwise just update cart

                Else 

UpdatetblCartItems(Session("CartID"),Quantity,intProductID,ts)

gbianchi · April 26th, 2007, 12:42 PM

hi there.. which error do you receive?? b/c the code looks ok to me...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

rsm42 · April 27th, 2007, 11:38 AM

Thanks,

No error received. A colleague suggested the SQL statement could be the issue, so here it is :

Dim queryString As String = "SELECT [tblCartItems].[intCartID], [tblCartItems].[intQuantityOrder], [tblCartIte"& _
"ms].[intProductID] FROM [tblCartItems] WHERE [tblCartItems].[intProductID] = @intProductID AND [tblCartItems].[intCartID] = @CartID"

gbianchi · April 27th, 2007, 12:02 PM

still don't know what your problem is.. maybe that sql doesn't return anything????

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========