//
// oleDbDataAdapter1
//>oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;>oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;>oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;::array< System::Data::Common::DataColumnMapping^ >^ __mcTemp__1 = gcnew cli::array< System::Data::Common::DataColumnMapping^ >(8) {(gcnew System::Data::Common::DataColumnMapping(L"Назва","Назва")), (gcnew System::Data::Common::DataColumnMapping(L"Дата", L"Дата")), (gcnew System::Data::Common::DataColumnMapping(L"Країна","Країна")), (gcnew System::Data::Common::DataColumnMapping(L"Виробник", L"Виробник")), (gcnew System::Data::Common::DataColumnMapping(L"Ціна","Ціна")), (gcnew System::Data::Common::DataColumnMapping(L"Натуральний_вміст", L"Натуральний_вміст")), (gcnew System::Data::Common::DataColumnMapping(L"Хімічний_вміст","Хімічний_вміст")), (gcnew System::Data::Common::DataColumnMapping(L"Код", L"Код"))};>oleDbDataAdapter1->TableMappings->AddRange(gcnew cli::array< System::Data::Common::DataTableMapping^ >(1) {(gcnew System::Data::Common::DataTableMapping(L"Table","Парфуми", __mcTemp__1))});>oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
//
// Form1
//>AutoScaleDimensions = System::Drawing::SizeF(6, 13);>AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;>ClientSize = System::Drawing::Size(844, 532);>Controls->Add(this->label2);>Controls->Add(this->listBox1);>Controls->Add(this->label1);>Controls->Add(this->textBox1);>Controls->Add(this->button3);>Controls->Add(this->button2);>Controls->Add(this->button1);>Controls->Add(this->dataGridView1);>Name = L"Form1";>StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;>Text = L"Парфумерний магазин";>FormClosing += gcnew System::Windows::Forms::FormClosingEventHandler(this, &Form1::Form1_FormClosing);>Load += gcnew System::EventHandler(this, &Form1::Form1_Load);
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataSet1))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataTable1))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->bindingSource1))->EndInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataGridView1))->EndInit();>ResumeLayout(false);>PerformLayout();
}
#pragma endregion: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)
{^F2=gcnew Form2();->ShowDialog();
}: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e)
{i=dataGridView1->HitTestInfo->RowIndex->CellIndex;->Rows->RemoveAt(i);
}: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e)
{^st;=Directory::GetCurrentDirectory();>oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+st+"\\Парфуми.mdb";->Fill(dataTable1);
}: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e)
{>dataGridView1->DataSource ="";>dataGridView1->DataSource = this->bindingSource1;->Fill(dataTable1);
}: System::Void Form1_FormClosing(System::Object^ sender, System::Windows::Forms::FormClosingEventArgs^ e)
{->Update(dataTable1);
}: System::Void button3_Click(System::Object^ sender, System::EventArgs^ e)
{Pr;.get();.seargh();
}
};
}
#pragma once
#include "dani.h"kur{namespace System;namespace System::ComponentModel;namespace System::Collections;namespace System::Windows::Forms;namespace System::Data;namespace System::Drawing;namespace System::Data::OleDb;
/// <summary>
/// Сводка для Form2
/// </summary>ref class Form2 : public System::Windows::Forms::Form
{:(void)
{();
//
//TODO: добавьте код конструктора
//
}:
/// <summary>
/// Освободить все используемые ресурсы.
/// </summary>
~Form2()
{(components)
{components;
}
}: System::Windows::Forms::Label^ label1;:: System::Windows::Forms::TextBox^ textBox1;: System::Windows::Forms::TextBox^ textBox2;: System::Windows::Forms::Label^ label2;: System::Windows::Forms::TextBox^ textBox3;: System::Windows::Forms::Label^ label3;: System::Windows::Forms::TextBox^ textBox4;: System::Windows::Forms::Label^ label4;: System::Windows::Forms::TextBox^ textBox5;: System::Windows::Forms::Label^ label5;: System::Windows::Forms::TextBox^ textBox6;: System::Windows::Forms::Label^ label6;: System::Windows::Forms::TextBox^ textBox7;: System::Windows::Forms::Label^ label7;: System::Windows::Forms::Button^ button1;: System::Data::OleDb::OleDbConnection^ oleDbConnection1;: System::Data::DataSet^ dataSet1;: System::Data::DataTable^ dataTable1;: System::Data::DataColumn^ dataColumn1;: System::Data::DataColumn^ dataColumn2;: System::Data::DataColumn^ dataColumn3;: System::Data::DataColumn^ dataColumn4;: System::Data::DataColumn^ dataColumn5;: System::Data::DataColumn^ dataColumn6;: System::Data::DataColumn^ dataColumn7;: System::Data::DataColumn^ dataColumn8;: System::Data::OleDb::OleDbCommand^ oleDbSelectCommand1;: System::Data::OleDb::OleDbCommand^ oleDbInsertCommand1;: System::Data::OleDb::OleDbCommand^ oleDbUpdateCommand1;: System::Data::OleDb::OleDbCommand^ oleDbDeleteCommand1;: System::Data::OleDb::OleDbDataAdapter^ oleDbDataAdapter1;:
/// <summary>
/// Требуется переменная конструктора.
/// </summary>::ComponentModel::Container ^components;
#pragma region Windows Form Designer generated code
/// <summary>
/// Обязательный метод для поддержки конструктора - не изменяйте
/// содержимое данного метода при помощи редактора кода.
/// </summary>InitializeComponent(void)
{::ComponentModel::ComponentResourceManager^ resources = (gcnew System::ComponentModel::ComponentResourceManager(Form2::typeid));>label1 = (gcnew System::Windows::Forms::Label());>textBox1 = (gcnew System::Windows::Forms::TextBox());>textBox2 = (gcnew System::Windows::Forms::TextBox());>label2 = (gcnew System::Windows::Forms::Label());>textBox3 = (gcnew System::Windows::Forms::TextBox());>label3 = (gcnew System::Windows::Forms::Label());>textBox4 = (gcnew System::Windows::Forms::TextBox());>label4 = (gcnew System::Windows::Forms::Label());>textBox5 = (gcnew System::Windows::Forms::TextBox());>label5 = (gcnew System::Windows::Forms::Label());>textBox6 = (gcnew System::Windows::Forms::TextBox());>label6 = (gcnew System::Windows::Forms::Label());>textBox7 = (gcnew System::Windows::Forms::TextBox());>label7 = (gcnew System::Windows::Forms::Label());>button1 = (gcnew System::Windows::Forms::Button());>oleDbConnection1 = (gcnew System::Data::OleDb::OleDbConnection());>dataSet1 = (gcnew System::Data::DataSet());>dataTable1 = (gcnew System::Data::DataTable());>dataColumn1 = (gcnew System::Data::DataColumn());>dataColumn2 = (gcnew System::Data::DataColumn());>dataColumn3 = (gcnew System::Data::DataColumn());>dataColumn4 = (gcnew System::Data::DataColumn());>dataColumn5 = (gcnew System::Data::DataColumn());>dataColumn6 = (gcnew System::Data::DataColumn());>dataColumn7 = (gcnew System::Data::DataColumn());>dataColumn8 = (gcnew System::Data::DataColumn());>oleDbSelectCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbInsertCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbUpdateCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbDeleteCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbDataAdapter1 = (gcnew System::Data::OleDb::OleDbDataAdapter());
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataSet1))->BeginInit();
(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataTable1))->BeginInit();>SuspendLayout();
//
// label1
//>label1->AutoSize = true;>label1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label1->Location = System::Drawing::Point(12, 9);>label1->Name = L"label1";>label1->Size = System::Drawing::Size(61, 20);>label1->TabIndex = 0;>label1->Text = L"Назва";
//
// textBox1
//>textBox1->Location = System::Drawing::Point(16, 32);>textBox1->Name = L"textBox1";>textBox1->Size = System::Drawing::Size(312, 20);>textBox1->TabIndex = 1;
//
// textBox2
//>textBox2->Location = System::Drawing::Point(16, 85);>textBox2->Name = L"textBox2";>textBox2->Size = System::Drawing::Size(312, 20);>textBox2->TabIndex = 3;
//
// label2
//>label2->AutoSize = true;>label2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label2->Location = System::Drawing::Point(12, 62);>label2->Name = L"label2";>label2->Size = System::Drawing::Size(52, 20);>label2->TabIndex = 2;>label2->Text = L"Дата";
//
// textBox3
//>textBox3->Location = System::Drawing::Point(16, 135);>textBox3->Name = L"textBox3";>textBox3->Size = System::Drawing::Size(312, 20);>textBox3->TabIndex = 5;
//
// label3
//>label3->AutoSize = true;>label3->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label3->Location = System::Drawing::Point(12, 112);>label3->Name = L"label3";>label3->Size = System::Drawing::Size(64, 20);>label3->TabIndex = 4;>label3->Text = L"Країна";
//
// textBox4
//>textBox4->Location = System::Drawing::Point(16, 187);>textBox4->Name = L"textBox4";>textBox4->Size = System::Drawing::Size(312, 20);>textBox4->TabIndex = 7;
//
// label4
//>label4->AutoSize = true;>label4->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label4->Location = System::Drawing::Point(12, 164);>label4->Name = L"label4";>label4->Size = System::Drawing::Size(90, 20);>label4->TabIndex = 6;>label4->Text = L"Виробник";
//
// textBox5
//>textBox5->Location = System::Drawing::Point(16, 239);>textBox5->Name = L"textBox5";>textBox5->Size = System::Drawing::Size(312, 20);>textBox5->TabIndex = 9;
//
// label5
//>label5->AutoSize = true;>label5->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label5->Location = System::Drawing::Point(12, 216);>label5->Name = L"label5";>label5->Size = System::Drawing::Size(46, 20);>label5->TabIndex = 8;>label5->Text = L"Ціна";
//
// textBox6
//>textBox6->Location = System::Drawing::Point(16, 290);>textBox6->Name = L"textBox6";>textBox6->Size = System::Drawing::Size(312, 20);>textBox6->TabIndex = 11;
//
// label6
//>label6->AutoSize = true;>label6->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label6->Location = System::Drawing::Point(12, 267);>label6->Name = L"label6";>label6->Size = System::Drawing::Size(171, 20);>label6->TabIndex = 10;>label6->Text = L"Натуральний вміст";
//
// textBox7
//>textBox7->Location = System::Drawing::Point(16, 339);>textBox7->Name = L"textBox7";>textBox7->Size = System::Drawing::Size(312, 20);>textBox7->TabIndex = 13;
//
// label7
//>label7->AutoSize = true;>label7->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>label7->Location = System::Drawing::Point(12, 316);>label7->Name = L"label7";>label7->Size = System::Drawing::Size(131, 20);>label7->TabIndex = 12;>label7->Text = L"Хімічний вміст";
//
// button1
//>button1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 10, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point,_cast<System::Byte>(204)));>button1->Location = System::Drawing::Point(114, 377);>button1->Name = L"button1";>button1->Size = System::Drawing::Size(84, 27);>button1->TabIndex = 16;>button1->Text = L"Додати";>button1->UseVisualStyleBackColor = true;>button1->Click += gcnew System::EventHandler(this, &Form2::button1_Click);
//
// oleDbConnection1
//>oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\Anonimus\\Desktop\\kur\\kur\\Па""рфуми.mdb";
//
// dataSet1
//>dataSet1->DataSetName = L"NewDataSet";>dataSet1->Tables->AddRange(gcnew cli::array< System::Data::DataTable^ >(1) {this->dataTable1});
//
// dataTable1
//>dataTable1->Columns->AddRange(gcnew cli::array< System::Data::DataColumn^ >(8) {this->dataColumn1, this->dataColumn2,>dataColumn3, this->dataColumn4, this->dataColumn5, this->dataColumn6, this->dataColumn7, this->dataColumn8});>dataTable1->TableName = L"Table1";
//
// dataColumn1
//>dataColumn1->ColumnName = L"ПІБ";
//
// dataColumn2
//>dataColumn2->ColumnName = L"Дата народження";
//
// dataColumn3
//>dataColumn3->Caption = L"Адреса";>dataColumn3->ColumnName = L"Адрес";
//
// dataColumn4
//>dataColumn4->ColumnName = L"Освіта";
//
// dataColumn5
//>dataColumn5->ColumnName = L"Спеціальність";
//
// dataColumn6
//>dataColumn6->ColumnName = L"Дата влаштування";
//
// dataColumn7
//>dataColumn7->ColumnName = L"Зарплата";
//
// dataColumn8
//>dataColumn8->ColumnName = L"Телефон";
//
// oleDbSelectCommand1
//>oleDbSelectCommand1->CommandText = L"SELECT Назва, Дата, Країна, Виробник, Ціна, [Натуральний_вміст], [Хімічний_вміст]"", Код FROM Парфуми";>oleDbSelectCommand1->Connection = this->oleDbConnection1;
//
// oleDbInsertCommand1
//>oleDbInsertCommand1->CommandText = L"INSERT INTO `Парфуми` (`Назва`, `Дата`, `Країна`, `Виробник`, `Ціна`, `Натуральни""й_вміст`, `Хімічний_вміст`) VALUES (\?, \?, \?, \?, \?, \?, \?)";>oleDbInsertCommand1->Connection = this->oleDbConnection1;>oleDbInsertCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(7) {(gcnew System::Data::OleDb::OleDbParameter(L"Назва",::Data::OleDb::OleDbType::VarWChar, 0, L"Назва")), (gcnew System::Data::OleDb::OleDbParameter(L"Дата", System::Data::OleDb::OleDbType::VarWChar,
, L"Дата")), (gcnew System::Data::OleDb::OleDbParameter(L"Країна", System::Data::OleDb::OleDbType::VarWChar, 0, L"Країна")),
(gcnew System::Data::OleDb::OleDbParameter(L"Виробник", System::Data::OleDb::OleDbType::VarWChar, 0, L"Виробник")), (gcnew System::Data::OleDb::OleDbParameter(L"Ціна",::Data::OleDb::OleDbType::VarWChar, 0, L"Ціна")), (gcnew System::Data::OleDb::OleDbParameter(L"Натуральний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, L"Натуральний_вміст")), (gcnew System::Data::OleDb::OleDbParameter(L"Хімічний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, L"Хімічний_вміст"))});
//
// oleDbUpdateCommand1
//>oleDbUpdateCommand1->CommandText = resources->GetString(L"oleDbUpdateCommand1.CommandText");>oleDbUpdateCommand1->Connection = this->oleDbConnection1;>oleDbUpdateCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(22) {(gcnew System::Data::OleDb::OleDbParameter(L"Назва",::Data::OleDb::OleDbType::VarWChar, 0, L"Назва")), (gcnew System::Data::OleDb::OleDbParameter(L"Дата", System::Data::OleDb::OleDbType::VarWChar,
, L"Дата")), (gcnew System::Data::OleDb::OleDbParameter(L"Країна", System::Data::OleDb::OleDbType::VarWChar, 0, L"Країна")),
(gcnew System::Data::OleDb::OleDbParameter(L"Виробник", System::Data::OleDb::OleDbType::VarWChar, 0, L"Виробник")), (gcnew System::Data::OleDb::OleDbParameter(L"Ціна",::Data::OleDb::OleDbType::VarWChar, 0, L"Ціна")), (gcnew System::Data::OleDb::OleDbParameter(L"Натуральний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, L"Натуральний_вміст")), (gcnew System::Data::OleDb::OleDbParameter(L"Хімічний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, L"Хімічний_вміст")), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Назва",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Назва", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Назва",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Назва", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Дата",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Дата", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Дата",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Дата", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Країна",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Країна", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Країна",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Країна", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Виробник",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Виробник", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Виробник",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Виробник", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Ціна",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Ціна", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Ціна",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Ціна", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Натуральний_вміст",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Натуральний_вміст", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Натуральний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Натуральний_вміст", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Хімічний_вміст",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Хімічний_вміст", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Хімічний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Хімічний_вміст", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Код",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Код", System::Data::DataRowVersion::Original, nullptr))});
//
// oleDbDeleteCommand1
//>oleDbDeleteCommand1->CommandText = resources->GetString(L"oleDbDeleteCommand1.CommandText");>oleDbDeleteCommand1->Connection = this->oleDbConnection1;>oleDbDeleteCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(15) {(gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Назва",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Назва", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Назва",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Назва", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Дата",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Дата", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Дата",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Дата", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Країна",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Країна", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Країна",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Країна", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Виробник",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Виробник", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Виробник",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Виробник", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Ціна",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Ціна", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Ціна",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Ціна", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Натуральний_вміст",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Натуральний_вміст", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Натуральний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Натуральний_вміст", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Хімічний_вміст",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),"Хімічний_вміст", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Хімічний_вміст",::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Хімічний_вміст", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Код",::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),_cast<System::Byte>(0), L"Код", System::Data::DataRowVersion::Original, nullptr))});
//
// oleDbDataAdapter1
//>oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;>oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;>oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;::array< System::Data::Common::DataColumnMapping^ >^ __mcTemp__1 = gcnew cli::array< System::Data::Common::DataColumnMapping^ >(8) {(gcnew System::Data::Common::DataColumnMapping(L"Назва","Назва")), (gcnew System::Data::Common::DataColumnMapping(L"Дата", L"Дата")), (gcnew System::Data::Common::DataColumnMapping(L"Країна","Країна")), (gcnew System::Data::Common::DataColumnMapping(L"Виробник", L"Виробник")), (gcnew System::Data::Common::DataColumnMapping(L"Ціна","Ціна")), (gcnew System::Data::Common::DataColumnMapping(L"Натуральний_вміст", L"Натуральний_вміст")), (gcnew System::Data::Common::DataColumnMapping(L"Хімічний_вміст","Хімічний_вміст")), (gcnew System::Data::Common::DataColumnMapping(L"Код", L"Код"))};>oleDbDataAdapter1->TableMappings->AddRange(gcnew cli::array< System::Data::Common::DataTableMapping^ >(1) {(gcnew System::Data::Common::DataTableMapping(L"Table","Парфуми", __mcTemp__1))});>oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;