[C#] mysql 사용하기

아래 사이트에서 mysql-connector 다운로드

https://downloads.mysql.com/archives/c-net/

Operation System : .Net & Mono 선택

Version은 본인이 원하는 것으로 선택.

using MySql.Data.MySqlClient;
using MySql.Data;
using System.Data;
using System;
 
namespace sports
{
    class test
    {
        //Insert, Delete, Update 사용 
        static void writefunc()
        {
            /*
            string strconn = "Server={     server ip     };" +
                "Database={       access Database        };" +
                "Uid={                id                 };" +
                "Pwd={                pw                 };" +
                "port={       port (Default : 3306)      };" +
                "SSLMode=none;";
                */
 
            string strconn = "Server=localhost;Database=db20181026;Uid=root;Pwd=abbcc;port=3306;SSLMode=none;";
 
            MySqlConnection conn = new MySqlConnection(strconn);
 
            conn.Open();
            string sql = "DELETE FROM table";
            MySqlCommand cmd = new MySqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
 
    
 
        //Select : Disconnect 상태로 조회
        static void loadfunc()
        {
            string strconn = "Server=localhost;Database=db20181026;Uid=root;Pwd=abbcc;port=3306;SSLMode=none;";
            MySqlConnection conn = new MySqlConnection(strconn);
 
            DataSet ds = new DataSet();
 
            string sql = "SELECT index,content FROM tables";
            MySqlDataAdapter msda = new MySqlDataAdapter(sql, conn);
            msda.Fill(ds, "tables");
            if(ds.Tables.Count > 0)
            {
                foreach(DataRow dr in ds.Tables[0].Rows)
                {
                    Console.WriteLine(dr["index"]);
                    Console.WriteLine(dr["content"]);
                }
            }
        }
    }
}