private void AddRecBtn_Click(object sender, EventArgs e)
        {
            var form = new NewRecordForm((int)dataGridView1.SelectedRows[0].Cells[0].Value);

            form.ShowDialog();
            PostgresConnector.FirstInitialize(ref dataSet);
        }
        private void toolStripButton1_Click_1(object sender, EventArgs e)
        {
            var form = new NewCardForm();

            form.ShowDialog();
            if (form.DialogResult == DialogResult.OK)
            {
                dataSet = new DataSet();
                PostgresConnector.FirstInitialize(ref dataSet);
            }
        }
 public MainWindow()
 {
     PostgresConnector.FirstInitialize(ref dataSet);
     InitializeComponent();
     dataGridView1.DataSource = dataSet.Tables["Амбулаторные карты"].DefaultView;
     foreach (DataGridViewColumn column in dataGridView1.Columns)
     {
         column.SortMode = DataGridViewColumnSortMode.NotSortable;
     }
     dataGridView2.DataSource = dataSet.Tables["Амбулаторные записи"].DefaultView;
     foreach (DataGridViewColumn column in dataGridView2.Columns)
     {
         column.SortMode = DataGridViewColumnSortMode.NotSortable;
     }
 }
        private void DeleteRecBtn_Click(object sender, EventArgs e)
        {
            int record = (int)dataGridView2.SelectedRows[0].Cells[0].Value;
            var result = MessageBox.Show(String.Format("Вы действительно хотите удалить запись №{0}?", record), "Внимание", MessageBoxButtons.YesNo);

            if (result == DialogResult.Yes)
            {
                var form = new Password();
                form.ShowDialog();
                if (form.DialogResult == DialogResult.OK)
                {
                    PostgresConnector.DeleteRecord(record);
                }
            }
            PostgresConnector.FirstInitialize(ref dataSet);
            dataGridView2.Refresh();
        }