C# Project Help sorting & searching

Projects Programming
1

I have 12 files (all have the same amount of lines) and one of them give years( a year for each month e.g if the months go to 12 there will be 12 of the same year.

For example the month file looks like this : January February March April May June July August September October November December January February March April May June July August September October November December January. And the Year file will look like this: 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2016 )

The other 10 files have data about weather which will correspond to the same line number to every other file. I need to give the user the option to either search for a year and bring all the corresponding data back (from each file, on the same line number) or the same but search for months. Can someone show me how to do this please? NEED HELP DRASTICALLY

WS2_Sun.txt (7.57 KB)

WS2_Rain.txt (7.09 KB)

WS2_AF.txt (3.15 KB)

WS2_TMin.txt (6.29 KB)

WS2_TMax.txt (6.69 KB)

WS1_Sun.txt (7.39 KB)

WS1_Rain.txt (7.4 KB)

WS1_AF.txt (3.11 KB)

WS1_TMin.txt (6.1 KB)

WS1_TMax.txt (6.44 KB)

Month.txt (8.15 KB)

Year.txt (5.99 KB)

2

This makes no sense.
You cannot have two files with the same name in the same directory.

3

What do you mean, none of the files have the same name?

4

jermane:
What do you mean, none of the files have the same name?

I have no clue what you are trying to do.

In addition, C# questions unless it has to do with the Arduino in some tangible manner
should be asked at the MSDN forum.

5

Read all the data into a series of arrays and sort/display as needed.

6

What you are asking is how to make a bunch of flat files into a relational database. The simple answer is that it can't be done.

The longer answer is that it can be done only in limited conditions, if the data is well structured and the queries are constrained.

How to do it is up to you, and has NOTHING to do with the Arduino. Try asking at www.ford.com.

7

It should be easier than that, Paul S, since he is relating them all by line number. If he just reads all the data into a series of arrays indexed by line number, he should be able to do all his searching and reporting.