Last post Feb 26, 2019 05:46 AM by Fei Han - MSFT
Feb 26, 2019 02:35 AM|shsu|LINK
select ISO_CODE||'-'||SHORT_NAME from country_master
I want to show this inside the dropdownlist .When I test the query inside the dropdownlist ,it is showing as
AUS-Australia ( This is the one I was looking for)
but when I run the form ,it is showing as system.data.datarowview in the dropdownlist. Appreciate the Help
Feb 26, 2019 03:51 AM|KathyW|LINK
Please provide more information. What do you mean "showing a query inside a dropdownlist"?
Please provide the code you are using.
Feb 26, 2019 05:46 AM|Fei Han - MSFT|LINK
when I run the form ,it is showing as system.data.datarowview in the dropdownlist. Appreciate the Help
Please try to specify the DataValueField and DataTextField of your DropDownList control, like below.
select ISO_CODE||'-'||SHORT_NAME as codewithname from country_master
DropDownList1.DataSource = tb
DropDownList1.DataValueField = "codewithname"
DropDownList1.DataTextField = "codewithname"