I am trying to load a combo box with the entries from a recordset. I have found that i needed to create a class to store the values, but i think the class is convoluted and too much code. Any suggestions? I also added the override string into the class because it was simply presenting object names previously.
When I try to set the selected item to a specific value in code, it does not set. I think because the string override is only being present and not stored, so I am not doing this right.
If someone has an easier solution, you dont need to fix my code if there is better code for accomplishing this.
I am looking to load IDs, and Text from a recordset into a combobox, then have the ID show when I reference the .SelectedItem of the cbo.
Thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Is there a specific reason you need the class at all? ie do you NEED to use .SelectedItem or why not just use .SelecteValue?
cboTax1.DisplayMember = "DisplayValue";
cboTax1.ValueMember = "TxCode";
cboTax1.DataSource = new BindingSource(cbocmd.Execu
that binds everything, then you can set and retrieve by TxCode by getting / setting cboTax1.SelectedValue
Business Accounts
Answer for Membership
by: federicomarinucciPosted on 2009-10-30 at 09:11:23ID: 25704374
Create a static method in an external class to aid you:
-----
internal string[][] PopulateCB(Combobox cb, string[][] values){
cb.Items.Clear();
string[][] container = new string[values.Length][];
for (int x = 0; x< values.Length; x++){
string itemValue = values[x][0];
cb.Items.Add(itemValue);
container[x] = new String[values[x].Length-1]
for (int y = 0; y < container.Length; y++){
container[x][y] = values[x][y+1];
}
}
return container;
}
-----
This way, you just have to get the items in a string[ROW][COLUMN] way, having in COLUMN zero the value you wish to display in the Combobox; then, to retrieve which ROW has been selected, you may simply use the ComboBox.SelectedIndex as index for your container's ROW, leading you to the other values of that ROW (such as ID or anything else).