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(); } } }