object reference not set to an instance???

**CMM** · Feb 24 '06, 04:35 AM

Re: object reference not set to an instance???

.... To TicketOrder.Tic ketQty - 1
Perhaps?
Considering your For loop starts at 0.

--
-C. Moya

CM's Home Page

https://www.cmoya.com

<labelle@gmail. com> wrote in message
news:1140754127 .353216.117000@ z34g2000cwc.goo glegroups.com.. .[color=blue]
> this is driving me nuts, and i can't figure it out: i am creating a
> mapper that updates two tables at the same time, one with "ticket
> order" information, and the other with "ticket" information. for
> example, if someone orders 2 tickets, 1 order is placed into the order
> table, and 2 tickets are placed into the tickets table.
>
> however, nothing is working out.
>
> Public Sub AddTicketOrders (ByVal TicketOrder As TicketRequest)
> Dim parameters As New ArrayList
> parameters.Add( (New SqlParameter("@ ticketName",
> TicketOrder.Tic ketName)))
> parameters.Add( (New SqlParameter("@ ticketStreet",
> TicketOrder.Tic ketStreet)))
> parameters.Add( (New SqlParameter("@ ticketCity",
> TicketOrder.Tic ketCity)))
> parameters.Add( (New SqlParameter("@ ticketState",
> TicketOrder.Tic ketState)))
> parameters.Add( (New SqlParameter("@ ticketZip",
> TicketOrder.Tic ketZip)))
> parameters.Add( (New SqlParameter("@ ticketCountry",
> TicketOrder.Tic ketCountry)))
> parameters.Add( (New SqlParameter("@ ticketPhone",
> TicketOrder.Tic ketPhone)))
> parameters.Add( (New SqlParameter("@ ticketFax",
> TicketOrder.Tic ketFax)))
> parameters.Add( (New SqlParameter("@ ticketEmail",
> TicketOrder.Tic ketEmail)))
> parameters.Add( (New SqlParameter("@ ticketQty",
> TicketOrder.Tic ketQty)))
> parameters.Add( (New SqlParameter("@ ticketConfirmKe y",
> TicketOrder.Tic ketConfirmKey)) )
> parameters.Add( (New SqlParameter("@ ticketConfirm",
> TicketOrder.Tic ketConfirm)))
> RunStoredProc(" dbo.AddTicketRe quest", parameters)
>
> Dim tmpTicket As OrderedTicket
> Dim ticketParams As New ArrayList
> Dim i As Integer = 0
> For i = 0 To TicketOrder.Tic ketQty
> ticketParams.Ad d((New SqlParameter("@ orderID",
> tmpTicket.Order ID)))
> ticketParams.Ad d((New SqlParameter("@ ticketID",
> tmpTicket.Ticke tID)))
> RunStoredProc(" dbo.AddTicket", ticketParams)
> Next
> End Sub
>
> however, i keep getting an "Object reference not set to an instance of
> an object" error. It's been driving me nuts all night. Can someone
> please tell me what i'm doing wrong? I'm sure it's something plain as
> day.
>
> And before you ask, yes...TicketOrd er.TicketQty is declared as an
> integer.
>[/color]

**Stephany Young** · Feb 24 '06, 04:55 AM

Re: object reference not set to an instance???

Firstly, tmpTicket is never being instantiated. It would appear that you
mean to assign something to tmpTicket at the start of each iteration of the
loop.

Secondly, in your example of 1 order, 2 tickets, do you expect
TicketOrder.Tic ketQty to have the value 1 or 2?

If it is the former then your loop controller is correct (0 To 1 = 2
iterations).

If it is the latter then your loop controller is incorrect (0 To 3 = 3
iterations) and the loop should either be 0 To TicketOrder.Tic ketQty - 1 or
it should be 1 To TicketOrder.Tic ketQty.

<labelle@gmail. com> wrote in message
news:1140754127 .353216.117000@ z34g2000cwc.goo glegroups.com.. .[color=blue]
> this is driving me nuts, and i can't figure it out: i am creating a
> mapper that updates two tables at the same time, one with "ticket
> order" information, and the other with "ticket" information. for
> example, if someone orders 2 tickets, 1 order is placed into the order
> table, and 2 tickets are placed into the tickets table.
>
> however, nothing is working out.
>
> Public Sub AddTicketOrders (ByVal TicketOrder As TicketRequest)
> Dim parameters As New ArrayList
> parameters.Add( (New SqlParameter("@ ticketName",
> TicketOrder.Tic ketName)))
> parameters.Add( (New SqlParameter("@ ticketStreet",
> TicketOrder.Tic ketStreet)))
> parameters.Add( (New SqlParameter("@ ticketCity",
> TicketOrder.Tic ketCity)))
> parameters.Add( (New SqlParameter("@ ticketState",
> TicketOrder.Tic ketState)))
> parameters.Add( (New SqlParameter("@ ticketZip",
> TicketOrder.Tic ketZip)))
> parameters.Add( (New SqlParameter("@ ticketCountry",
> TicketOrder.Tic ketCountry)))
> parameters.Add( (New SqlParameter("@ ticketPhone",
> TicketOrder.Tic ketPhone)))
> parameters.Add( (New SqlParameter("@ ticketFax",
> TicketOrder.Tic ketFax)))
> parameters.Add( (New SqlParameter("@ ticketEmail",
> TicketOrder.Tic ketEmail)))
> parameters.Add( (New SqlParameter("@ ticketQty",
> TicketOrder.Tic ketQty)))
> parameters.Add( (New SqlParameter("@ ticketConfirmKe y",
> TicketOrder.Tic ketConfirmKey)) )
> parameters.Add( (New SqlParameter("@ ticketConfirm",
> TicketOrder.Tic ketConfirm)))
> RunStoredProc(" dbo.AddTicketRe quest", parameters)
>
> Dim tmpTicket As OrderedTicket
> Dim ticketParams As New ArrayList
> Dim i As Integer = 0
> For i = 0 To TicketOrder.Tic ketQty
> ticketParams.Ad d((New SqlParameter("@ orderID",
> tmpTicket.Order ID)))
> ticketParams.Ad d((New SqlParameter("@ ticketID",
> tmpTicket.Ticke tID)))
> RunStoredProc(" dbo.AddTicket", ticketParams)
> Next
> End Sub
>
> however, i keep getting an "Object reference not set to an instance of
> an object" error. It's been driving me nuts all night. Can someone
> please tell me what i'm doing wrong? I'm sure it's something plain as
> day.
>
> And before you ask, yes...TicketOrd er.TicketQty is declared as an
> integer.
>[/color]

**Sumit** · Feb 24 '06, 05:15 AM

Re: object reference not set to an instance???

Hi all,
I would like to know all about the property EnableView state
in .Net. I also want to know about the Session creation in the asp.net.

**CMM** · Feb 24 '06, 05:25 AM

Re: object reference not set to an instance???

Do a google search. Get a good book.
I recommend the ASP.NET Core Reference Book from Microsoft.

--
-C. Moya

CM's Home Page

https://www.cmoya.com

**labelle@gmail.com** · Feb 24 '06, 05:05 PM

Re: object reference not set to an instance???

A friend told me the reason why is because i need to write the first
set of parameters to the database, then read them, then write them to
the second table.
I have absolutely no idea on how to do this, but I am guessing, I need
to declare my connection, give the command to read from the first
table...but i'm stumped?

How would I make the ticket orderID equal the total orderID?

tmpTicket.Order ID = ticketOrder.Ord erID just won't work.

Dim cn As New SqlClient.SqlCo nnection("my connection")
Dim cmd As New SqlCommand("SEL ECT TOP 1 orderID FROM
dbo.TicketOrder s ORDER BY orderID DESC")

Dim tmpTicket As OrderedTicket
Dim ticketParams As New ArrayList
Dim i As Integer = 0
For i = 0 To TicketOrder.Tic ketQty
ticketParams.Ad d((New SqlParameter("@ orderID",
tmpTicket.Order ID)))
ticketParams.Ad d((New SqlParameter("@ ticketID",
tmpTicket.Ticke tID)))
RunStoredProc(" dbo.AddTicket", ticketParams)

object reference not set to an instance???

object reference not set to an instance???

Comment

Comment

Comment

Comment

Comment