public static void Update()
{
AccessHandler.SQLkomentoTaulu("DELETE * FROM komennot");
AccessHandler.Viesti("Rivejä on " + DT.Rows.Count);
List <string> Hotkeyt = DT.AsEnumerable().Select(x => x[0].ToString()).ToList();
AccessHandler.Viesti(String.Join("\n", Hotkeyt));
foreach (DataRow DR in DT.Rows)
{
string[] rivi = new string[] { DR[0].ToString(), DR[1].ToString() };
AccessHandler.SQLkomentoINSERT(sarakkeet: sarakkeet, nimi: "Komennot", rivi: rivi);
}
KeyListenercs.DT = DT;
}
public static void Connect()
{
sarakkeet.Add("Hotkey");
sarakkeet.Add("Komento");
try
{
if (File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Avain\\Komennot.mdb"))
{
AccessHandler.Yhdista(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Avain\\Komennot.mdb");
}
else
{
AccessHandler.Yhdista("G:\\VS\\VisualStudio Projektit\\Projektit\\Avain\\Komennot.mdb");
}
AccessHandler.ViestienNaytto(true, true);
Komennot = AccessHandler.HaeTaulut(AccessHandler.EtsiTaulut())[0];
KeyListenercs.DT = Komennot;
}catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
}
