c# mysql code example
Example: c# mysql query
MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM customers",con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//You can get values from column names
Console.WriteLine(reader["customerName"].ToString());
//Or return the value from the columnID, in this case, 0
Console.WriteLine(reader.GetInt32(0));
}
con.Close();