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