three row as one (alias name)

See more:

C#

MS-Access

Hello,

I want show a full name of a client in a combobox (C#).

But, the full name have three rows fullname, middlename, lastname., middlename can't be empty.

Program.Connection.CommandText = "select LastName + ', ' + FirstName AS NumeComplet, ClientId from Clients ORDER BY LastName";
            DataTable Table = new DataTable();
            Program.Connection.FillDataTable(Table, true);
            cboNumeClient.DataSource = Table;
            cboNumeClient.DisplayMember = "NumeComplet";
            cboNumeClient.ValueMember = "ClientId";
            cboNumeClient.Focus();

This is the code to show the fullname (firstname + lastname).

How to show (firstname + lastname + middlename)?

I try to use...

Program.Connection.CommandText = "select LastName + ', ' + FirstName + MiddleName AS NumeComplet, ClientId from Clients ORDER BY LastName";

but, when middlename is empty, my DisplayMember of the combobox is empty.