C#MySQLConnector

namespace ConsoleApplication4
{
    class Program
    {
        static void Main(string[] args)
        {
            MySqlConnection conn = new MySqlConnection("Server = localhost;Database=inv;Uid=root;Pwd=root;");

            conn.Open();

            MySqlCommand cmd = new MySqlCommand("SELECT * FROM foxhound;", conn);
            MySqlDataReader read = cmd.ExecuteReader();
            while (read.Read())
            {
                Console.WriteLine("{0}", read.GetString(0));
            }
        Object ret = cmd.ExecuteScalar();
        Console.WriteLine("# of lines: " + ret.ToString());

            conn.Close();
            Console.ReadKey();
        }
    }
}

to change, use cmd.ExecuteNonQuery();