Access data from a selected row in the SQLDataGrid

You can use the SQLDataGrid graphic to read the content of a selected row and associate it to attributes outside the graphic. You can configure scripts to read the data from a selected row and programmatically associate that data to tags in an InTouch application or to attributes in the Galaxy.

The following script example shows how to retrieve data from a selected row. Notice that the SelectedRowData property is available in the SQLDataGrid client control and not in the SQLDataGrid graphic.

dim rd1 as System.Data.DataRow;

rd1 = SQLDataGridUserCtrl1.SelectedRowData;

if(rd1 <> null) then

InTouch:Text9 = rd1.ItemArray[4].ToString();

'This assigns the 4th column value for the selected row, to the InTouch "Text9" tag.

endif;