I've created In-Memory data table from VB.NET. (not SQL database table)
I could able to diaplay all the data in datgrid.
Actually my table looks like follows...
value1 value2 value3
10 20 1
21 30 2
31 40 3
Now i want to compare a some input (say x) with table value1 and 2.
If x>10 and <20,then i need to return 1.<br />
If x is not within the first range,it has to move to the next line and do compare.
how to do this comparision? is it necessary to have a primary key?
How to choose a single row at a time and check the range?
Hope it'll be simple. but i run out of ideas.
Please give suggesions regarding this.