Дипломная (вкр): Програма обліку товарів на складі магазину

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам

//

// 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();

}

};

}

Додаток 2. Лістинг Form2


#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;

Источник: https://www.bibliofond.ru/detail.aspx?id=865944