MVC application Connecting to SQL Database

[prathyush@chefmiddleeast.com]

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

[Vishwas R]

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

[prathyush@chefmiddleeast.com]

Thank you Vishwas,

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

Prathyush

[Vishwas R]

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