CONNECTION TO MYSQL IN VISUAL STUDIO 2022
This video shows you how to connect to MySQL database from Visual Studio 2022
The link MySql.Data is:
https://www.nuget.org/packages/MySql.Data/8.0.29?_src=template#versions-body-tab
CLI command to run in command prompt is:
dotnet add package MySql.Data –version 8.0.29
dotnet add package MySql.Data –version 8.0.29
Code for testing connection is:
using MySql.Data.MySqlClient;
string connetionString = null;
MySqlConnection cnn;
connetionString = “server=localhost;database=school;uid=root;pwd=””;”;
cnn = new MySqlConnection(connetionString);
try
{
cnn.Open();
MessageBox.Show(“Connection Open ! “);
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show(“Can not open connection ! “);
}
Comments are closed.