コード例 #1
0
ファイル: MainForm.cs プロジェクト: Deret/-
        public void AddData(object sender, EventArgs e)
        {
            if (textBoxName.Text != "" && textBoxKindOfSport.Text != "" && textBoxManufacturer.Text != "" &&
                textBoxPrice.Text != "" && textBoxQuantityInStock.Text != "")
            {
                DataBaseSQL  dataBase = new DataBaseSQL();
                MySqlCommand command  = new MySqlCommand("INSERT INTO product (Name, KindOfSport, Manufacturer, Price, QuantityInStock) VALUES (@Name, @KindOfSport, @Manufacturer, @Price, @QuantityInStock)", dataBase.getConnection());

                command.Parameters.Add("@Name", MySqlDbType.VarChar).Value            = textBoxName.Text;
                command.Parameters.Add("@KindOfSport", MySqlDbType.VarChar).Value     = textBoxKindOfSport.Text;
                command.Parameters.Add("@Manufacturer", MySqlDbType.VarChar).Value    = textBoxManufacturer.Text;
                command.Parameters.Add("@Price", MySqlDbType.VarChar).Value           = textBoxPrice.Text;
                command.Parameters.Add("@QuantityInStock", MySqlDbType.VarChar).Value = textBoxQuantityInStock.Text;

                dataBase.openConnection();

                if (command.ExecuteNonQuery() == 1)
                {
                    MessageBox.Show("Данные добавленны");
                }
                else
                {
                    MessageBox.Show("Данные не добавленны");
                }

                dataBase.closeConnection();
            }
            else
            {
                MessageBox.Show("Данные введены некорректно");
            }
        }
コード例 #2
0
ファイル: MainForm.cs プロジェクト: ArthurRog/-
        public void OrderByData(object sender, EventArgs e)
        {
            string sql = "";

            if (ListOrderBy.Text == "id")
            {
                sql = "SELECT* FROM product ORDER BY id";
            }

            if (ListOrderBy.Text == "Название")
            {
                sql = "SELECT* FROM product ORDER BY Name";
            }

            if (ListOrderBy.Text == "Вид спорта")
            {
                sql = "SELECT* FROM product ORDER BY KindOfSport";
            }

            if (ListOrderBy.Text == "Производитель")
            {
                sql = "SELECT* FROM product ORDER BY Manufacturer";
            }

            if (ListOrderBy.Text == "Цена")
            {
                sql = "SELECT* FROM product ORDER BY Price";
            }

            if (ListOrderBy.Text == "Количество")
            {
                sql = "SELECT* FROM product ORDER BY QuantityInStock";
            }

            DataBaseSQL  dataBase = new DataBaseSQL();
            MySqlCommand command  = new MySqlCommand(sql, dataBase.getConnection());

            dataBase.openConnection();

            MySqlDataReader reader = command.ExecuteReader();

            OutputData.Clear();
            while (reader.Read())
            {
                OutputData.AppendText("id: " + reader[0].ToString()
                                      + "\nНазвание: " + reader[1].ToString()
                                      + "\nВид спорта: " + reader[2].ToString()
                                      + "\nПроизводитель: " + reader[3].ToString()
                                      + "\nЦена: " + reader[4].ToString()
                                      + "\nКоличество : " + reader[5].ToString() + "\n\n");
            }
            dataBase.closeConnection();
        }
コード例 #3
0
ファイル: MainForm.cs プロジェクト: Deret/-
        public void UpdateData(object sender, EventArgs e)
        {
            DataBaseSQL dataBase = new DataBaseSQL();

            MySqlCommand command = new MySqlCommand("UPDATE product SET Name = @Name, KindOfSport = @KindOfSport, Manufacturer = @Manufacturer, Price= @Price, QuantityInStock = @QuantityInStock WHERE id = @id", dataBase.getConnection());

            command.Parameters.Add("@id", MySqlDbType.VarChar).Value = textBoxId.Text;

            command.Parameters.Add("@Name", MySqlDbType.VarChar).Value            = textBoxUpdateName.Text;
            command.Parameters.Add("@KindOfSport", MySqlDbType.VarChar).Value     = textBoxUpdateKindOfSport.Text;
            command.Parameters.Add("@Manufacturer", MySqlDbType.VarChar).Value    = textBoxUpdateManufacturer.Text;
            command.Parameters.Add("@Price", MySqlDbType.VarChar).Value           = textBoxUpdatePrice.Text;
            command.Parameters.Add("@QuantityInStock", MySqlDbType.VarChar).Value = textBoxUpdateQuantityInStock.Text;
            dataBase.openConnection();

            command.ExecuteNonQuery();

            dataBase.closeConnection();
        }
コード例 #4
0
ファイル: MainForm.cs プロジェクト: Deret/-
        public void DeleteData(object sender, EventArgs e)
        {
            DataBaseSQL dataBase = new DataBaseSQL();

            dataBase.openConnection();

            MySqlCommand command = new MySqlCommand("DELETE FROM product WHERE id = @id", dataBase.getConnection());

            command.Parameters.Add("@id", MySqlDbType.VarChar).Value = DeleteTextBox1.Text;

            if (command.ExecuteNonQuery() == 1)
            {
                MessageBox.Show("Данные удалены");
            }
            else
            {
                MessageBox.Show("Данные не удалены");
            }

            dataBase.closeConnection();
        }
コード例 #5
0
ファイル: MainForm.cs プロジェクト: ArthurRog/-
        public void GetInfo(string sql)
        {
            DataBaseSQL  dataBase = new DataBaseSQL();
            MySqlCommand command  = new MySqlCommand(sql, dataBase.getConnection());

            command.Parameters.Add("@Search", MySqlDbType.VarChar).Value = SearchTextBox.Text;

            dataBase.openConnection();

            MySqlDataReader reader = command.ExecuteReader();

            OutputData.Clear();
            while (reader.Read())
            {
                OutputData.AppendText("id: " + reader[0].ToString()
                                      + "\nНазвание: " + reader[1].ToString()
                                      + "\nВид спорта: " + reader[2].ToString()
                                      + "\nПроизводитель: " + reader[3].ToString()
                                      + "\nЦена: " + reader[4].ToString()
                                      + "\nКоличество : " + reader[5].ToString() + "\n\n");
            }
            dataBase.closeConnection();
        }