Solved

Filling DropDownList, but getting error when selected value is 0

Posted on 2006-07-10
8
191 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
8 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now