Error when trying to cast db query to string

Question

I am trying to extract one integer from the database but am getting errors

My code in the controller is:

        Dim SeqNumQuery = From a In db.RequestedServices
                          Where a.RequestedServiceId = id
                          Select a.StationId

        Dim StationId As Integer = SeqNumQuery.ToString

And error is:

Range variable 'StationId' hides a variable in an enclosing block or a range variable previously defined in the query expression.

Why are you comverting StationId to string and assigning it to an integer variable? — Brendan Vogt
– Brendan Vogt, Commented Aug 15, 2012 at 13:40

Curtis · Accepted Answer · 2012-08-15 13:41:09Z

I think the issue is that your variable, StationId, is being declared somewhere already within the same scope. Try changing to:

Dim SeqNumQuery = From a In db.RequestedServices
                          Where a.RequestedServiceId = id
                          Select a.StationId

StationId = SeqNumQuery.ToString

But look into what the other variable is being used for. If you need it, use something other than StationId for your variable name, for example RequestedServicesStationId.

More information regarding this error:

Range variable hides a variable in an enclosing block or a range variable previously defined in the query expression.

On a side note, I don't understand why you are using .ToString extension method. This won't cause your script to throw an exception, however I would recommend changing this to CInt():

StationId = CInt(SeqNumQuery)

Collectives™ on Stack Overflow

Error when trying to cast db query to string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related