I have system in the field that take measurements every minute and write them to a file which is sent to location and parsed into a DB. I then need to put the information into a graph for the custom to see on a Website. The customer needs to be able to change to time interval for the graph. I have all of that working, my problem is that I am trying to get the data from the DB to graph. I can the Data to the graph but not the date\time to the graph. Our data and time stamp is the same as EditRangeDateTimeFormatMode: LongTime. How do I get the date\time from the DB to the graph. I am getting the Data from the DB to the Graph using the following VB.Net code:
Dim Label As String = ddlLabels.SelectedItem.Text.ToString
Dim Units As String = ddlLabels.SelectedValue.ToString
Dim Time As DateTime
Dim Points As Double
myConn.Open()
Dim aReader As OleDbDataReader = myCmd.ExecuteReader()
While aReader.Read
Points =
CDbl(aReader("value"))
Time = aReader(
"acqGMT")
ls.Text +=
"Value(" & aReader("acqGMT") & "): " & aReader("value") & "<Br />"
graph.PlotYAppend(Points)
End While
myConn.Close()
Can anyone please point me in the write direction.