void data_name_udate(SQLiteConnection m_dbConnection) { data_name.SelectedItem = null; data_name.Items.Clear(); m_dbConnection.Open(); string sql = "SELECT id_name.id, fio, mark_math, mark_physics FROM id_name,id_mark WHERE id_name.id = id_mark.id ORDER BY id_name.id"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { //создание строки var data = new Cmark { id = int.Parse(reader[0].ToString()), fio = reader[1].ToString(), mark_math = reader[2].ToString(), mark_physics = reader[3].ToString() }; //добавление строки в DataGrid data_name.Items.Add(data); } m_dbConnection.Close(); }
private void data_name_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (data_name.SelectedItem != null) { //получение строки из DataGrid Cmark test = (Cmark)data_name.SelectedItem; Editor edit = new Editor(); edit.id_tb.Text = test.id.ToString(); edit.name_tb.Text = test.fio.ToString(); edit.math_tb.Text = test.mark_math.ToString(); edit.physics_tb.Text = test.mark_physics.ToString(); //m_dbConnection.Open(); //string mark_math = ""; //string mark_physics = ""; //string sql = "SELECT * FROM id_mark ORDER BY id"; //SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); //SQLiteDataReader reader = command.ExecuteReader(); //while (reader.Read()) //{ // if (int.Parse(reader[0].ToString()) == int.Parse(test.id.ToString())) // { // mark_math = reader[1].ToString(); // mark_physics = reader[2].ToString(); // } //} //edit.math_tb.Text = mark_math; //edit.physics_tb.Text = mark_physics; edit.ShowDialog(); if (edit.DialogResult == true) { data_name_udate(m_dbConnection); } //m_dbConnection.Close(); } }