如何在组合框的下拉列表中显示两列数据？ [英] How to display two columns data in dropdownlist of combo box ?

问题描述

表中的3Columns Produtct_Id，UOM1和UOM2



Product_Id UOM1 UOM2

----------- --- ---

1. PIECES BOX

2.瓶装CTN

3.包装袋





我想在combobox中显示的是基于product_id，而我从Combobox中选择Product_Id 1，想要在另一个组合框中绑定UOM1和UOM2值。不是所有的数据。



例如：select Product_Id 1.



只显示这两个数据在组合框上。



PIECES

BOX



我该如何重写sql语句？

虽然我尝试使用该语句，但显示所有数据。





< br $>


SELECT UOM1_Code AS UOM FROM Product

UNION ALL

SELECT UOM2_Code AS UOM FROM Product

其中Product.Product_Id = 1

解决方案

尝试

  SELECT  UOM1_Code  AS  UOM  FROM 产品其中 Product.Product_Id =  1  
  UNION   ALL  
  SELECT  UOM2_Code  AS  UOM  FROM 产品其中 Product.Product_Id =  1  

3Columns Produtct_Id, UOM1 and UOM2 in a table

Product_Id UOM1 UOM2
----------- --- ---
1. PIECES BOX
2. BOTTLE CTN
3. PACKET BAN


what I want to display in combobox is based on the product_id, while I choose Product_Id 1 from a Combobox, want to bind UOM1 and UOM2 value in the another combobox. Not all the data.

for example: select Product_Id 1.

just only display those two data on combobox.

PIECES
BOX

How should I rewrite the sql statement?
Although I try to use that statement, show all the data in.




SELECT UOM1_Code AS UOM FROM Product
UNION ALL
SELECT UOM2_Code AS UOM FROM Product
where Product.Product_Id = 1

解决方案

Try

SELECT UOM1_Code AS UOM FROM Product where Product.Product_Id = 1
UNION ALL
SELECT UOM2_Code AS UOM FROM Product where Product.Product_Id = 1

这篇关于如何在组合框的下拉列表中显示两列数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！