> For the complete documentation index, see [llms.txt](https://muradkarakas.gitbook.io/sodium_documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://muradkarakas.gitbook.io/sodium_documentation/getting-started/examples/datalist-and-select-element-usage.md).
# Datalist & Select Element Usage
This demo page shows:
* how to use [Data List](https://sodium.gitbook.io/sodium/language-reference/html-tags/sodium-tags/data-list) tag, [populate\_datalist](/sodium_documentation/getting-started/examples/datalist-and-select-element-usage.md) function and record set variables
* how to fill a drop down list with a [Data List](https://sodium.gitbook.io/sodium/language-reference/html-tags/sodium-tags/data-list) tag
* how to define a look up select element
Create a new sub folder named `selectElement` under the `site\pages` folder of the installation path.
**Form File:**
Create a file named `selectElement.frmx` and copy/paste the code block showed below into the file.
```
Select Element Demo
```
**Code behind File:**
Create a file named `selectElement.sqlx` and copy/paste the code block showed below into the file.
```
void page.load() {
rsProvinces = select province_name as label, province_id as value
from
provinces
order by
province_name;
populate_datalist('provinces', rsProvinces);
rsCounties = select county_name as label, county_id as value, province_id as province_id
from
counties
order by
county_name;
populate_datalist('counties', rsCounties);
}
```
**Controller File:**
```
void connection_not_found(char connectionName) {
if (connectionName == 'default') then
bool connStatus;
connStatus = create_oracle_connection('default', 'XE', 'htdemo', '1234');
end if;
}
```
**Output:**
