Finding value in dataset from combo box in C#

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

I am facing a simple problem. I have values in a combo box. When user selects 1 and press certain button. The program must find a value against the user selected value in combo box from a database and update a table.

The problem is that values in combo box are not unique. So, how i can find its unique value form a data base using the combo box value?

thanks

Posted 17-May-12 5:21am

Waleed_Hassan

Add a Solution

Comments

Pete O'Hanlon 17-May-12 12:05pm

Is it that the Text is not unique, or that the values themselves aren't unique?

Waleed_Hassan 17-May-12 12:20pm

The value them self are not unique. For Example.

Table 1
Col 1 P.K.
Col 2 some values
Col 3 Some values

I am loading the col 2 values in combo box. Now i try to find the col 1 values using col 2.

Jim Jos 18-May-12 4:09am

If you don't have unique values in col2 you need to bring along col1 values also in to the comboboxitem (concat with col2 and put it in the value).. Then from the selected item spearate the col1 value and use it to fetch data

1 solution

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)

Nilesh Rokade · Answer 1 · 2012-05-17T22:04:00

Solution 1

not clear..can you eloborate.

The program must find a value against the user selected value in combo box from a database and update a table.
-->even if values in combo box are not unique,it will find correct value from database.

(not clear)

Posted 17-May-12 22:04pm

Nilesh Rokade

Comments

Waleed_Hassan 18-May-12 7:23am

I have updated the combo box with values form col 2 as given in the example.
So, when user selects from the combo box and press the update button. i want the col 1 values to be fetched from table and update in another table.

Example.
Table 1
Col 1 P.K.
Col 2 some values
Col 3 Some values

I am loading the col 2 values in combo box. Now i try to find the col 1 values using col 2.