Solved

Data bound ComboBox

Posted on 2004-04-15
6
380 Views
Last Modified: 2007-12-19
I have a combo box on a pocket pc form with the data source set to a DataTable and the ValueMember set to an ID field and the DisplayMember set to a Description field.

To get a blank entry at the top of the combo box I add a row to the beginning of the DataTable with an ID of 0 and a description of spaces.

Sometimes i need to select a specific value when loading the combo box so it displays the correct item on entry. I do this as follows:
this.combobox.SelectedValue = ID (where ID > 0)

If there are 2 or more rows in the DataTable (before i add a blank one) it works fine.
However, if there is only 1 row in the DataTable an unspecified exception is thrown.

Any idea why, or how this can be avoided???
0
Comment
Question by:MartinLarge
  • 2
  • 2
6 Comments
 
LVL 6

Expert Comment

by:DaniPro
ID: 10833683
You must verify that the number of the itemes is less then your id

if (combobox.Items.Count > ID)
      combobox.SelectedValue = ID;
0
 

Author Comment

by:MartinLarge
ID: 10834030
I have an Id with a value of 8 when there are only 3 rows in the table and it still works. It doesn't work if there is only 1 row in the original table.

What you suggested would be OK if using SelectedIndex but i'm using SelectedValue from a datasource.
0
 
LVL 6

Expert Comment

by:DaniPro
ID: 10834306
You have right (it was SelectedIndex), then you must verify that exists an item with the ValueMember with your ID:

if (combobox.Items.Contains(ID))
     combobox.SelectedValue = ID;
0
 

Author Comment

by:MartinLarge
ID: 10834693
The Id does exist within the DataTable.

If the DataTable has 2 rows the combo box works fine and selects the correct id.
If i remove the row which does not match the id it crashes.

I think there is a problem with adding the blank datarow to the DataTable.
When i don't do this it works fine.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 11756969
PAQed, with points refunded (125)
ee_ai_construct - CS Mod
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Bit flags and bit flag manipulation is perhaps one of the most underrated strategies in programming, likely because most programmers developing in high-level languages rely too much on the high-level features, and forget about the low-level ones. Th…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 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

14 Experts available now in Live!

Get 1:1 Help Now