private void PreencheDataGridAluno()
{
SQLiteConexao conexao = new SQLiteConexao();
SQLiteConnection conn = conexao.GetConexao();
string query = "SELECT cpf, nome, email, STRFTIME('%d/%m/%Y',datanasc) AS 'Data de Nascimento' FROM Alunos;";
SQLiteCommand command = new SQLiteCommand(query, conn);
DataTable dt = new DataTable("Alunos");
SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(dt);
dataGridAluno.ItemsSource = dt.DefaultView;
conn.Close();
}
private void PreencheDataGridAV(string nome)
{
SQLiteConexao conexao = new SQLiteConexao();
SQLiteConnection conn = conexao.GetConexao();
string query = "SELECT id, STRFTIME('%d/%m/%Y',data) as 'Data de criação', tipo FROM AvaliacaoFisica where cpf_aluno like '" + cpfAluno + "';";
SQLiteCommand command = new SQLiteCommand(query, conn);
DataTable dt = new DataTable("AvaliacaoFisica");
SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(dt);
dataGridAV.ItemsSource = dt.DefaultView;
conn.Close();
}
