private void button1_Click(object sender, EventArgs e)
{
if (lastSelectedId != "")
{
MysqlHandler mysql = new MysqlHandler(watchProfil);
mysql.connect();
string sql = "KILL " + lastSelectedId;
mysql.sql_update(sql);
mysql.disConnect();
kill_btn.Text = "KILL ";
}
}
public void getStartupData()
{
database = new MysqlHandler(sensorProfil);
database.connect();
if (database != null)
{
MySql.Data.MySqlClient.MySqlDataReader reader = database.sql_select("SHOW STATUS");
string name = "";
string value = "";
sensorListing.Items.Clear();
while (reader != null && reader.Read())
{
//userid = atAll.GetInt64(atAll.GetOrdinal("gladi_userid"));
//Data.Add();
name = reader.GetString(0);
value = reader.GetString(1);
sensorListing.Items.Add(name);
addToSensorTree(name);
PanelDrawing sensView = new PanelDrawing();
sensView.Name = name;
sensView.Width = flowLayout.Width - 6;
sensView.Height = 120;
sensView.BackColor = Color.FromArgb(0, 33, 0);
sensView.BorderStyle = BorderStyle.Fixed3D;
sensView.lineColor = Color.FromArgb(0, 254, 0);
sensView.positivColor = Color.FromArgb(0, 64, 0);
sensView.negativColor = Color.FromArgb(54, 0, 0);
sensView.Visible = false;
sensView.Dock = DockStyle.Top;
panelSensors.Add(sensView);
flowLayout.Controls.Add(panelSensors[panelSensors.Count - 1]);
}
if (reader != null)
{
reader.Close();
}
}
}
