I'm writing a program has access to a database (a database where an other software stores data that users type). This database has several colums, but in my code, i need to use the two columns that describes where the data is from, and the the date when the data where added. And then my intensjions is that the user type in on place (where the data is from) and, then the program goes trough the database and looks for the oldest dates in that perticular place and places around.
Here is an example of my database:
Area, Section, MeasureDate
1 12 12.05.2009
1 13 15.05.2009
1 14 17.05.2009
1 15 18.05.2009
1 16 19.05.2009
I know how to add the database as a dataset, but not sure how to continue.
If the user now types inn 12 in of my textBoxes and press calculate.
the code first make a list (that contains 12,13,14,15) and then i want it to look for this numbers in the dataset and then which section have the oldest measurment and need "most" to be measured now.
so of this example, my form should give out:
Section 13 at 1 was last measured 12.05.2009 and needs to be measured now.
I'm using Microsoft visual studio 2010, my dataset have the name car_mosDataSet.xsd in the solution explorer.
I would be very grateful for any help, and if i should give more information, just give me a hint.