If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

referring to different columns of a combobox

mountainyman · 2008-11-12 17:01:37

I have a combobox called cboUsers I fill it with a two column stored procedure Select UserID, UserName From Users UserName is displayed. That is what I want. But... I need to get the value UserID Now I know that UserID is a valuemember for this combobox but how do I get the value without showing the number? MM

Options

12-11-2008 6:01pm

#1
mountainyman

Closed Accounts Posts: 2,268 ✭✭✭

Join Date: September 2005

Posts: 1972
I have a combobox called cboUsers I fill it with a two column stored procedure
Select UserID, UserName From Users

UserName is displayed.

That is what I want.

But...

I need to get the value UserID

Now I know that UserID is a valuemember for this combobox but how do I get the value without showing the number?

MM

0

Comments

Options
#2 12-11-2008 6:25pm
nialo

Registered Users Posts: 610 ✭✭✭

Join Date: November 2004

Posts: 551

what language?

0
Options
#3 12-11-2008 10:03pm
stevenmu

Moderators, Society & Culture Moderators Posts: 9,689 Mod ✭✭✭✭

Join Date: July 2003

Posts: 9396

If it's .Net the combobox has a selectedvalue property.

0
Options
#4 13-11-2008 1:16pm
mountainyman

Closed Accounts Posts: 2,268 ✭✭✭

Join Date: September 2005

Posts: 1972

I can't believe I didn't post the language.

It's VB.net

Sorry again.

0
Options
#5 13-11-2008 1:30pm
nialo

Registered Users Posts: 610 ✭✭✭

Join Date: November 2004

Posts: 551

As stevenmu said its SelectedValue or SelectedItem.Value. although if there is No selectedItem then you will get a null exception.

0