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

namespace SQLtry2
{
    public partial class Form1 : Form
    {
        string serveraddress = "datasource=localhost;port=3306;username=root;password=jkd49Hzt";
        string commandstring = "SELECT * FROM tutschema.items";
        public Form1()
        {
            InitializeComponent();
        }

        private void btn_connect_Click(object sender, EventArgs e)
        {



                /*  MySqlConnection myconnect = new MySqlConnection(serveraddress);
                  myconnect.Open();
                  MySqlCommand cmd = new MySqlCommand();
                  cmd = cmd.Connection.CreateCommand();
                  cmd.CommandText = "SELECT name FROM tutschema.items";
                  MySqlDataReader reader = cmd.ExecuteReader();
                  MessageBox.Show("Connected");*/
                MySqlConnection connection = new MySqlConnection(serveraddress);
                MySqlCommand command = new MySqlCommand();
                command.CommandText = commandstring;
                MySqlDataReader reader;
                connection.Open();
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    string row = "";
                    for(int i = 0; i<= reader.FieldCount; i++)
                    {
                        row += reader.GetValue(i).ToString() + ", ";
                        Console.WriteLine(row);
                    }
                    connection.Close();
                }
        }


    }
}