[ElToredo]

So I’m going to do this in C# with Visual Studio and not in PHP as my webpage with the graphe is?
I added the two files in Visual Studio, what should I do now please? I don’t know the C# language unfortunately.

Tanguy.

• This reply was modified 7 years, 3 months ago by ElToredo.

[ElToredo]

Indeed, my question is: How to solve the problem that I posted above with the database files that you gave me? How will it help me to extract the points et fill the graph with them automatically?

I’m not a total beginner in code but I may have difficulties to understand sometimes.

[ElToredo]

It’s okay, what’s next?
Thanks for the answer!

[ElToredo]

May I up the topic please sir?

[ElToredo]

(My post must have vanished)

Hello,

I must say that I’m kind of lost in the code. I have like 2000 values and for each one of them, a date associated and I would like to put them into my graph, in the following way for which I put the points myself :

data: [
      {        
        type: "line",
        color: "rgb(85, 118, 180)",
        showInLegend: true,
        markerSize: 0,
        legendMarkerType: "line",
        legendText: "FONDS",
        lineThickness: 2,
        dataPoints: [
        { x: new Date(2006, 00, 05), y: 0.00 },
        { x: new Date(2006, 00, 07), y: 0.08 },
        { x: new Date(2006, 00, 08), y: 0.07 },
        { x: new Date(2006, 00, 09), y: 0.09 },
        { x: new Date(2006, 00, 11), y: 0.12 },
        { x: new Date(2006, 00, 13), y: 0.16 },
        { x: new Date(2006, 00, 14), y: 0.11 },
        { x: new Date(2006, 00, 15), y: 0.12 },
        { x: new Date(2006, 00, 17), y: 0.14 },
        { x: new Date(2006, 00, 19), y: 0.22 },
        { x: new Date(2006, 00, 20), y: 0.24 },
        { x: new Date(2006, 00, 21), y: 0.26 },
        { x: new Date(2006, 00, 22), y: -0.05 },
        { x: new Date(2006, 00, 24), y: 0.08 },
        { x: new Date(2006, 00, 25), y: 0.15 },
        { x: new Date(2006, 00, 26), y: 0.36 },
        { x: new Date(2006, 00, 28), y: 0.34 },
        { x: new Date(2006, 00, 30), y: 0.33 },
        { x: new Date(2006, 01, 01), y: 0.33 },
        { x: new Date(2006, 01, 02), y: 0.45 },
        { x: new Date(2006, 01, 03), y: 0.25 },
        { x: new Date(2006, 01, 05), y: 0.60 },
        { x: new Date(2006, 01, 06), y: 0.62 },
        { x: new Date(2006, 01, 07), y: 0.67 },
        { x: new Date(2006, 01, 09), y: 0.50 },
        { x: new Date(2006, 01, 11), y: 0.85 },
        { x: new Date(2006, 01, 12), y: 1.20 },
        { x: new Date(2006, 01, 13), y: 0.78 },
        { x: new Date(2006, 01, 14), y: 0.92 },
        { x: new Date(2006, 01, 16), y: 0.95 },
        { x: new Date(2006, 01, 17), y: 1.36 },
        { x: new Date(2006, 01, 18), y: 1.32 },
        { x: new Date(2006, 01, 20), y: 1.36 },
        { x: new Date(2006, 01, 22), y: 1.23 },
        { x: new Date(2006, 01, 23), y: 1.52 },
        { x: new Date(2006, 01, 24), y: 1.60 }
        ]
      }
      ]

I would like to understand how to use this sample project to be able to extract those points in my database, which are written in this way : YYYY-MM-DD for the dates (like 2017-08-16) and XXX.XX for the values (like 952.25).

Could you help me please? I’m using SQL Server and Microsoft SQL Server Management to handle my database.

Thanks!
Tanguy.

[ElToredo]

Hello,

I must say that I’m kind of lost in the code. I have like 2000 values and for each one of them, a date associated and I would like to put them into my graph, in the following way for which I put the points myself :

data: [
      {        
        type: "line",
        color: "rgb(85, 118, 180)",
        showInLegend: true,
        markerSize: 0,
        legendMarkerType: "line",
        legendText: "FONDS",
        lineThickness: 2,
        dataPoints: [
        { x: new Date(2006, 00, 05), y: 0.00 },
        { x: new Date(2006, 00, 07), y: 0.08 },
        { x: new Date(2006, 00, 08), y: 0.07 },
        { x: new Date(2006, 00, 09), y: 0.09 },
        { x: new Date(2006, 00, 11), y: 0.12 },
        { x: new Date(2006, 00, 13), y: 0.16 },
        { x: new Date(2006, 00, 14), y: 0.11 },
        { x: new Date(2006, 00, 15), y: 0.12 },
        { x: new Date(2006, 00, 17), y: 0.14 },
        { x: new Date(2006, 00, 19), y: 0.22 },
        { x: new Date(2006, 00, 20), y: 0.24 },
        { x: new Date(2006, 00, 21), y: 0.26 },
        { x: new Date(2006, 00, 22), y: -0.05 },
        { x: new Date(2006, 00, 24), y: 0.08 },
        { x: new Date(2006, 00, 25), y: 0.15 },
        { x: new Date(2006, 00, 26), y: 0.36 },
        { x: new Date(2006, 00, 28), y: 0.34 },
        { x: new Date(2006, 00, 30), y: 0.33 },
        { x: new Date(2006, 01, 01), y: 0.33 },
        { x: new Date(2006, 01, 02), y: 0.45 },
        { x: new Date(2006, 01, 03), y: 0.25 },
        { x: new Date(2006, 01, 05), y: 0.60 },
        { x: new Date(2006, 01, 06), y: 0.62 },
        { x: new Date(2006, 01, 07), y: 0.67 },
        { x: new Date(2006, 01, 09), y: 0.50 },
        { x: new Date(2006, 01, 11), y: 0.85 },
        { x: new Date(2006, 01, 12), y: 1.20 },
        { x: new Date(2006, 01, 13), y: 0.78 },
        { x: new Date(2006, 01, 14), y: 0.92 },
        { x: new Date(2006, 01, 16), y: 0.95 },
        { x: new Date(2006, 01, 17), y: 1.36 },
        { x: new Date(2006, 01, 18), y: 1.32 },
        { x: new Date(2006, 01, 20), y: 1.36 },
        { x: new Date(2006, 01, 22), y: 1.23 },
        { x: new Date(2006, 01, 23), y: 1.52 },
        { x: new Date(2006, 01, 24), y: 1.60 }
        ]
      }
      ]

I would like to understand how to use this sample project to be able to extract those points in my database, which are written in this way : YYYY-MM-DD for the dates (like 2017-08-16) and XXX.XX for the values (like 952.25).

Could you help me please? I’m using SQL Server and Microsoft SQL Server Management to handle my database.

Thanks!
Tanguy.

• This reply was modified 7 years, 3 months ago by ElToredo.

[ElToredo]

I see the point, it should be okay, thanks again until the next time haha!

[ElToredo]

I have put a strip line at 0% on my graph. Is it possible to put a little line on it at each xAxis value?
Like on this dirty paint image: http://imgur.com/oUeMJ4f

[ElToredo]

Indranil,

Thanks a lot for your help, I couldn’t have expected something better, let’s work!

[ElToredo]

Any thoughts?

[ElToredo]

Here is my JSFiddle : http://jsfiddle.net/QwZuf/727/ (sorry for the multi-spam)

• This reply was modified 7 years, 3 months ago by ElToredo.

[ElToredo]

I can’t seem to find the edit button anymore.

Anyway, I’d like to add when I was speaking about the line appearence that I would like to have like the model in the ‘Axis Element’ chart tutorial, in this model, you don’t have any points except where you place your mouse. That would be amazing to have the same, is it possible?