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