How do I get the primary key associated with a Combo Box Selected Index?

Question

0.00/5 (No votes)

See more:

I have a database with a primary key that's automatically incremented. My Combo Box displays a list of names in alphabetical order. I can get the index but I'm stuck on how to get the primary key.

C#

private void cmdEdit_Click(object sender, EventArgs e)
{
    string strField = this.cboClients.ValueMember;
    int intClient = this.cboClients.SelectedIndex;
}

Thanks in advance for your help.

Posted 14-Jun-11 2:38am

CP Rouse

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kschuler · Accepted Answer · 2011-06-14T04:56:00

Solution 2

When you load the combobox you can specify display text versus a value...so you could put your names as the display but keep a primary key value as the value. Here[^] is an article that explains this.

Posted 14-Jun-11 4:56am

Kschuler

parmar_punit · Accepted Answer · 2011-06-14T07:24:00

I think for that you should bind your combo box like your primary key value should be bind as a value member and the main thing that you want to display in combo box that should be bind as display member so later on you can directly point to the primary key like....

//bind combo box like this...
     this.cboClients.DataSource = ds.Tables["tableName"]; // for that you need to fire a select query that fill the record in dataset
     this.cboClients.DisplayMember = "FieldName"; // give the name of field that you want to display in combo box
     this.cboClients.ValueMember = "FieldName"; // give the name of primary field...

C#

private void cmdEdit_Click(object sender, EventArgs e)
{
    string strField = this.cboClients.ValueMember;
    int intClient = this.cboClients.SelectedValue;
}

CP Rouse · Accepted Answer · 2011-06-14T03:22:00

Solution 1

I'm new to C#, mea culpa.

The solution was just too straight forward:

int intClientKey = this.persDataDataSet.Clients[this.cboClients.SelectedIndex].ClientKey;

Posted 14-Jun-11 3:22am

CP Rouse