databank_program

using System;
using MySql.Data.MySqlClient;

namespace DatabaseServer
{
    class Program
    {


        static void Main(string[] args)
        {
            string cs = @"server=127.0.0.1;port=3306;password=mypwd;userid=root;database=databasename;";
            using var con = new MySqlConnection(cs);
            con.Open();

            string sql = "SELECT * FROM mytable;";
            using var cmd = new MySqlCommand(sql, con);

            using MySqlDataReader rdr = cmd.ExecuteReader();

            while (rdr.Read())
            {
                Console.WriteLine("{0} {1} {2}", rdr.GetInt32(0), rdr.GetString(1),
                    rdr.GetInt32(2));
            }
        }


    }
}