Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Filling DropDownList, but getting error when selected value is 0

Posted on 2006-07-10
8
Medium Priority
?
198 Views
Last Modified: 2006-11-18
Hi there,

I'm trying to fill a dropdownlist in a datagrid and I'm running into an error:

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

When the value of the dropdownlist is 0.

Here's my aspx:
asp:DropDownList
Enabled="false"
ID="dropStates"                                                       
DataTextField="State_Acronym"
DataValueField="ID"
DataSource="<%# Load_States() %>"
SelectedValue='<%# Container.DataItem("State") %>'

here's my code-behind:

Public Function Load_States()
            Dim cmdSelect As SqlCommand
            Dim dtrStates As SqlDataReader
            Dim strSelect AS string
            Dim ddlDataSet as DataSet = New DataSet()
            Dim conPubs As New SqlConnection(ConfigurationSettings.appSettings("sqlconnectionString"))
            
            strSelect = "Select tblStates.* From tblStates"
            Dim myDataAdapter as SqlDataAdapter = New SqlDataAdapter(strSelect, conPubs)  
            
            myDataAdapter.Fill(ddlDataSet, "Categories")
       
            Return ddlDataSet            
End Function

There's no value in the tblStates with a 0 so that's what's throwing the error.  Any thoughts on how to get this work?

Full Williams                                                      
                                                      Runat="Server" />
0
Comment
Question by:FullWilliams
7 Comments
 
LVL 5

Expert Comment

by:bastibartel
ID: 17072828
Hi FullWilliams,

Try selecting 1.
As far as I remember VB has 1-based arrays.

Cheers!
0
 
LVL 7

Expert Comment

by:RainMan82
ID: 17073065
yeah bastibartel is correct....they are all 1-based....
0
 

Author Comment

by:FullWilliams
ID: 17073725
Selecting 1 would be the first state though and that's not correct.  Also, would I select it in the code or in the aspx?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:FullWilliams
ID: 17073817
I tried putting in:

myDataAdapter.SelectedValue = 0
 and got this error:

BC30456: 'SelectedValue' is not a member of 'System.Data.SqlClient.SqlDataAdapter'
0
 

Author Comment

by:FullWilliams
ID: 17073841
increasing the points as I need to get this resolved.
0
 

Author Comment

by:FullWilliams
ID: 17074185
I got it to by modifying my code behind:

myDataAdapter.Fill(ddlDataSet, "Categories")

        'adding a row
        dim row as datarow
        row = ddlDataSet.tables("Categories").newrow
        row("State_Acronym") = ""
        row("ID") = 0  
       
        ddlDataSet.tables("Categories").rows.add(row)

Please close this question
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 17325331
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question