Does anyone see my mistake?

[Leon]

Does anyone see my mistake? I'm trying to load the school dropdownlist when
the user select a state from the state dropdownlist. The states drop down
list loads, but the school drop down list donot.

****Database Object Class.......... ..............

' Methods
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -

Public Function GetStateList() As DataSet
Return RunProcedure( _
"GetState", New IDataParameter( ) {}, "States")
End Function

Public Function GetSchoolByStat eList(ByVal StateID As String) As
DataSet
Dim parameters As SqlParameter() = { _
New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
parameters(0).V alue = StateID
Return RunProcedure( _
"GetSchoolBySta te", New IDataParameter( ) {}, "SchoolByState" )
End Function

****Business Object Class.......... ..............

' Private variables
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
Private Shared myStateID As String

' Methods
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -

Public Shared Function GetStates() As DataSet

Dim tool As New StuLotto.Accoun ts.Data.Account sTool

Return tool.GetStateLi st

End Function

Public Shared Function GetSchoolByStat e() As DataSet

Dim tool As New StuLotto.Accoun ts.Data.Account sTool

Return tool.GetSchoolB yStateList(mySt ateID)

' Properties
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- -
Public Shared Property StateID() As String
Get
Return myStateID
End Get
Set(ByVal value As String)
myStateID = value
End Set
End Property

End Class

End Function

****.aspx Codebehind page........... ............... .

' Bind the state drop-down combobox
Dim States As New DataSet
States = Accounts.Busine ss.AccountsTool .GetStates
SStateDDL.DataS ource = States
SStateDDL.DataT extField = "Descriptio n"
SStateDDL.DataV alueField = "StateID"
SStateDDL.DataB ind()

' Bind the school by selected state drop-down combobox
Private Sub SStateDDL_Selec tedIndexChanged (ByVal sender As
System.Object, ByVal e As System.EventArg s) Handles
SStateDDL.Selec tedIndexChanged
Dim Schools As New DataSet
Dim Value As String = _
Accounts.Busine ss.AccountsTool .StateID =
SStateDDL.Selec tedItem.Value
Schools = Accounts.Busine ss.AccountsTool .GetSchoolBySta te
SNameDDL.DataSo urce = Schools
SNameDDL.DataTe xtField = "SchoolName "
SNameDDL.DataVa lueField = "SchoolID"
SNameDDL.DataBi nd()
End Sub

[David Browne]

"Leon" <vn*****@msn.co m> wrote in message
news:OD******** ******@TK2MSFTN GP11.phx.gbl...

Does anyone see my mistake? I'm trying to load the school dropdownlist
when the user select a state from the state dropdownlist. The states drop
down list loads, but the school drop down list donot.

****Database Object Class.......... ..............

' Methods
'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -

You are not passing the @StateID parameter into RunProcedure.

Shouldn't this be

Public Function GetSchoolByStat eList(ByVal StateID As String) As
DataSet
Dim parameters As SqlParameter() = { _
New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
parameters(0).V alue = StateID
Return RunProcedure( _
"GetSchoolBySta te", parameters, "SchoolByState" )
End Function

?

David

[Leon]

Thanks for you response!
yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
"SchoolByState" )" you are right do you see any more errors?

"David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in
message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...

"Leon" <vn*****@msn.co m> wrote in message
news:OD******** ******@TK2MSFTN GP11.phx.gbl...

Does anyone see my mistake? I'm trying to load the school dropdownlist
when the user select a state from the state dropdownlist. The states drop
down list loads, but the school drop down list donot.

****Database Object Class.......... ..............

' Methods

'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - -

You are not passing the @StateID parameter into RunProcedure.

Shouldn't this be

Public Function GetSchoolByStat eList(ByVal StateID As String) As
DataSet
Dim parameters As SqlParameter() = { _
New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
parameters(0).V alue = StateID
Return RunProcedure( _
"GetSchoolBySta te", parameters, "SchoolByState" )
End Function

?

David

[Jeff Dillon]

Are you able to run this in the debugger?

Jeff

"Leon" <vn*****@msn.co m> wrote in message
news:#1******** ******@TK2MSFTN GP14.phx.gbl...

Thanks for you response!
yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
"SchoolByState" )" you are right do you see any more errors?

"David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in
message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...

"Leon" <vn*****@msn.co m> wrote in message
news:OD******** ******@TK2MSFTN GP11.phx.gbl...

Does anyone see my mistake? I'm trying to load the school dropdownlist
when the user select a state from the state dropdownlist. The states drop down list loads, but the school drop down list donot.

****Database Object Class.......... ..............

' Methods

'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

You are not passing the @StateID parameter into RunProcedure.

Shouldn't this be

Public Function GetSchoolByStat eList(ByVal StateID As String) As
DataSet
Dim parameters As SqlParameter() = { _
New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
parameters(0).V alue = StateID
Return RunProcedure( _
"GetSchoolBySta te", parameters, "SchoolByState" )
End Function

?

David

[Leon]

well I'm programming in vs.net 2003. I think I know how to efficiently run
the debugger.

"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Are you able to run this in the debugger?

Jeff

"Leon" <vn*****@msn.co m> wrote in message
news:#1******** ******@TK2MSFTN GP14.phx.gbl...

Thanks for you response!
yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
"SchoolByState" )" you are right do you see any more errors?

"David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in
message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...

>
> "Leon" <vn*****@msn.co m> wrote in message
> news:OD******** ******@TK2MSFTN GP11.phx.gbl...
>> Does anyone see my mistake? I'm trying to load the school dropdownlist
>> when the user select a state from the state dropdownlist. The states drop >> down list loads, but the school drop down list donot.
>>
>> ****Database Object Class.......... ..............
>>
>> ' Methods
>>
>> '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >> - - -
>>
>
> You are not passing the @StateID parameter into RunProcedure.
>
> Shouldn't this be
>
> Public Function GetSchoolByStat eList(ByVal StateID As String) As
> DataSet
> Dim parameters As SqlParameter() = { _
> New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
> parameters(0).V alue = StateID
> Return RunProcedure( _
> "GetSchoolBySta te", parameters, "SchoolByState" )
> End Function
>
> ?
>
> David
>
>
>

[Jeff Dillon]

So does it work in the debugger or not? Can you set breakpoints to see the
execution, and view the variables as you expect?

Jeff
"Leon" <vn*****@msn.co m> wrote in message
news:uH******** ******@TK2MSFTN GP12.phx.gbl...

well I'm programming in vs.net 2003. I think I know how to efficiently run
the debugger.

"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

Are you able to run this in the debugger?

Jeff

"Leon" <vn*****@msn.co m> wrote in message
news:#1******** ******@TK2MSFTN GP14.phx.gbl...

Thanks for you response!
yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
"SchoolByState" )" you are right do you see any more errors?

"David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in
message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...
>
> "Leon" <vn*****@msn.co m> wrote in message
> news:OD******** ******@TK2MSFTN GP11.phx.gbl...
>> Does anyone see my mistake? I'm trying to load the school dropdownlist >> when the user select a state from the state dropdownlist. The states

drop

>> down list loads, but the school drop down list donot.
>>
>> ****Database Object Class.......... ..............
>>
>> ' Methods
>>
>>

'- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

>> - - -
>>
>
> You are not passing the @StateID parameter into RunProcedure.
>
> Shouldn't this be
>
> Public Function GetSchoolByStat eList(ByVal StateID As String) As > DataSet
> Dim parameters As SqlParameter() = { _
> New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
> parameters(0).V alue = StateID
> Return RunProcedure( _
> "GetSchoolBySta te", parameters, "SchoolByState" )
> End Function
>
> ?
>
> David
>
>
>

[Leon]

my get set accessor function is not working, I'm trying to figure-out why?
PLEASE HELP!
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ef******** ******@TK2MSFTN GP15.phx.gbl...

So does it work in the debugger or not? Can you set breakpoints to see
the
execution, and view the variables as you expect?

Jeff
"Leon" <vn*****@msn.co m> wrote in message
news:uH******** ******@TK2MSFTN GP12.phx.gbl...

well I'm programming in vs.net 2003. I think I know how to efficiently
run
the debugger.

"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

> Are you able to run this in the debugger?
>
> Jeff
>
> "Leon" <vn*****@msn.co m> wrote in message
> news:#1******** ******@TK2MSFTN GP14.phx.gbl...
>> Thanks for you response!
>> yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
>> "SchoolByState" )" you are right do you see any more errors?
>>
>> "David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in
>> message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...
>> >
>> > "Leon" <vn*****@msn.co m> wrote in message
>> > news:OD******** ******@TK2MSFTN GP11.phx.gbl...
>> >> Does anyone see my mistake? I'm trying to load the school dropdownlist >> >> when the user select a state from the state dropdownlist. The
>> >> states
> drop
>> >> down list loads, but the school drop down list donot.
>> >>
>> >> ****Database Object Class.......... ..............
>> >>
>> >> ' Methods
>> >>
>> >>
> '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>> >> - - -
>> >>
>> >
>> > You are not passing the @StateID parameter into RunProcedure.
>> >
>> > Shouldn't this be
>> >
>> > Public Function GetSchoolByStat eList(ByVal StateID As String) As >> > DataSet
>> > Dim parameters As SqlParameter() = { _
>> > New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
>> > parameters(0).V alue = StateID
>> > Return RunProcedure( _
>> > "GetSchoolBySta te", parameters, "SchoolByState" )
>> > End Function
>> >
>> > ?
>> >
>> > David
>> >
>> >
>> >
>>
>>
>
>

[Jeff Dillon]

I can't help unless you answer my questions. I ask specific questions, and
require specific answers.

"Leon" <vn*****@msn.co m> wrote in message
news:ek******** ******@TK2MSFTN GP09.phx.gbl...

my get set accessor function is not working, I'm trying to figure-out why?
PLEASE HELP!
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ef******** ******@TK2MSFTN GP15.phx.gbl...

So does it work in the debugger or not? Can you set breakpoints to see
the
execution, and view the variables as you expect?

Jeff
"Leon" <vn*****@msn.co m> wrote in message
news:uH******** ******@TK2MSFTN GP12.phx.gbl...

well I'm programming in vs.net 2003. I think I know how to efficiently
run
the debugger.

"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
> Are you able to run this in the debugger?
>
> Jeff
>
> "Leon" <vn*****@msn.co m> wrote in message
> news:#1******** ******@TK2MSFTN GP14.phx.gbl...
>> Thanks for you response!
>> yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
>> "SchoolByState" )" you are right do you see any more errors?
>>
>> "David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in >> message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...
>> >
>> > "Leon" <vn*****@msn.co m> wrote in message
>> > news:OD******** ******@TK2MSFTN GP11.phx.gbl...
>> >> Does anyone see my mistake? I'm trying to load the school

dropdownlist

>> >> when the user select a state from the state dropdownlist. The
>> >> states
> drop
>> >> down list loads, but the school drop down list donot.
>> >>
>> >> ****Database Object Class.......... ..............
>> >>
>> >> ' Methods
>> >>
>> >>
> '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >> >> - - -
>> >>
>> >
>> > You are not passing the @StateID parameter into RunProcedure.
>> >
>> > Shouldn't this be
>> >
>> > Public Function GetSchoolByStat eList(ByVal StateID As

String) As

>> > DataSet
>> > Dim parameters As SqlParameter() = { _
>> > New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
>> > parameters(0).V alue = StateID
>> > Return RunProcedure( _
>> > "GetSchoolBySta te", parameters, "SchoolByState" )
>> > End Function
>> >
>> > ?
>> >
>> > David
>> >
>> >
>> >
>>
>>
>
>

[Bill Borg]

Leon, see my response to your identical post from last night--it's very odd
that your get/set accessor is playing with a *shared* variable, not to
mention that you're then touching that private variable again from within
GetSchoolByStat e. As for efficiently using the debugger, that may be, but
you're sure not giving anybody reason to believe that you're tracing through
the code and setting watchpoints on the value you're losing.

Bill

"Leon" wrote:

my get set accessor function is not working, I'm trying to figure-out why?
PLEASE HELP!
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ef******** ******@TK2MSFTN GP15.phx.gbl...

So does it work in the debugger or not? Can you set breakpoints to see
the
execution, and view the variables as you expect?

Jeff
"Leon" <vn*****@msn.co m> wrote in message
news:uH******** ******@TK2MSFTN GP12.phx.gbl...

well I'm programming in vs.net 2003. I think I know how to efficiently
run
the debugger.

"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...
> Are you able to run this in the debugger?
>
> Jeff
>
> "Leon" <vn*****@msn.co m> wrote in message
> news:#1******** ******@TK2MSFTN GP14.phx.gbl...
>> Thanks for you response!
>> yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
>> "SchoolByState" )" you are right do you see any more errors?
>>
>> "David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote in
>> message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...
>> >
>> > "Leon" <vn*****@msn.co m> wrote in message
>> > news:OD******** ******@TK2MSFTN GP11.phx.gbl...
>> >> Does anyone see my mistake? I'm trying to load the school

dropdownlist

>> >> when the user select a state from the state dropdownlist. The
>> >> states
> drop
>> >> down list loads, but the school drop down list donot.
>> >>
>> >> ****Database Object Class.......... ..............
>> >>
>> >> ' Methods
>> >>
>> >>
> '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>> >> - - -
>> >>
>> >
>> > You are not passing the @StateID parameter into RunProcedure.
>> >
>> > Shouldn't this be
>> >
>> > Public Function GetSchoolByStat eList(ByVal StateID As String)

As

>> > DataSet
>> > Dim parameters As SqlParameter() = { _
>> > New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
>> > parameters(0).V alue = StateID
>> > Return RunProcedure( _
>> > "GetSchoolBySta te", parameters, "SchoolByState" )
>> > End Function
>> >
>> > ?
>> >
>> > David
>> >
>> >
>> >
>>
>>
>
>

[Leon]

I got it! Thanks for all the help!!!!
"Bill Borg" <Bi******@discu ssions.microsof t.com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

Leon, see my response to your identical post from last night--it's very
odd
that your get/set accessor is playing with a *shared* variable, not to
mention that you're then touching that private variable again from within
GetSchoolByStat e. As for efficiently using the debugger, that may be, but
you're sure not giving anybody reason to believe that you're tracing
through
the code and setting watchpoints on the value you're losing.

Bill

"Leon" wrote:

my get set accessor function is not working, I'm trying to figure-out
why?
PLEASE HELP!
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ef******** ******@TK2MSFTN GP15.phx.gbl...

> So does it work in the debugger or not? Can you set breakpoints to see
> the
> execution, and view the variables as you expect?
>
> Jeff
> "Leon" <vn*****@msn.co m> wrote in message
> news:uH******** ******@TK2MSFTN GP12.phx.gbl...
>> well I'm programming in vs.net 2003. I think I know how to efficiently
>> run
>> the debugger.
>>
>> "Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
>> news:%2******** **********@TK2M SFTNGP10.phx.gb l...
>> > Are you able to run this in the debugger?
>> >
>> > Jeff
>> >
>> > "Leon" <vn*****@msn.co m> wrote in message
>> > news:#1******** ******@TK2MSFTN GP14.phx.gbl...
>> >> Thanks for you response!
>> >> yes, "Return RunProcedure( "GetSchoolBySta te", parameters,
>> >> "SchoolByState" )" you are right do you see any more errors?
>> >>
>> >> "David Browne" <davidbaxterbro wne no potted me**@hotmail.co m> wrote
>> >> in
>> >> message news:Oy******** ******@TK2MSFTN GP09.phx.gbl...
>> >> >
>> >> > "Leon" <vn*****@msn.co m> wrote in message
>> >> > news:OD******** ******@TK2MSFTN GP11.phx.gbl...
>> >> >> Does anyone see my mistake? I'm trying to load the school
> dropdownlist
>> >> >> when the user select a state from the state dropdownlist. The
>> >> >> states
>> > drop
>> >> >> down list loads, but the school drop down list donot.
>> >> >>
>> >> >> ****Database Object Class.......... ..............
>> >> >>
>> >> >> ' Methods
>> >> >>
>> >> >>
>> > '- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>> > - -
>> >> >> - - -
>> >> >>
>> >> >
>> >> > You are not passing the @StateID parameter into RunProcedure.
>> >> >
>> >> > Shouldn't this be
>> >> >
>> >> > Public Function GetSchoolByStat eList(ByVal StateID As
>> >> > String)
> As
>> >> > DataSet
>> >> > Dim parameters As SqlParameter() = { _
>> >> > New SqlParameter("@ StateID", SqlDbType.VarCh ar, 2)}
>> >> > parameters(0).V alue = StateID
>> >> > Return RunProcedure( _
>> >> > "GetSchoolBySta te", parameters, "SchoolByState" )
>> >> > End Function
>> >> >
>> >> > ?
>> >> >
>> >> > David
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>