Graph data

[kiffab]

Hi Guys

I'm going to try and grab some data from a SQL database table and display visually on AutoIt GUI as a line graph. I'll refresh this every hour or so. Firstly, is this possible? If so, what's the best way to read the data in order to build X and Y axis and also plot the points? ( I know how to do the SQL bit... more interested in the graphing side)

My data will look like this:

Time | Value

9 - 10 | 1420

10 - 11 | 1100

Appreciate any pointers =)

Thanks.

Edited August 20, 2012 by kiffab

[Melba23]

kiffab,

I have used the GraphGDIPlus UDF very successfully to graph data.

M23

[kiffab]

Hi M23

Are there working examples of this? It looks like what I need but not quite sure how to use it. How would I get my data range, for example?

Thanks.

[JLogan3o13]

There is a working example in the first post of the page that Melba is directing you to.

[kiffab]

Sorry, I just downloaded the file. I'll have a look at this

[kiffab]

Ok, so far I have pulled data from SQL table in order to build the x and y axis. I am using max and min values to determine values for x as this will be a time.

$conn = ObjCreate( "ADODB.Connection" )
$DSN = "DRIVER={SQL Server};SERVER=Server1;DATABASE=DB1;UID=hello;PWD=12345;"
$conn.Open($DSN)

$RS1 = ObjCreate("ADODB.RecordSet")

$RS1.Open("SELECT min(hour) 'min' FROM DB1.dbo.events", $conn)

If $RS1.RecordCount Then
    While Not $RS1.EOF
        $minX = $RS1.Fields("min").value & "00"
        $RS1.MoveNext
    WEnd
EndIf

I then use this:

_GraphGDIPlus_Set_RangeX($Graph,$minX,$maxX,6,1,0)
_GraphGDIPlus_Set_RangeY($Graph,0,2000,5,1,0)

I was then planning to use a SQL statement to identify each point since there will only be one for each hour of the day between 9 and 5.

I'd then plot these points and join the dots.

Does that seem like a sensible way to do things or should I have less SQL interaction? i.e. query db, write to array, use content.

Thanks.

[Zedna]

Very simple/nice GDI+ draw curve example is here