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

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

        }

        public static void DataExport(DataGridView table, string tableName, string fileName)

        {

            XmlWriterSettings setting = new XmlWriterSettings();

            setting.Indent = true;

            setting.NewLineOnAttributes = true;

            setting.ConformanceLevel = ConformanceLevel.Auto;

            XmlWriter xmlW = XmlWriter.Create(fileName, setting);

            xmlW.WriteStartDocument();

            xmlW.WriteStartElement(tableName); 

            for (int i = 0; i < table.RowCount; i++)

            {

                xmlW.WriteStartElement(tableName);

                for (int j = 0; j < table.ColumnCount; j++)

                {

                    xmlW.WriteAttributeString(table.Columns[j].Name, table[j, i].Value.ToString());  

                }

                xmlW.WriteEndElement();

            }

            xmlW.WriteEndElement();

            xmlW.WriteEndDocument();

            xmlW.Close();

           

        } 

        public static void DataImport(DataTable table, string fileName)

        {

            XmlReader xmlR = XmlReader.Create(fileName);

            XmlNodeType el = xmlR.MoveToContent();

            table.Rows.Clear();

            int i = 0;

           

            while (!xmlR.EOF)

            {

                xmlR.Read();

                if (xmlR.NodeType == XmlNodeType.Element)

                {

                    DataRow row = table.NewRow();

                    row[0] = xmlR.GetAttribute(0);

                    for (int j = 1; j < table.Columns.Count; j++)

                    {

                        if (xmlR.GetAttribute(j) != "")

                            row[j] = xmlR.GetAttribute(j);

                        else

                            row[j] = 0;

                    }

                    table.Rows.Add(row);

                    i++;

                }

               

            }

            xmlR.Close();

        } 

        public static void TableSearch(DataGridView table, string tablename, string columnname, string value)

        {

            using (MySqlConnection connection = new MySqlConnection(ConnectionString))

            {

                connection.Open();

                MySqlCommand command = new MySqlCommand("CALL MyFind('" + tablename + "', '" + columnname + "', '" + value + "')", connection);

                MySqlDataAdapter adapter = new MySqlDataAdapter(command);

                DataTable dt = new DataTable();

                adapter.Fill(dt);

                table.DataSource = dt;

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

                SetColumnNames(table, tablename);

            }

        }

        public static void SortTable(DataGridView table, string[] columns, string tableName){

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

            {

                connection.Open();

                MySqlCommand command = new MySqlCommand("", connection);

                command.CommandText = "DROP View temp";

                command.ExecuteNonQuery();

               // MySqlCommand command = new MySqlCommand("CREATE VIEW  AS SELECT * FROM ", connection);

                command.CommandText = "CREATE VIEW temp AS SELECT * FROM " + tableName;

                if (columns.Length != 0)

                {

                    command.CommandText += " ORDER BY " + columns[0];

                    for(int i = 1; i < columns.Length; i++){

                        command.CommandText += ", " + columns[i];

                    } 

                }

                command.ExecuteNonQuery();

                command.CommandText = "SELECT * FROM temp";

                MySqlDataAdapter adapter = new MySqlDataAdapter(command);

                DataTable dt = new DataTable();

                adapter.Fill(dt);

                table.DataSource = dt;

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

                SetColumnNames(table, tableName);

            }

        }

        public static void SetColumnNameShelf(DataGridView table)

        {

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

            table.Columns[1].HeaderText = "Номер стеллажа";

            table.Columns[2].HeaderText = "Количество книг";

        }

        public static void SetColumnNameStellash(DataGridView table)

        {

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

            table.Columns[1].HeaderText = "Количество полок";

            table.Columns[2].HeaderText = "ИД_комнаты";

        }

        public static void SetColumnNameRooms(DataGridView table)

        {

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

            table.Columns[1].HeaderText = "Назначение";

            table.Columns[2].HeaderText = "Количество стеллажей";

            table.Columns[3].HeaderText = "Количество столов";

            table.Columns[4].HeaderText = "Количество компьютеров";

        }

        public static void SetColumnNameLibrarian(DataGridView table)

        {

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

            table.Columns[1].HeaderText = "Имя";

            table.Columns[2].HeaderText = "ИНН";

            table.Columns[3].HeaderText = "Пол";

            table.Columns[4].HeaderText = "Возраст";

            table.Columns[5].HeaderText = "Опыт работы";

            table.Columns[6].HeaderText = "Отдел"; ;

        }

       /* public static void SetColumnNameCatalog(DataGridView table)

        {