How to concat Lastname and Firstname in combox

Question

0.00/5 (No votes)

See more:

I have a employee table(empID, empLname, empFname, empMname) and I want to concatenate two fields in a LnameComboBox. The displayed text in the combobox is empId not the fullname. What's wrong with the code.

Here is my code:

LnameComboBox.DataSource = EmployeeBindingSource

VB

Dim fname As String = "empfname"
            Dim lname As String = "emplname"
            Dim full As String
            full = String.Concat(fname & "," & lname)
            LnameComboBox.DisplayMember = full
            LnameComboBox.ValueMember = "empid"
            EmployeeTableAdapter.Fill(Point_of_saleDataSet11.employee)

Thanks...

Posted 11-Dec-12 22:47pm

ianshack

Add a Solution

Comments

[no name] 12-Dec-12 4:50am

whats the error ?

ianshack 12-Dec-12 4:54am

the displayed text in the combobox is still the empID not the fullname.

choudhary.sumit 12-Dec-12 5:05am

post your query which you are using to fetch data and make the EmployeeBindingSource.

_Vitor Garcia_ 12-Dec-12 5:34am

Why don't you use add methos from items like this :
Dim fname As String = "empfname"
Dim lname As String = "emplname"
Dim full As String
full = String.Concat(fname & "," & lname)

LnameComboBox.Items.Add(full)

ianshack 12-Dec-12 19:04pm

I got an error if I add an Item to a control that Bind to a datasource.

ianshack 12-Dec-12 19:10pm

SELECT EmpID, EmpLname, EmpFname, EmpMname, CONCAT(EmpLname, ', ', EmpFname, ', ', EmpMname) AS fullname, `E.CatID`
FROM employee

ianshack 12-Dec-12 19:16pm

Sir I made a new Data Table(fullname) in DataSet Designer and have a TableAdapter queries above.
And I bind LnameComboBox to Data Table(fullname) and it displays fullname. Sir is it okey?

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)

ujju.1 · Answer 1 · 2012-12-13T23:05:00

Try this one:

VB

Dim ds As New DataSet
ds =  someDatasource
If ds.Tables(0).Rows.Count > 0 Then
  For index As Integer = 0 To ds.Tables(0).Rows.Count - 1
   LnameComboBox.Items.Add(ds.Tables(0).Rows(index).Item("empfname").ToString() _
   & "," & ds.Tables(0).Rows(index).Item("emplname"))
   LnameComboBox.Items(LnameComboBox.Items.Count - 1).Value = _ ds.Tables(0).Rows(index).Item("empid")
                Next
            End If

ujju.1 · Answer 2 · 2012-12-12T00:13:00

Solution 2

Try this one

VB

LnameComboBox.DataSource = EmployeeBindingSource
Dim fname As String = "empfname"
Dim lname As String = "emplname"
Dim full As String = fname & "," & lname 
LnameComboBox.DataTextField= full
LnameComboBox.DataValueField= "empid"
LnameComboBox.DataBind()

Posted 12-Dec-12 0:13am

ujju.1

Updated 12-Dec-12 0:16am

v2

Comments

ianshack 12-Dec-12 19:03pm

Sir, It still display the empid not the fullname.

ujju.1 14-Dec-12 4:59am

Try this one:
Dim ds As New DataSet
ds = EmployeeBindingSource
If ds.Tables(0).Rows.Count > 0 Then
For index As Integer = 0 To ds.Tables(0).Rows.Count - 1
LnameComboBox.Items.Add(ds.Tables(0).Rows(index).Item("empfname").ToString() & ds.Tables(0).Rows(index).Item("emplname"))
LnameComboBox.Items(LnameComboBox.Items.Count - 1).Value = ds.Tables(0).Rows(index).Item("empid")
Next
End If

Pablo Aliskevicius · Answer 3 · 2012-12-11T23:59:00

The DisplayMember should be a public property of the object.
E.g:

C#

// In employee.cs
public string DisplayName 
{
  get { return this.LastName + ", " + this.FirstName; }
}

Then, in your view class:

C#

LnameComboBox.DisplayMember = DisplayName; // pseudo code, won't compile.

You can set this in the Properties (using the designer).

Hope this helps,
Pablo.

How to concat Lastname and Firstname in combox

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0