using MySql.Data.MySqlClient; //... MySqlConnection conn = new MySqlConnection(connectionString); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM table"; MySqlDataReader rdr = cmd.ExecuteReader();
using MySql.Data.MySqlClient; //... MySqlConnection conn = new MySqlConnection(connectionString); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO table (column1, column2) VALUES (@val1, @val2)"; cmd.Parameters.AddWithValue("@val1", "value1"); cmd.Parameters.AddWithValue("@val2", "value2"); cmd.ExecuteNonQuery();In this example, MySqlConnection and MySqlCommand classes are used to create and execute an INSERT query on a MySQL database table along with parameterized values. The above examples use the MySQL.Data NuGet package library which can be downloaded and installed using the NuGet package manager in Visual Studio.