using MySql.Data.MySqlClient;

using System;

​

namespace MySQLConnectionExample

{

    class Program

    {

        public static void Main(string[] args)

        {

            //your MySQL connection string

            string connStr = "server=mysql.gvit.ac.in;user=csharpusr;database=csharp;port=3306;password=cSHRp##@";

​

            MySqlConnection conn = new MySqlConnection(connStr);

            try

            {

                Console.WriteLine("Connecting to MySQL...");

                conn.Open();

​

                //SQL Query to execute

                //selecting only first 10 rows for demo

                string sql = "select * from test limit 0,10;";

                MySqlCommand cmd = new MySqlCommand(sql, conn);

                MySqlDataReader rdr = cmd.ExecuteReader();

​

                //read the data

                while (rdr.Read())

                {

                    Console.WriteLine(rdr[0] + " -- " + rdr[1] + " -- " + rdr[2]);

                }

                rdr.Close();

            }

            catch (Exception err)

            {

                Console.WriteLine(err.ToString());

            }

​

            conn.Close();

            Console.WriteLine("Connection Closed. Press any key to exit...");

            //Console.Read();

        }

    }

}