using System;
using System.Windows.Forms;
using Npgsql;

namespace Automated_WorkPlace_Library
{
    public partial class FormMain : Form
    {
        public NpgsqlConnection connection { get; set; } = null;
        public FormMain()
        {
            InitializeComponent();
        }

        private void FormMain_Load(object sender, EventArgs e)
        {
            connection = ConnectToDB("test", "123");
            connection.Open();

            var adapter_Books = new NpgsqlDataAdapter("select * from books", connection);
            adapter_Books.Fill(DS_Books, "books");

            var adapter_Kinds = new NpgsqlDataAdapter("select * from kinds", connection);
            adapter_Kinds.Fill(DS_Books, "kinds");

            DS_Books.Relations.Add("kind_of_book", DS_Books.Tables["kinds"].Columns["id"], DS_Books.Tables["books"].Columns["kind"]);

            DGV_Books.DataSource = DS_Books.Tables[0];

            connection.Close();

        }
    }
}