Kevin's Week 3 Report

This week I worked on trying to get data from the database structure into a website in order to graph the display.  Designing the page using ASP.net, the webpage is able to access the database.  On the webpage, the user will select what time period they wish to view (minute, hour, day, week, etc..).  This will then give the user options to enter in what specific hour, day, week, etc. they wish to view.  When the user enters this information, the respective numbers of the hour, day, week, etc. will be put into a querystring.  The program that accesses the database will take this querystring and take the numbers it needs and put it into a string.  This string will only go down to the minute as the most specific data point.  If the user wants to view data on a specific minute, then the datatemp table will be accessed, since it contains information down to second accuracy, and all the data that match that minute information will be sent to the webpage.  Similarly, if the user wants to view data for a certain hour, then the dataminute table is accessed, since it contains information down to minute accuracy, and all the entries that have the same hour value as the user input will be selected, so 60 data entries.  This process applies to all data selections.  There will have to be a checker so that if the user requested minute data from the whole of year 2010, an error message will appear.  The database cannot keep data that specific for that long of a time period, and the user will have to select monthly data instead.
Right now the values are being passed into the querystring and they are being read.  However, they are not plotting on the graphs, using MS chart control.  I will need to find out why data is being passed into program, but no data shows up.  Once this is working though, I plan to hook up the program to our old digital thermometer circuit to test actual data coming in.  Once this is complete then I can begin working on taking in data through ethernet connection instead of serial.