how to show two values as a text in combobox

Replace your code with

<asp:DropDownList ID="EmployeeIDTextBox" runat="server"
DataSourceID="AccessDataSource1" DataTextField="EmployeeName" DataValueField="EmployeeID" SelectedValue='<%# Bind("EmployeeID") %>'>
</asp:DropDownList>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/JABILMCALLEN.mdb"
SelectCommand="SELECT [EmployeeID], ([Name] + ' ' + [LastName]) as EmployeeName FROM [Employees]">
</asp:AccessDataSource>

Hi, See this articles:
MultiColumnComboBox[^]
Multi Column ComboBox[^]
Flat-MultiColumn Combobox with Autocomplete[^]

Or see this thread:
http://stackoverflow.com/questions/1091414/winforms-combobox-with-multiple-columns-c[^]
http://social.msdn.microsoft.com/Forums/en-US/dd327557-df14-44ee-8c4e-bc307142d1ad/c-show-2-columns-in-a-combobox-or-listbox[^]

Hope it helps! :)

hello professional


you just need to concatenate your both columns as DB level and then bind them
from your Combo box.

like this

1st make a query in sql-

select (+'( '+ cast(BookNumber as varchar(20)) +' ) ' + BookName) as BookNameCode from T_BookMaster

here casting (cast(BookNumber as varchar(20))) because i think in DB's BookNumber Column may be Int type data type



then youn need to simple bind it

like this-

CmbBook.DataSource = dsbook;
CmbBook.DataTextField = "BookNameCode  ";
CmbBook.DataValueField = "BookNumber";
CmbBook.DataBind();

Happy To Help!!!