Update_Customer not working

[Sparky Arbuckle]

My TRY CATCH shows Error when I run this. Can anyone see what's wrong
with this? Each textbox has OnTextChanged="ConChanged". This changed
boolean to TRUE and then Updates the customer.

Sub Update_Customer()

Dim strText as string

Dim strSQL as string = "UPDATE tblCustomers SET " & _
"(strEmail, strFName, strLName, strStreet, strCity, strState,
strZip) VALUES (" & _
"'" & tbEmail.text & "'," & _
"'" & tbFName.text & "'," & _
"'" & tbLName.text & "'," & _
"'" & tbStreet.text & "'," & _
"'" & tbCity.text & "'," & _
"'" & tbState.text & "'," & _
"'" & tbZip.text & "');"

'Dim strSQL as string = "UPDATE tblCustomers SET strEmail = '" &
tbEmail.text & "', strFName = '" & tbFName.text & "', " & _
' "strLName = '" & tbLName.text & "', strStreet =
'" & tbStreet.text & "', strCity = '" & tbCity.text & "', " & _
' "strState = '" & tbState.text & "', strZip = '"
& tbZip.text & "' WHERE CustID = " & ViewState("CustID") & ";"
TRY

Dim objConnection as New OLEDBConnection(myConnection)
Dim objCmd as New OLEDBCommand(strSQL, objConnection)
objCmd.Connection.Open()
objCmd.ExecuteNonQuery

Response.redirect("CheckOut.aspx?order=ASDF")
objCmd.Connection.Close()

Catch objError as Exception
Response.Write("Error")
END TRY

AddMe.Visible = FALSE
Success.Visible = TRUE
END Sub

[Sparky Arbuckle]

Even the strSQL that I have commented out doesn't work. I can't figure
this out for the life of me!

[Ken Dopierala Jr.]

Hi,

Could you set a break point on:

Response.Write("Error")

And then tell us what objError.Message says. From there we should be able
to figure this out. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

My TRY CATCH shows Error when I run this. Can anyone see what's wrong
with this? Each textbox has OnTextChanged="ConChanged". This changed
boolean to TRUE and then Updates the customer.

Sub Update_Customer()

Dim strText as string

Dim strSQL as string = "UPDATE tblCustomers SET " & _
"(strEmail, strFName, strLName, strStreet, strCity, strState,
strZip) VALUES (" & _
"'" & tbEmail.text & "'," & _
"'" & tbFName.text & "'," & _
"'" & tbLName.text & "'," & _
"'" & tbStreet.text & "'," & _
"'" & tbCity.text & "'," & _
"'" & tbState.text & "'," & _
"'" & tbZip.text & "');"

'Dim strSQL as string = "UPDATE tblCustomers SET strEmail = '" &
tbEmail.text & "', strFName = '" & tbFName.text & "', " & _
' "strLName = '" & tbLName.text & "', strStreet =
'" & tbStreet.text & "', strCity = '" & tbCity.text & "', " & _
' "strState = '" & tbState.text & "', strZip = '"
& tbZip.text & "' WHERE CustID = " & ViewState("CustID") & ";"
TRY

Dim objConnection as New OLEDBConnection(myConnection)
Dim objCmd as New OLEDBCommand(strSQL, objConnection)
objCmd.Connection.Open()
objCmd.ExecuteNonQuery

Response.redirect("CheckOut.aspx?order=ASDF")
objCmd.Connection.Close()

Catch objError as Exception
Response.Write("Error")
END TRY

AddMe.Visible = FALSE
Success.Visible = TRUE
END Sub

[Sparky Arbuckle]

What is a breakpoint?

[Patrick Olurotimi Ige]

Sparky ,
Are you using VS.NET?
Break point is under the Menu "Debug" .

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ken Dopierala Jr.]

Hi,

A breakpoint halts execution and let's you step through your code line by
line so you can check values. If you are using VS.Net you can just click to
the left of the Response.Write("Error") line and it will set a breakpoint.
Alternatively change:

Response.Write("Error")

To

Response.Write(objError.Message)

Then run your code. This will print out the error message you are receiving
and that error message should tell us pretty specifically why your code is
erroring out. Actually put the line below there instead and we should be
able to figure this out even faster:

Response.Write("Error Message: " + objError.Message + " - SQL: " +
strSQL)

This will now print out the error message and the SQL that you are using.
It should put it write in your browser when you run the app so you'll just
need to copy and paste it into your response. Good luck! Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

What is a breakpoint?