// A felhasznált osztály:
    public class szamla // id,AccNo,StopOut,balance,equity,floating,hid,par1,par2,szamlairany,kor_id,TradeStartTime
    {
        public Int64 ID { get; set; }
        public Int32 AccNo { get; set; }
        public Int32 StopOut { get; set; }
        public float Balance { get; set; }
        public float Equity { get; set; }
        public float Floating { get; set; }
        public Int32 Hid { get; set; }
        public Int32 Par1 { get; set; }
        public Int32 Par2 { get; set; }
        public Int32 Szamlairany { get; set; }
        public Int32 Kor_id { get; set; }
        public Int32 TradeStartTime { get; set; }
    }

        protected List<szamla> szamlak = new List<szamla>();

        private void btn_accounts_Click(object sender, RoutedEventArgs e) // számlák megtekintése
        {
            aktive_menu = 2;
            account_list.DataContext = GetSzamlak();
            ablakok_lathatosaga();
        }

        private List<szamla> GetSzamlak() // számlák beolvasása az adatbázisból
        {
            string ConnString = "datasource=" + srv + ";port=" + prt + ";uid=" + dB_felh + ";password=" + dB_jsz;
            string Query = "SELECT * FROM " + dB_name + ".szamlak ORDER BY id;";
            using (MySqlConnection myConnDb = new MySqlConnection(ConnString))
            {
                using (MySqlCommand CommDb = new MySqlCommand(Query, myConnDb))
                {
                    MySqlDataReader myReader;
                    try
                    {
                        myConnDb.Open();
                        myReader = CommDb.ExecuteReader();
                        while (myReader.Read())
                        {
                            szamla szamla = new szamla()
                            { // id,AccNo,StopOut,balance,equity,floating,hid,par1,par2,szamlairany,kor_id,TradeStartTime
                                ID = myReader.GetInt32("id"),
                                AccNo = myReader.GetInt32("AccNo"),
                                StopOut = myReader.GetInt32("StopOut"),
                                Balance = myReader.GetInt32("balance"),
                                Equity = myReader.GetInt32("equity"),
                                Floating = myReader.GetInt32("floating"),
                                Hid = myReader.GetInt32("hid"),
                                Par1 = myReader.GetInt32("par1"),
                                Par2 = myReader.GetInt32("par2"),
                                Szamlairany = myReader.GetInt32("szamlairany"),
                                Kor_id = myReader.GetInt32("kor_id"),
                                TradeStartTime = myReader.GetInt32("TradeStartTime"),
                            };
                            szamlak.Add(szamla);
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
            return szamlak;
        }