Modern UI Design Project Tutorial No. 2
Modern UI Design Project Tutorial No. 2 – Database & Settings
Here on our 2nd video tutorial for Modern UI Design Project we will cover about saving user settings and connect our application to a MySql server. This tutorial will include on how to create MySql database and table. If you don’t know on how to install and configure MySql please check out my blog post How To Install mySQL in Windows 10, you can also check MySql Statements You Should Know from where you can get learn on how to create database and table.
Storing user settings
One of the focus of this tutorial is on how to store user settings. There are several ways on how to store user settings. One is by saving it to registry, second is use a custom XML and the easiest one is using the Settings file of visual studio.
.NET Framework allows you to create and access values that are persisted between application execution sessions. These values are called settings. Settings can represent user preferences, or valuable information the application needs to use. MSDN
Connect project to a MySql server
Another focus of this tutorial is on how to connect our project to a MySql server. Before we can connect MySql server to our project we need to install MySql .net connector, you can use NuGet or you can just follow my my blog post How To Use MySql Connector Net
Learn more about User Settings and Application Settings
MySql Connection String
"Server=[server name];Port=[port no.];Database=[database name];Uid=[db username];Pwd=[db password];";
If you find this post interesting please subscribe to our YouTube channel DenRic Denise INFO
You can now download the project on this tutorial here.