This example shows how to use Anychart library with the Visual Basic .NET programming language using ASP.NET and MySQL database.
This example uses .NET framework 4.6.1, ASP.NET 4.0.30319, ASP.NET MVC 5.2, Visual Studio 2015 Community, MySQL 5.6 and MySQL Connector/NET 6.9.9.0 - ADO.NET driver for MySQL.
To check your installations, please, use Windows Control Panel -> Programs and features.
If you miss some installations, please, visit:
MySQL download page and installation instructions to setup MySQL;
Visual Studio download page to install Visual Studio, .NET framework and ASP.NET;
Connector/Net download page to install MySQL Connector/NET.
To start this example run commands listed below.
Clone the repository from github.com to your working directory:
$ git clone [email protected]:anychart-integrations/asp-net-vb-mysql-template.git
Open cmd console in 'asp-net-vb-mysql-template' folder and set up MySQL database, use -u -p flags to provide username and password:
$ "[YOUR_PATH_TO_MYSQL]binmysql.exe" -u[USER_NAME] -p < database_backup.sql
e.g:
$ "C:Program FilesMySQLMySQL Server 5.6binmysql.exe" -uroot -p < database_backup.sql
Open project in Visual Studio using AspNetVBMysqlTemplate.sln solution file
Run application using Run button or press F5
If you have some problems with MySQL connection, ensure that MySql.Data.Entity.EF6 in References has correct path to MySql.Data.Entity.EF6.dll
Your workspace should look like:
AspNetVBMysqlTemplate/
App_Start/
RouteConfig.vb # app routes
Controllers/
ChartController.vb # main controller
css/
style.css # main css file
Models/
fruit.vb # Entity framework model for MySQL
FruitDBContext.vb # DB data provider
Views/
Chart/
Index.vbhtml # html template
web.config
Global.asax
packages.config
Web.config # main ASP.NET project settings
Language - VB.NET
Web framework - ASP.NET
Database Mapping - Entity Framework
HTML Tepmlate - Razor
Database - MySQL
AnyChart ASP.NET/VB/MySQL integration sample includes two parts:
If you have any questions regarding licensing - please contact us. [email protected]