ExamGuru IT/.Net Guru : NOT ANSWERED code not being executed on ASPFriends.com 'aspngvb' list

.NETGURU

NOT ANSWERED code not being executed

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngvb' list.

Srinivasan P

TO THE MODERATOR,
I HAVE TRIED ASKING THIS IN THE ASPNGVB LIST and also the ASPNGDEBUG LIST. SO KINDLY HELP ME POST IT TO THE APPROPRIATE LIST WHERE I CAN GET A ANSWER.
I have a login page. When the user logs in the, following sub should checks whether the, the User is Valid and if true, sets Session and then checks to see if there is a Shopping Cart for teh User. If The Cart does not exist it should add a new Cart. But the code in red in teh following Sub doesnt seem to execute. The session is being set and it appears the code straightaway jumps to the Redirection Part after that. Below is the Sub for AddCart and the Function CartExists.
I can't find anythign wrogng in teh code.. My eyes have started to pain now....What am I missing??

Regards

Srini

Sub Login(sender as Object, E as EventArgs)

dim ObjUser as New BananaMobile.User

dim ObjBM as New BananaMobile.BananaMobile
dim intID as integer
intID = ObjUser.UserLogin(tbUserName.Text, tbPassword.Text)

if intId<>0 then
Session("UserID") = intID

' Check if User has a cart
if not ObjBM.CartExists(intID) then
ObjBM.AddCart(intID)
end if

FormsAuthentication.RedirectFromLoginPage(intID, false)
else
lblMessage.Text = " Login Failed!"
end if

Public Sub AddCart(UserID as Integer)
Dim objCmd as new SQLCommand("spAddCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim ObjParam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
ObjCmd.ExecuteNonQuery()
ObjConn.Close

Catch ex as Exception
throw ex
End Try

End Sub

'**********************************************************************
' Check to see if a Shopping Cart exists for the User *
'**********************************************************************

public function CartExists(UserID as Integer) as Boolean

dim blnEmpty as Boolean = false

dim ObjCmd as New SQLCommand("spGetCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim Objparam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.Value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
if not ObjCmd.ExecuteScalar is "" then
blnEmpty = true
end if
ObjConn.Close
Catch ex as Exception
throw ex
End try

return blnEmpty
End function

Do not go where the path may lead, go instead where there is no path and leave a trail.
- R W Emerson

Reply to this message...

Byxbee, Race

What does it output when you run this in debug mode? I would assume that if
you set a breakpoint for CartExists that it would execute that function, or
at least try to (What output does it give you for your Boolean values
therein while you are stepping through?). Have you tried running this in
debug mode yet?

Race

-----Original Message-----
From: Srinivasan P [mailto:Click here to reveal e-mail address]
Sent: Wednesday, May 01, 2002 9:54 PM
To: aspngvb
Subject: [aspngvb] NOT ANSWERED code not being executed

TO THE MODERATOR,
I HAVE TRIED ASKING THIS IN THE ASPNGVB LIST and also the ASPNGDEBUG LIST.
SO KINDLY HELP ME POST IT TO THE APPROPRIATE LIST WHERE I CAN GET A ANSWER.
I have a login page. When the user logs in the, following sub should checks
whether the, the User is Valid and if true, sets Session and then checks to
see if there is a Shopping Cart for teh User. If The Cart does not exist it
should add a new Cart. But the code in red in teh following Sub doesnt seem
to execute. The session is being set and it appears the code straightaway
jumps to the Redirection Part after that. Below is the Sub for AddCart and
the Function CartExists.
I can't find anythign wrogng in teh code.. My eyes have started to pain
now....What am I missing??
Regards
Srini
Sub Login(sender as Object, E as EventArgs)
dim ObjUser as New BananaMobile.User
dim ObjBM as New BananaMobile.BananaMobile
dim intID as integer
intID = ObjUser.UserLogin(tbUserName.Text, tbPassword.Text)
if intId<>0 then
Session("UserID") = intID
' Check if User has a cart
if not ObjBM.CartExists(intID) then
ObjBM.AddCart(intID)
end if
FormsAuthentication.RedirectFromLoginPage(intID, false)
else
lblMessage.Text = " Login Failed!"
end if
Public Sub AddCart(UserID as Integer)
Dim objCmd as new SQLCommand("spAddCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim ObjParam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
ObjCmd.ExecuteNonQuery()
ObjConn.Close
Catch ex as Exception
throw ex
End Try
End Sub

'**********************************************************************
' Check to see if a Shopping Cart exists for the User *
'**********************************************************************

public function CartExists(UserID as Integer) as Boolean

dim blnEmpty as Boolean = false

dim ObjCmd as New SQLCommand("spGetCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim Objparam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.Value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
if not ObjCmd.ExecuteScalar is "" then
blnEmpty = true
end if
ObjConn.Close
Catch ex as Exception
throw ex
End try

return blnEmpty
End function
Do not go where the path may lead, go instead where there is no path and
leave a trail.
- R W Emerson
| [aspngvb] member Click here to reveal e-mail address = YOUR ID |
http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT

Reply to this message...

Raj Sharma

I'd put a try catch around any of the statements in this sub which could
be a point of failure. I'd bet you are missing an error, which then
skips the whole red code block.

Regards,
Raj Sharma
Spinneret.co.uk

-----Original Message-----
From: Byxbee, Race [mailto:Click here to reveal e-mail address]
Sent: 02 May 2002 13:58
To: aspngvb
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

What does it output when you run this in debug mode? I would assume that
if you set a breakpoint for CartExists that it would execute that
function, or at least try to (What output does it give you for your
Boolean values therein while you are stepping through?). Have you tried
running this in debug mode yet?

Race

-----Original Message-----
From: Srinivasan P [mailto:Click here to reveal e-mail address]
Sent: Wednesday, May 01, 2002 9:54 PM
To: aspngvb
Subject: [aspngvb] NOT ANSWERED code not being executed

TO THE MODERATOR,
I HAVE TRIED ASKING THIS IN THE ASPNGVB LIST and also the ASPNGDEBUG
LIST. SO KINDLY HELP ME POST IT TO THE APPROPRIATE LIST WHERE I CAN GET
A ANSWER.
I have a login page. When the user logs in the, following sub should
checks whether the, the User is Valid and if true, sets Session and
then checks to see if there is a Shopping Cart for teh User. If The Cart
does not exist it should add a new Cart. But the code in red in teh
following Sub doesnt seem to execute. The session is being set and it
appears the code straightaway jumps to the Redirection Part after that.
Below is the Sub for AddCart and the Function CartExists.
I can't find anythign wrogng in teh code.. My eyes have started to pain
now....What am I missing??
Regards
Srini
Sub Login(sender as Object, E as EventArgs)
dim ObjUser as New BananaMobile.User
dim ObjBM as New BananaMobile.BananaMobile
dim intID as integer
intID = ObjUser.UserLogin(tbUserName.Text, tbPassword.Text)
if intId<>0 then
Session("UserID") = intID
' Check if User has a cart
if not ObjBM.CartExists(intID) then
ObjBM.AddCart(intID)
end if
FormsAuthentication.RedirectFromLoginPage(intID, false)
else
lblMessage.Text = " Login Failed!"
end if
Public Sub AddCart(UserID as Integer)
Dim objCmd as new SQLCommand("spAddCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim ObjParam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
ObjCmd.ExecuteNonQuery()
ObjConn.Close
Catch ex as Exception
throw ex
End Try
End Sub

'**********************************************************************
' Check to see if a Shopping Cart exists for the User *

'**********************************************************************

public function CartExists(UserID as Integer) as Boolean

dim blnEmpty as Boolean = false

dim ObjCmd as New SQLCommand("spGetCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim Objparam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.Value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
if not ObjCmd.ExecuteScalar is "" then
blnEmpty = true
end if
ObjConn.Close
Catch ex as Exception
throw ex
End try

return blnEmpty
End function
Do not go where the path may lead, go instead where there is no path and
leave a trail.
- R W Emerson
| [aspngvb] member Click here to reveal e-mail address = YOUR ID |
http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT
| [aspngvb] member Click here to reveal e-mail address = YOUR ID |
http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT

Reply to this message...

Srini

Well, how do I run that debug mode. I am total novice to ASP.Net and I dont have the luxury of VS.Net. I am just using plain old notepad. The major part of the code was taken from the book TYASPNET in 21 Days by SAMS. The code in the boook uses Access, while I am using SQL.

Regards
Srini
----- Original Message -----
From: Byxbee, Race
To: aspngvb
Sent: Thursday, May 02, 2002 6:27 PM
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

What does it output when you run this in debug mode? I would assume that if you set a breakpoint for CartExists that it would execute that function, or at least try to (What output does it give you for your Boolean values therein while you are stepping through?). Have you tried running this in debug mode yet?

Race

-----Original Message-----
From: Srinivasan P [mailto:Click here to reveal e-mail address]
Sent: Wednesday, May 01, 2002 9:54 PM
To: aspngvb
Subject: [aspngvb] NOT ANSWERED code not being executed

TO THE MODERATOR,

I HAVE TRIED ASKING THIS IN THE ASPNGVB LIST and also the ASPNGDEBUG LIST. SO KINDLY HELP ME POST IT TO THE APPROPRIATE LIST WHERE I CAN GET A ANSWER.

I have a login page. When the user logs in the, following sub should checks whether the, the User is Valid and if true, sets Session and then checks to see if there is a Shopping Cart for teh User. If The Cart does not exist it should add a new Cart. But the code in red in teh following Sub doesnt seem to execute. The session is being set and it appears the code straightaway jumps to the Redirection Part after that. Below is the Sub for AddCart and the Function CartExists.

I can't find anythign wrogng in teh code.. My eyes have started to pain now....What am I missing??

Regards

Srini

Sub Login(sender as Object, E as EventArgs)

dim ObjUser as New BananaMobile.User

dim ObjBM as New BananaMobile.BananaMobile
dim intID as integer
intID = ObjUser.UserLogin(tbUserName.Text, tbPassword.Text)

if intId<>0 then
Session("UserID") = intID

' Check if User has a cart
if not ObjBM.CartExists(intID) then
ObjBM.AddCart(intID)
end if

FormsAuthentication.RedirectFromLoginPage(intID, false)
else
lblMessage.Text = " Login Failed!"
end if

Public Sub AddCart(UserID as Integer)
Dim objCmd as new SQLCommand("spAddCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim ObjParam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
ObjCmd.ExecuteNonQuery()
ObjConn.Close

Catch ex as Exception
throw ex
End Try

End Sub

'**********************************************************************
' Check to see if a Shopping Cart exists for the User *
'**********************************************************************

public function CartExists(UserID as Integer) as Boolean

dim blnEmpty as Boolean = false

dim ObjCmd as New SQLCommand("spGetCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim Objparam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.Value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
if not ObjCmd.ExecuteScalar is "" then
blnEmpty = true
end if
ObjConn.Close
Catch ex as Exception
throw ex
End try

return blnEmpty
End function

Do not go where the path may lead, go instead where there is no path and leave a trail.
- R W Emerson

| [aspngvb] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT

| [aspngvb] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT

Reply to this message...

Byxbee, Race

Well, if you aren't using VS.NET then I'm not sure that you can use
debugging, or at least I don't know how in the world you could implement it
with a notepad/command line environment.

Anyway, the other email's suggestion is probably the way to go then. If you
wrap your cart section in a try/catch chunk of code you could spit out the
exception since it more than likely is throwing one. Try that and let us
know.

Race

-----Original Message-----
From: Srini [mailto:Click here to reveal e-mail address]
Sent: Thursday, May 02, 2002 10:19 AM
To: aspngvb
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

Well, how do I run that debug mode. I am total novice to ASP.Net and I dont
have the luxury of VS.Net. I am just using plain old notepad. The major part
of the code was taken from the book TYASPNET in 21 Days by SAMS. The code in
the boook uses Access, while I am using SQL.

Regards
Srini
----- Original Message -----

From: Byxbee, Race <mailto:Click here to reveal e-mail address>
To: aspngvb <mailto:Click here to reveal e-mail address>
Sent: Thursday, May 02, 2002 6:27 PM
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

What does it output when you run this in debug mode? I would assume that if
you set a breakpoint for CartExists that it would execute that function, or
at least try to (What output does it give you for your Boolean values
therein while you are stepping through?). Have you tried running this in
debug mode yet?

Race

-----Original Message-----
From: Srinivasan P [mailto:Click here to reveal e-mail address]
Sent: Wednesday, May 01, 2002 9:54 PM
To: aspngvb
Subject: [aspngvb] NOT ANSWERED code not being executed

TO THE MODERATOR,
I HAVE TRIED ASKING THIS IN THE ASPNGVB LIST and also the ASPNGDEBUG LIST.
SO KINDLY HELP ME POST IT TO THE APPROPRIATE LIST WHERE I CAN GET A ANSWER.
I have a login page. When the user logs in the, following sub should checks
whether the, the User is Valid and if true, sets Session and then checks to
see if there is a Shopping Cart for teh User. If The Cart does not exist it
should add a new Cart. But the code in red in teh following Sub doesnt seem
to execute. The session is being set and it appears the code straightaway
jumps to the Redirection Part after that. Below is the Sub for AddCart and
the Function CartExists.
I can't find anythign wrogng in teh code.. My eyes have started to pain
now....What am I missing??
Regards
Srini
Sub Login(sender as Object, E as EventArgs)
dim ObjUser as New BananaMobile.User
dim ObjBM as New BananaMobile.BananaMobile
dim intID as integer
intID = ObjUser.UserLogin(tbUserName.Text, tbPassword.Text)
if intId<>0 then
Session("UserID") = intID
' Check if User has a cart
if not ObjBM.CartExists(intID) then
ObjBM.AddCart(intID)
end if
FormsAuthentication.RedirectFromLoginPage(intID, false)
else
lblMessage.Text = " Login Failed!"
end if
Public Sub AddCart(UserID as Integer)
Dim objCmd as new SQLCommand("spAddCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim ObjParam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
ObjCmd.ExecuteNonQuery()
ObjConn.Close
Catch ex as Exception
throw ex
End Try
End Sub

'**********************************************************************
' Check to see if a Shopping Cart exists for the User *
'**********************************************************************

public function CartExists(UserID as Integer) as Boolean

dim blnEmpty as Boolean = false

dim ObjCmd as New SQLCommand("spGetCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim Objparam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.Value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
if not ObjCmd.ExecuteScalar is "" then
blnEmpty = true
end if
ObjConn.Close
Catch ex as Exception
throw ex
End try

return blnEmpty
End function
Do not go where the path may lead, go instead where there is no path and
leave a trail.
- R W Emerson
| [aspngvb] member Click here to reveal e-mail address = YOUR ID |
http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT
| [aspngvb] member Click here to reveal e-mail address = YOUR ID |
http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT
| [aspngvb] member Click here to reveal e-mail address = YOUR ID |
http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT

Reply to this message...

Jeff Prevost

You should be able to use the DbgCLR.exe application. It is located in the GuiDebug folder under where .NET was installed. It's pretty easy to use. You fire up your app (compiled with debug symbols) then attach your app process into the DbgCLR program. Open up your code page, set a break point then continue to run your program. You step the code the same way you do in VS.NET.
-----Original Message-----
From: Byxbee, Race [mailto:Click here to reveal e-mail address]
Sent: Thursday, May 02, 2002 11:46 AM
To: aspngvb
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

Well, if you aren't using VS.NET then I'm not sure that you can use debugging, or at least I don't know how in the world you could implement it with a notepad/command line environment.

Anyway, the other email's suggestion is probably the way to go then. If you wrap your cart section in a try/catch chunk of code you could spit out the exception since it more than likely is throwing one. Try that and let us know.

Race

-----Original Message-----
From: Srini [mailto:Click here to reveal e-mail address]
Sent: Thursday, May 02, 2002 10:19 AM
To: aspngvb
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

Well, how do I run that debug mode. I am total novice to ASP.Net and I dont have the luxury of VS.Net. I am just using plain old notepad. The major part of the code was taken from the book TYASPNET in 21 Days by SAMS. The code in the boook uses Access, while I am using SQL.

Regards
Srini
----- Original Message -----

From: Byxbee, Race <mailto:Click here to reveal e-mail address>

To: aspngvb <mailto:Click here to reveal e-mail address>
Sent: Thursday, May 02, 2002 6:27 PM
Subject: [aspngvb] RE: NOT ANSWERED code not being executed

What does it output when you run this in debug mode? I would assume that if you set a breakpoint for CartExists that it would execute that function, or at least try to (What output does it give you for your Boolean values therein while you are stepping through?). Have you tried running this in debug mode yet?

Race

-----Original Message-----
From: Srinivasan P [mailto:Click here to reveal e-mail address]
Sent: Wednesday, May 01, 2002 9:54 PM
To: aspngvb
Subject: [aspngvb] NOT ANSWERED code not being executed

TO THE MODERATOR,
I HAVE TRIED ASKING THIS IN THE ASPNGVB LIST and also the ASPNGDEBUG LIST. SO KINDLY HELP ME POST IT TO THE APPROPRIATE LIST WHERE I CAN GET A ANSWER.
I have a login page. When the user logs in the, following sub should checks whether the, the User is Valid and if true, sets Session and then checks to see if there is a Shopping Cart for teh User. If The Cart does not exist it should add a new Cart. But the code in red in teh following Sub doesnt seem to execute. The session is being set and it appears the code straightaway jumps to the Redirection Part after that. Below is the Sub for AddCart and the Function CartExists.
I can't find anythign wrogng in teh code.. My eyes have started to pain now....What am I missing??
Regards
Srini
Sub Login(sender as Object, E as EventArgs)
dim ObjUser as New BananaMobile.User
dim ObjBM as New BananaMobile.BananaMobile
dim intID as integer
intID = ObjUser.UserLogin(tbUserName.Text, tbPassword.Text)
if intId<>0 then
Session("UserID") = intID
' Check if User has a cart
if not ObjBM.CartExists(intID) then
ObjBM.AddCart(intID)
end if
FormsAuthentication.RedirectFromLoginPage(intID, false)
else
lblMessage.Text = " Login Failed!"
end if
Public Sub AddCart(UserID as Integer)
Dim objCmd as new SQLCommand("spAddCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim ObjParam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
ObjCmd.ExecuteNonQuery()
ObjConn.Close
Catch ex as Exception
throw ex
End Try
End Sub

'**********************************************************************
' Check to see if a Shopping Cart exists for the User *
'**********************************************************************

public function CartExists(UserID as Integer) as Boolean

dim blnEmpty as Boolean = false

dim ObjCmd as New SQLCommand("spGetCart", ObjConn)
ObjCmd.CommandType = CommandType.StoredProcedure

dim Objparam as new SQLParameter("@UserID", SQLDBType.Int)
ObjParam.Value = UserID
ObjCmd.Parameters.Add(ObjParam)

Try
ObjConn.Open
if not ObjCmd.ExecuteScalar is "" then
blnEmpty = true
end if
ObjConn.Close
Catch ex as Exception
throw ex
End try

return blnEmpty
End function
Do not go where the path may lead, go instead where there is no path and leave a trail.
- R W Emerson
| [aspngvb] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT
| [aspngvb] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT
| [aspngvb] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT
| [aspngvb] member Click here to reveal e-mail address = YOUR ID | http://www.asplists.com/asplists/aspngvb.asp = JOIN/QUIT

Reply to this message...

	System.Data.CommandType
	System.EventArgs
	System.Web.Security.FormsAuthentication

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification