LogsPage.cs 815 B

1234567891011121314151617181920212223242526272829303132333435
  1. using Npgsql;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Data;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11. namespace TestsManipulate
  12. {
  13. public partial class LogsPage : Form
  14. {
  15. public LogsPage()
  16. {
  17. InitializeComponent();
  18. LoadData();
  19. }
  20. private void LoadData()
  21. {
  22. var conn = new NpgsqlConnection(Program.connString);
  23. conn.Open();
  24. var cmd = new NpgsqlCommand("select * from logs", conn);
  25. var reader = cmd.ExecuteReader();
  26. var dt = new DataTable();
  27. dt.Load(reader);
  28. dataGridView1.DataSource = dt;
  29. conn.Close();
  30. }
  31. }
  32. }