Multi coloumn combobox in VB.NET

Question

0.00/5 (No votes)

See more:

Hello Master, can you help me how to get single data from multiple coloumn in combobox VB.Net?
I will explain it, first i already create multiple coloumn in combobox, im concat two fields from 1 table, just say it id_material and Desc_material, and when i choose i want what write in combobox.text is just id_material, because i need only get that id_material, please help me

What I have tried:

i already tried many ways, but still fail to get it

Posted 9-Sep-19 18:51pm

Member 14585207

Updated 9-Sep-19 20:40pm

Add a Solution

2 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)

OriginalGriff · Answer 1 · 2019-09-09T20:02:00

That we cannot help you with: if you have concatenated two fields to create a new value to insert in the combobox, we have no idea where the first ends and the second begins - it's just a string now, and unless there is a very specific character between the two values, they cannot be reliably "untangled".

A much better idea would be to use this: Flat-MultiColumn Combobox with Autocomplete[^] or to databind the data behind it all to a single columns ComboBox and and use the DisplayMember and ValueMember properties to select the Desc_material to display to the user, and the id_material to return as the selected value.

Maciej Los · Answer 2 · 2019-09-09T20:41:00

Quote:
i already create multiple coloumn in combobox, im concat two fields from 1 table

No, you don't. It's still single column combobox.

Quote:
i need only get that id_material

It's quite easy to achieve. You have to set:
DisplayMember Property[^] to that concatenated string
and
ValueMember Property[^] to that id_material.

VB.NET

ComboBox1.DataSource = dataSet1.Tables["Materials"];  
ComboBox1.DisplayMember = "CommonNameForMaterialIdAndDescription";  
ComboBox1.ValueMember = "id_material";

That's all!

For further details, please see:
ComboBox Class (System.Windows.Forms) | Microsoft Docs[^]
How to: Bind a Windows Forms ComboBox or ListBox Control to Data | Microsoft Docs[^]

Multi coloumn combobox in VB.NET

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0