如何在组合框中将两个值显示为文本 [英] how to show two values as a text in combobox

问题描述

我想在一个组合框上显示两个列值。

喜欢这个



1.萨拉之书



1是书号（列名）

Salah书是bookName（列名）



使用Windows窗体

解决方案

以您想要的格式从后端数据库获取数据，并使用DataTextField在组合框中显示相同的数据。



下面的代码应该可以帮到你：

Quote：

< asp：dropdownlist id =DropDownList1runat =serverxmlns：asp =＃unknown>

DataSourceID =SqlDataSource1DataTextField =Description

DataValueField =序列>



< asp：sqldatasource id =SqlDataSource1runat =serverxmlns：asp = #unknown>

ConnectionString =<％

ConnectionStrings：LogDBConnectionString％>

SelectCommand =SELECT Sequence，CONVERT（varchar（50），Sequence）+' - '+ CONVERT（varchar（50），[MessageType]）'Description'FROM [Event]>

用
 
替换你的代码<   asp：DropDownList     ID   =  EmployeeIDTextBox    runat   =  server  
   
   DataSourceID   =  AccessDataSource1    DataTextField  <跨度class =code-keyword> =  EmployeeName    DataValueField   =  EmployeeID    SelectedValue   ='  <％ #Bind（  EmployeeID）％> ' >  
  <   / asp：DropDownList  >  
 <   asp：AccessDataSource     ID   =  A ccessDataSource1    runat   =  server    DataFile   = 〜/ App_Data / JABILMCALLEN.mdb  
   
   SelectCommand   =  SELECT [EmployeeID]，（[Name] +''+ [LastName]）as EmployeeName FROM [Employees] > ;  
 <   / asp：AccessDataSource  >  

I want to show two column values on one Combo box.
like this

1. Book of Salah

1 is book number(Column Name)
Book of Salah is bookName(Column Name)

using windows forms

解决方案

Get the data from backend database in a format you want and display the same in your combo box using the DataTextField.

Below code should help you:

Quote:

<asp:dropdownlist id="DropDownList1" runat="server" xmlns:asp="#unknown">
DataSourceID="SqlDataSource1" DataTextField="Description"
DataValueField="Sequence">

<asp:sqldatasource id="SqlDataSource1" runat="server" xmlns:asp="#unknown">
ConnectionString="<%

ConnectionStrings:LogDBConnectionString %>"
SelectCommand="SELECT Sequence, CONVERT(varchar(50), Sequence) + ' - ' + CONVERT(varchar(50), [MessageType]) 'Description' FROM [Event]">

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>

这篇关于如何在组合框中将两个值显示为文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！