A quick start project for connecting a MySQL database to a Syncfusion Pivot Table. This repository includes a Web API Controller (MyWebService) for retrieving data from a MySQL database, as well as a quick start sample in the JavaScript platform that displays the retrieved data in a Syncfusion Pivot Table.
Before beginning work on the server and client projects, ensure the following software to be installed in the machine.
- git
- Node.js
- Visual Studio Code
- Visual Studio 2022 and .NET Core SDK 6.0 or later installed on your machine
-
To run this application, clone the how-to-bind-MySQL-database-to-pivot-table repository and then open MyWebService project in Visual Studio 2022. Simply build and run your project in IIS Express, and it will host and display the URL
https://localhost:7146. -
Now open the JavaScript sample in Visual Studio Code. Initialize the Pivot Table, map the hosted URL, create a pivot report, and finally, open the index.html file in your browser to run your project.