C#으로 MySql 접속

1. mysql-connector-net 설치

http://www.mysql.com/downloads/connector/net/

2. Reference에 추가 - MySql.Data

3. 소스에 적용

using MySql.Data;
using MySql.Data.MySqlClient;

static string DBConnectString = "Data Source=192.168.0.xxx;Database=db_name;" + "User Id=userid;Password=password" + ";charset=utf8";

MySqlConnection Con = new MySqlConnection();
Con.ConnectionString = DBConnectString;
            
try
{
    Con.Open();
         
    MySqlCommand Command = new MySqlCommand("SELECT * FROM table_name", Con);
    MySqlDataReader DataReader;
    DataReader = Command.ExecuteReader();

    while (DataReader.Read())
    {
         MappingTable MappingT = new MappingTable();
         MappingT.MappingNumber = string.Format("{0}", DataReader["table_column1"]);
         MappingT.UserId = string.Format("{0}", DataReader["table_column2"]);
         MappingT.SIP = string.Format("{0}", DataReader["table_column3"]);
         MappingTList.Add(MappingT);
    }
    DataReader.Close();
    Con.Close();
}

catch (MySqlException ex)
{
    MessageBox.Show(ex.ToString());
}