using System;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace ConnectCsharpToMysql
{
    //private string listBox1;
    
    public partial class Form1 : Form
    {
       //public Form1()
        //{
           // InitializeComponent();
        //}

        private void button1_Click(object sender, EventArgs e)
        {
            MySqlCommand command = new MySqlCommand(); ;
            string connectionString, commandString;
            connectionString = "Data source=127.0.0.1;UserId=uusername;Password=ppassword;database=ddatabase;";
            MySqlConnection connection = new MySqlConnection(connectionString);
            commandString = "SELECT * FROM ddatabase.ttable;";
            command.CommandText = commandString;
            command.Connection = connection;
            MySqlDataReader reader;
            try
            {
                command.Connection.Open();
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    listBox1.Items.Add(reader["id"]);
                    listBox1.Items.Add(reader["data"]);
                }
                reader.Close();
            }
            catch (MySqlException ex)
            {
                Console.WriteLine("Error: \r\n{0}", ex.ToString());
            }
            finally
            {
                command.Connection.Close();
            }
        }
    }
}