private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { TreeNode node = treeView1.SelectedNode; // MessageBox.Show(""+node.Text); try { int number_function; int device_number; using (TextReader reader = File.OpenText("data1.txt")) { number_function = int.Parse(reader.ReadLine()); device_number = int.Parse(reader.ReadLine()); } string commandSQL = "SELECT * FROM Data;";// + node.Text + ";";//TABLE_VALUES_REGISTERS_" + "1;";//device_number + ";"; dataGridViewTableDB.DataSource = mySqlHelper.GetTable(commandSQL); } catch (Exception ex) { MessageBox.Show("" + ex); } }
private void UpdateGraphic_Date(string commandSQL, int row_date, int row_other_line) { DataTable dt = mySqlHelper.GetTable(commandSQL); int M = dt.Columns.Count; int N = dt.Rows.Count; DateTime[] x = new DateTime[N]; double[] y = new double[N]; for (int i = 0; i < N; i++) { x[i] = Convert.ToDateTime(dt.Rows[i][row_date]); y[i] = Convert.ToInt32(dt.Rows[i][row_other_line]); } ShowGraphic(chart1, x, y, "Дата: " + String.Format("{0:dd/MM/yyyy}", x[0]), ""); }
private void setFilter(string commandSQL) { DataTable dt = mySqlHelper.GetTable(commandSQL); int M = dt.Columns.Count; int N = dt.Rows.Count; if (N == 0 && M == 0) { MessageBox.Show("Дані на цей день відсутні."); } else { string result = ""; result = "\nДані з параметром " + paramFilter + ":\n" + "День: " + String.Format("{0:dd/MM/yyyy}", dt.Rows[0][0]) + "\n"; result += "Device_number: " + Math.Round(Convert.ToDouble(dt.Rows[0][1]), 1).ToString() + " \n"; result += "Register_number: " + Math.Round(Convert.ToDouble(dt.Rows[0][2]), 1).ToString() + " \n"; result += "Value_register: " + Math.Round(Convert.ToDouble(dt.Rows[0][3]), 1).ToString() + " \n"; richTextBox1.AppendText(result); } }