ASP.NET easy newby question

[Ryan Smith]

I am trying to store a string into a string variable via the following code
however am receiving an error and cant figure out what i am doing wrong. Any
feedback is greatly appreciated.
Line 49: Private Sub Button1_Click(B yVal sender As System.Object, ByVal
e As System.EventArg s) Handles Button1.Click
Line 50:
Line 51: Dim strSQL As String = "INSERT INTO Investors
(FNAME,LNAME,EM AIL,ADDRESS1,AD DRESS2," & _
Line 52:
"CITY,STATE,ZIP ,PNUMBER,ANUMBE R,ATYPE,BESTTIM E,INT_PRICERANG E1," & _
Line 53:
"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _

[Tor Bådshaug]

Well, if your code terminates like this (line 53) it is no wonder you get an
error. By using "& _" the compiler will expect another line of code. Your
code suggests there actually exists a line 54, but somehow it fell out? Post
your line 54 onwards and I will try to help.

Tor Bådshaug
tor.badshaug [//at\\] bekk.no.

Line 53:
"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _

[Jeff Dillon]

As always, get simple code working first.

Jeff

"Ryan Smith" <Ry*******@disc ussions.microso ft.com> wrote in message
news:AB******** *************** ***********@mic rosoft.com...

I am trying to store a string into a string variable via the following code however am receiving an error and cant figure out what i am doing wrong. Any feedback is greatly appreciated.
Line 49: Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles Button1.Click
Line 50:
Line 51: Dim strSQL As String = "INSERT INTO Investors
(FNAME,LNAME,EM AIL,ADDRESS1,AD DRESS2," & _
Line 52:
"CITY,STATE,ZIP ,PNUMBER,ANUMBE R,ATYPE,BESTTIM E,INT_PRICERANG E1," & _
Line 53:
"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _

[Ryan Smith]

Here is all of the code:

Dim strSQL As String = "INSERT INTO Investors
(FNAME,LNAME,EM AIL,ADDRESS1,AD DRESS2," & _

"CITY,STATE,ZIP ,PNUMBER,ANUMBE R,ATYPE,BESTTIM E,INT_PRICERANG E1," & _

"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _
FNAME.Text & "','" & _
LNAME.Text & "','" & _
EMAIL.Text & "','" & _
ADDRESS.Text & "','" & _
ADDRESS1.Text & "','" & _
CITY.Text & "','" & _
dState.Selected Item.Text & "','" & _
ZIP.Text & "','" & _
PNUMBER.Text & "','" & _
ANUMBER.Text & "','" & _
AType.SelectedI tem.Text & "','" & _
BESTTIME.Select edItem.Text & "','" & _
INT_PRICERANGE1 .Text & "," & _
INT_PRICERANGE2 .Text & "," & _
INT_LOCATION.Te xt & "','" & _
INT_WHEN.Text & "','" & _
PRODUCTS.Text & "')"

"Tor BÃ¥dshaug" wrote:

Well, if your code terminates like this (line 53) it is no wonder you get an
error. By using "& _" the compiler will expect another line of code. Your
code suggests there actually exists a line 54, but somehow it fell out? Post
your line 54 onwards and I will try to help.

Tor BÃ¥dshaug
tor.badshaug [//at\\] bekk.no.

Line 53:
"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _

[Tor Bådshaug]

And what is the error message you get? Compile error or runtime error?

Tor Bådshaug
tor.badshaug [//at\\] bekk.no.

....

Here is all of the code:

[Ryan Smith]

The error says Server Error in '/WebApp' Application

Object reference not set to an instance of an object
Exception Details: System.NullRefe renceException: Object reference not set
to an instance of an object

It's like it has an issue with setting the string to the variable.... i'm
stumped!

"Ryan Smith" wrote:

Here is all of the code:

Dim strSQL As String = "INSERT INTO Investors
(FNAME,LNAME,EM AIL,ADDRESS1,AD DRESS2," & _

"CITY,STATE,ZIP ,PNUMBER,ANUMBE R,ATYPE,BESTTIM E,INT_PRICERANG E1," & _

"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _
FNAME.Text & "','" & _
LNAME.Text & "','" & _
EMAIL.Text & "','" & _
ADDRESS.Text & "','" & _
ADDRESS1.Text & "','" & _
CITY.Text & "','" & _
dState.Selected Item.Text & "','" & _
ZIP.Text & "','" & _
PNUMBER.Text & "','" & _
ANUMBER.Text & "','" & _
AType.SelectedI tem.Text & "','" & _
BESTTIME.Select edItem.Text & "','" & _
INT_PRICERANGE1 .Text & "," & _
INT_PRICERANGE2 .Text & "," & _
INT_LOCATION.Te xt & "','" & _
INT_WHEN.Text & "','" & _
PRODUCTS.Text & "')"

"Tor BÃ¥dshaug" wrote:

Well, if your code terminates like this (line 53) it is no wonder you get an
error. By using "& _" the compiler will expect another line of code. Your
code suggests there actually exists a line 54, but somehow it fell out? Post
your line 54 onwards and I will try to help.

Tor BÃ¥dshaug
tor.badshaug [//at\\] bekk.no.

Line 53:
"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _

[Kevin Spencer]

If that is the code which threw the exception, and it is all one statement,
concatenating a bunch of strings together, then one of the references in the
code to an object must be a reference to an object that is null, Nothing, or
not initialized (the same meaning for all 3). Let's take it a step at a
time, so that next time you won't have to ask. First, you are concatenating
string literals, so that's not a problem. Second, you're adding in the Text
property of a number of form elements. As the Text property is always a
string, if only a blank string, that's not a problem either. Finally, you
are referencing the "SelectedIt em" property of several listboxes. As this
property is initialized to null (Nothing), unless something changed the
SelectedItem, the exception would be thrown there.

Chances are, you can fix this by setting the SelectedItem property when you
initialize the ListBoxes.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Ryan Smith" <Ry*******@disc ussions.microso ft.com> wrote in message
news:E2******** *************** ***********@mic rosoft.com...

The error says Server Error in '/WebApp' Application

Object reference not set to an instance of an object
Exception Details: System.NullRefe renceException: Object reference not set to an instance of an object

It's like it has an issue with setting the string to the variable.... i'm
stumped!

"Ryan Smith" wrote:

Here is all of the code:

Dim strSQL As String = "INSERT INTO Investors
(FNAME,LNAME,EM AIL,ADDRESS1,AD DRESS2," & _

"CITY,STATE,ZIP ,PNUMBER,ANUMBE R,ATYPE,BESTTIM E,INT_PRICERANG E1," & _

"INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _ FNAME.Text & "','" & _
LNAME.Text & "','" & _
EMAIL.Text & "','" & _
ADDRESS.Text & "','" & _
ADDRESS1.Text & "','" & _
CITY.Text & "','" & _
dState.Selected Item.Text & "','" & _
ZIP.Text & "','" & _
PNUMBER.Text & "','" & _
ANUMBER.Text & "','" & _
AType.SelectedI tem.Text & "','" & _
BESTTIME.Select edItem.Text & "','" & _
INT_PRICERANGE1 .Text & "," & _
INT_PRICERANGE2 .Text & "," & _
INT_LOCATION.Te xt & "','" & _
INT_WHEN.Text & "','" & _
PRODUCTS.Text & "')"

"Tor Bådshaug" wrote:

Well, if your code terminates like this (line 53) it is no wonder you get an error. By using "& _" the compiler will expect another line of code. Your code suggests there actually exists a line 54, but somehow it fell out? Post your line 54 onwards and I will try to help.

Tor Bådshaug
tor.badshaug [//at\\] bekk.no.

> Line 53:
> "INT_PRICERANGE 2,INT_LOCATION, INT_WHEN,PRODUC TS_PURCHASED) VALUES ('" & _ >
>