Solved

Filling DropDownList, but getting error when selected value is 0

Posted on 2006-07-10
8
193 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 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