# Bind dataset col value to LED

**URL:** <https://forum.inductiveautomation.com/t/bind-dataset-col-value-to-led/1346>\
**Category:** Archived Topics\
**Created:** [October 23, 2009, 10:50am UTC](https://forum.inductiveautomation.com/t/bind-dataset-col-value-to-led/1346 "2009-10-23T10:50:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![johandk](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@johandk](https://forum.inductiveautomation.com/u/johandk)\
**Post date:** [October 23, 2009, 10:50am UTC](https://forum.inductiveautomation.com/t/bind-dataset-col-value-to-led/1346/1 "2009-10-23T10:50:51Z")

</div>

Hi,

I have a SQL tag, whose value is a dataset. It only has one row. I am trying to bind one of the columns values to a LED display.

I’m very new to FactoryPMI - please help.

Thanks,  
Johan

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [October 23, 2009, 4:24pm UTC](https://forum.inductiveautomation.com/t/bind-dataset-col-value-to-led/1346/2 "2009-10-23T16:24:02Z")

</div>

Hi,

To bind into a dataset you have to use an expression. Open the binding window, select “expression”, and then link to your tag using the button to the right. You can index into the dataset by adding “[row,col]” after the reference. The only trick here is that you’ll have to cast the result, by wrapping it in one of the “toType” functions.

So, ultimately you’ll end up with something like:

```auto
toDouble({[Client]Tag}[0,0])
```

Regards,