Home forums Chart Support MVC application Connecting to SQL Database

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #28037

    Hi,

    Please assist me in the following
    I followed many links and i couldn’t successfully connect TO MY sql Db(As i am a beginner)
    I have a sample solution and sample DB
    1) In my DB i have a stored procedure “SalesData”
    2) Added to stored procedure to models.

    Now I need to get the data to the chart by TerrtoryID ,by sales person
    And also this should work as a dynamic chart refreshing every 5 seconds.

    Please find below link to download the solution and Db .

    https://chefmiddleeast-my.sharepoint.com/:f:/p/prathyush/ElFUC_fofGlAjWw2_RitAdMBmsQ4M_LAWqG6-XEBPutWfA?e=3dXPuI

    Thanks in advance
    Prathyush

    #28083

    Prathyush,

    Please take a look at this article for step-to-step tutorial on connecting to MySQL database and reading data from it, along with sample code and screenshots.


    Vishwas R
    Team CanvasJS

    #28084

    Thank you Vishwas,

    Can you please share the similar article for connecting to MS SQL database stored procedure using .NET MVC

    Prathyush

    #28117

    Prathyush,

    Please refer Microsoft Documentation for tutorials and code related to MS SQL database connectivity.

    This forum is dedicated to queries related to CanvasJS, you can post your queries in Stack Overflow for programming specific queries.


    Vishwas R
    Team CanvasJS

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.