How to concat Lastname and Firstname in combox

Posted 11 Dec '12 - 22:47

ianshack526

Krunal Rohit - 12 Dec '12 - 4:50

whats the error ?

ianshack - 12 Dec '12 - 4:54

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

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

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

VitorHugoGarcia - 12 Dec '12 - 5:34

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:04

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

ianshack - 12 Dec '12 - 19:10

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

ianshack - 12 Dec '12 - 19:16

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?

Solution 3

Try this one:

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

Permalink

Posted 13 Dec '12 - 23:05

ujju.13.3K

Solution 2

Try this one

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

Permalink

Posted 12 Dec '12 - 0:13

ujju.13.3K

Edited 12 Dec '12 - 0:16

Comments

ianshack - 12 Dec '12 - 19:03

Sir, It still display the empid not the fullname.

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

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

Solution 1

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

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

Then, in your view class:

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

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

Hope this helps,
Pablo.

Permalink

Posted 11 Dec '12 - 23:59

Pablo Aliskevicius17.3K

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

0	Sergey Alexandrovich Kryukov	208
1	OriginalGriff	203
2	Abhinav S	168
3	Rohan Leuva	150
4	Abhishek Pant	145

0	Sergey Alexandrovich Kryukov	8,474
1	OriginalGriff	6,714
2	CPallini	3,603
3	Rohan Leuva	2,853
4	Maciej Los	2,234

How to concat Lastname and Firstname in combox

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

		9,881,102 members (48,773 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Interested
Ignored

How to concat Lastname and Firstname in combox

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us