data from row column intersection

[chetan.dewangan]

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?

[sreekanth]

you can use

Code:

DataTable.SetCurrentRow(RowNumber)'this will set the row

and

Code:

DataTable.Value(ParameterID [, SheetID])

or

Code:

DataTable(ParameterID [, SheetID])

to retrieve the value from a specified row and column