How to fetch single value from Execute Query?


I have DB table where I have columns Name, Team, Designation.

I’m executing a sql SELECT Designation from Table where Name=abc

and storing into a datatable. And How can i covert that value into a variable to use in type into activity

Thanks in advance.!

string Var = TableDT.Rows(< row number >).Item(< column number >).ToString

Let’s say you want to extract value of cell in 0th row 1 column.

string Var = TableDT.Rows(0).Item(1).ToString