![]() |
data from row column intersection - Printable Version +- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums) +-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP) +--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners) +--- Thread: data from row column intersection (/Thread-data-from-row-column-intersection) |
data from row column intersection - chetan.dewangan - 03-04-2008 My que is: If I want to fetch value from datasheet based on particular column-row intersection (like where clause in database). Like I have value in two column as follows: Gujarat-Gandhinagar Maharastra-Mumbai Karnatka-Bangaore If I want to fetch Capital based on State, like from the data base: Select Capital from tble where state="Karnatka" Is it possible from datasheet, if yes how? RE: data from row column intersection - sreekanth - 03-04-2008 you can use Code: DataTable.SetCurrentRow(RowNumber)'this will set the row Code: DataTable.Value(ParameterID [, SheetID]) or Code: DataTable(ParameterID [, SheetID]) |