Binding problems to dropdowns

[tshad]

I have a couple of stored procedures that are being called from my Page_Load
event.

They worked before, but now they are not working.

I am getting the error:

Specified argument was out of the range of valid values. Parameter name:
value

The function called is:

*************** *************** *************** **********
Sub GetExperienceLe vel()
exit sub
Dim emailReader As SqlDataReader
trace.warn("ins ide GetExperienceLe vel")
Dim ConnectionStrin g as String
=System.Configu ration.Configur ationSettings.A ppSettings("MM_ CONNECTION_STRI NG_ftsol")
Dim objConn as New SqlConnection (ConnectionStri ng)
Dim CommandText as String = "Exec GetExperienceLe vel"
Dim objCmd as New SqlCommand(Comm andText,objConn )
objConn.Open()

ExperienceLevel .DataSource=obj Cmd.ExecuteRead er
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0
trace.warn("exi ting GetExperienceLe vel")
end sub
*************** *************** *************** ***********

It is dying on the databind() line.

The dropdown is:

Experience:<asp :DropDownList id="ExperienceL evel" runat="server"
/></td>

The data coming back is:

ExperienceLevel ID Description
----------------- ----------------
10 Less than 1
20 1-2 Years
30 2-5 Years

Why is it not binding?

Thanks,

Tom

[tshad]

"tshad" <ts**********@f tsolutions.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

I have a couple of stored procedures that are being called from my
Page_Load event.

They worked before, but now they are not working.

I am getting the error:

Specified argument was out of the range of valid values. Parameter name:
value

The function called is:

*************** *************** *************** **********
Sub GetExperienceLe vel()
exit sub
Dim emailReader As SqlDataReader
trace.warn("ins ide GetExperienceLe vel")
Dim ConnectionStrin g as String
=System.Configu ration.Configur ationSettings.A ppSettings("MM_ CONNECTION_STRI NG_ftsol")
Dim objConn as New SqlConnection (ConnectionStri ng)
Dim CommandText as String = "Exec GetExperienceLe vel"
Dim objCmd as New SqlCommand(Comm andText,objConn )
objConn.Open()

ExperienceLevel .DataSource=obj Cmd.ExecuteRead er
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0
trace.warn("exi ting GetExperienceLe vel")
end sub
*************** *************** *************** ***********
I tried to change the Stored procedure line to:

Dim CommandText as String = "Select ExperienceLevel ID,Description from
ExperienceLevel order by ExperienceLevel ID"

This came right from the Stored Procedure and works from Sql Query (as does
the SP).

Tom
It is dying on the databind() line.

The dropdown is:

Experience:<asp :DropDownList id="ExperienceL evel" runat="server"
/></td>

The data coming back is:

ExperienceLevel ID Description
----------------- ----------------
10 Less than 1
20 1-2 Years
30 2-5 Years

Why is it not binding?

Thanks,

Tom

[tshad]

I found out what was happening, just not why.

I had added some code before filling the dropdownlist that tried to select
the a value.

if not (PositionReader ("ExperienceLev el") is DBNull.Value) then
ExperienceLevel .SelectedValue = PositionReader( "ExperienceLeve l")
end if

If I don't try to fill the Dropdownlist, I get the following code rendered.
*************** *************** *************** *********
Experience:<sel ect name="Experienc eLevel" id="ExperienceL evel">
</select></td>
*************** *************** *************** *********

I am curious why my trying to fill the DDL after I do the above would cause
me a problem. I would have expected to get an error on trying to select a
non-existant value. But the error I got, was later on filling the DDL.

I don't understand why it happened that way.

Tom

"tshad" <ts**********@f tsolutions.com> wrote in message
news:O5******** ********@TK2MSF TNGP12.phx.gbl. ..

"tshad" <ts**********@f tsolutions.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

I have a couple of stored procedures that are being called from my
Page_Load event.

They worked before, but now they are not working.

I am getting the error:

Specified argument was out of the range of valid values. Parameter name:
value

The function called is:

*************** *************** *************** **********
Sub GetExperienceLe vel()
exit sub
Dim emailReader As SqlDataReader
trace.warn("ins ide GetExperienceLe vel")
Dim ConnectionStrin g as String
=System.Configu ration.Configur ationSettings.A ppSettings("MM_ CONNECTION_STRI NG_ftsol")
Dim objConn as New SqlConnection (ConnectionStri ng)
Dim CommandText as String = "Exec GetExperienceLe vel"
Dim objCmd as New SqlCommand(Comm andText,objConn )
objConn.Open()

ExperienceLevel .DataSource=obj Cmd.ExecuteRead er
ExperienceLevel .DataTextField= "Descriptio n"
ExperienceLevel .DataValueField ="ExperienceLev elID"
ExperienceLevel .databind()
ExperienceLevel .Items.Insert(0 , "Select Experience Level")
ExperienceLevel .Items(0).value = 0
trace.warn("exi ting GetExperienceLe vel")
end sub
*************** *************** *************** ***********

I tried to change the Stored procedure line to:

Dim CommandText as String = "Select ExperienceLevel ID,Description from
ExperienceLevel order by ExperienceLevel ID"

This came right from the Stored Procedure and works from Sql Query (as
does the SP).

Tom

It is dying on the databind() line.

The dropdown is:

Experience:<asp :DropDownList id="ExperienceL evel" runat="server"
/></td>

The data coming back is:

ExperienceLevel ID Description
----------------- ----------------
10 Less than 1
20 1-2 Years
30 2-5 Years

Why is it not binding?

Thanks,

Tom