Разработка приложения для учета книг в библиотеке

            table.Columns[0].HeaderText = "ИД";

            table.Columns[1].HeaderText = "Наличие на данный момент";

            table.Columns[4].HeaderText = "Дата взятия";

            table.Columns[2].HeaderText = "ИД_Стеллаж";

            table.Columns[3].HeaderText = "ИД_книги";

         }*/

        public static void SetColumnNameReaders(DataGridView table)

        {

            table.Columns[0].HeaderText = "ИД";

            table.Columns[1].HeaderText = "Предпочтения";

       

        }

        public static void SetColumnNameInformation(DataGridView table)

        {

            table.Columns[0].HeaderText = "ИД_книги";

            table.Columns[1].HeaderText = "ИД_библиотекаря";

            table.Columns[2].HeaderText = "ИД_читателя";

        }

    }

}

ForeignChoose.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace WindowsFormsApplication3

{

   

    public partial class ForeignChoose : Form

    {

        Util.ChoosFunction MyChoose;

        string TableName;

        public ForeignChoose(string tablename, Util.ChoosFunction choose)

        {

            InitializeComponent();

            MyChoose = choose;

            TableName = tablename;

        } 

        private void ForeignChoose_Load(object sender, EventArgs e)

        {

           using (MySqlConnection connection = new MySqlConnection(Util.ConnectionString)){

                MySqlCommand command = new MySqlCommand("SELECT * FROM " + TableName, connection);

                MySqlDataAdapter adapter = new MySqlDataAdapter(command);

                DataTable dt = new DataTable();

                adapter.Fill(dt);

                BindingSource bs = new BindingSource();

                bs.DataSource = dt;

                dataGridView1.DataSource = bs;

                dataGridView1.Columns["ID"].Visible = false;

                Util.SetColumnNames(dataGridView1, TableName);

            }

        } 

        private void button1_Click(object sender, EventArgs e)

        {

            if (dataGridView1.SelectedRows.Count != 0)

            {

                MyChoose(dataGridView1.SelectedRows[0].Cells["ID"].Value.ToString());

                Close();

            }

            else

            {

                MessageBox.Show("Выберите строку,  либо воспользуйтесь крестиком в правом верхнем углу, чтобы ничего не выбирать");

            }

        }

    }

}

Books.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace WindowsFormsApplication3

{

    public partial class Books : Form

    {

        public Books()

        {

            InitializeComponent();

        } 

        private void button1_Click(object sender, EventArgs e)

        { 

        }

        bool bEndBuild = true;

        DataTable dt;

        private void Books_Load(object sender, EventArgs e)

        {

            using (MySqlConnection connection = new MySqlConnection(Util.ConnectionString))

            {

                bEndBuild = false;

                MySqlCommand command = new MySqlCommand("SELECT * FROM books", connection);

                MySqlDataAdapter adapter = new MySqlDataAdapter(command);

                dt = new DataTable();

                adapter.Fill(dt);

                BindingSource bs = new BindingSource();

                bs.DataSource = dt;

                dataGridView1.DataSource = bs;

                dataGridView1.Columns["ID"].Visible = false;

                Util.SetColumnNames(dataGridView1, "Books");

                bEndBuild = true;

            }

           

        } 

        private void SetReader(string value)

        {

            dataGridView1.SelectedRows[0].Cells["ID_Reader"].Value = value;

            dataGridView1.SelectedRows[0].Cells["ID_Reader"].Tag = 1;

        }

        private void SetShelf(string value)

        {

            dataGridView1.SelectedRows[0].Cells["Shelf_ID"].Value = value;

            dataGridView1.SelectedRows[0].Cells["Shelf_ID"].Tag = 1;

        } 

        private void button3_Click(object sender, EventArgs e)

        {

            Info form = new Info("Shelf", "ID", dataGridView1.SelectedRows[0].Cells["Shelf_ID"].Value.ToString());

            form.Show();

        } 

        private void textBoxName_TextChanged(object sender, EventArgs e)

        {

            TextBox temp = sender as TextBox;

            if (dataGridView1.SelectedRows.Count != 0)

            {

                if (temp == textBoxAuthor)

                {