C# & MySQL - How To Insert Data Into MySQL Database Using C# (codes in description)

#mysql #c# #visualstudio #sql #c#mysql

-------------CODES---------------

using MySql.Data.MySqlClient;

string connectionString = "Server=SERVER-ADDRESS;Database=DATABASE;Uid=USER;Pwd=PASSWORD;";


using (MySqlConnection connection = new MySqlConnection(connectionString))
{
try
{

connection.Open();


MySqlCommand cmd = new MySqlCommand(query, connection);




cmd.ExecuteNonQuery();

button1.Text = "Record added";

}
catch (MySqlException ex)
{

button1.Text = "Error !!";
}
}