Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
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.
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.