Материал: Автоматизація обліку абонентів

, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Область", System::Data::DataRowVersion::Original, , nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Область", System::Data::OleDb::OleDbType::VarWChar,

, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Область", ::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Район", System::Data::OleDb::OleDbType::Integer,

, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Район", System::Data::DataRowVersion::Original, , nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Район", System::Data::OleDb::OleDbType::VarWChar,

, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Район", ::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Вулиця", System::Data::OleDb::OleDbType::Integer,

, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Вулиця", System::Data::DataRowVersion::Original, , nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Вулиця", System::Data::OleDb::OleDbType::VarWChar,

, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Вулиця", ::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Будинок", System::Data::OleDb::OleDbType::Integer,

, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Будинок", System::Data::DataRowVersion::Original, , nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Будинок", System::Data::OleDb::OleDbType::VarWChar,

, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Будинок", ::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_Телефон", System::Data::OleDb::OleDbType::Integer,

, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Телефон", System::Data::DataRowVersion::Original, , nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Телефон", System::Data::OleDb::OleDbType::VarWChar,

, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Телефон", ::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_Код", System::Data::OleDb::OleDbType::Integer,

, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"Код", System::Data::DataRowVersion::Original, ))});

//

// oleDbDeleteCommand2

// >oleDbDeleteCommand2->CommandText = resources->GetString(L"oleDbDeleteCommand2.CommandText");>oleDbDeleteCommand2->Connection = this->oleDbConnection1;>oleDbDeleteCommand2->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(17) {(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"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->oleDbDeleteCommand2;>oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand2;>oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand2;::array< System::Data::Common::DataColumnMapping^ >^ __mcTemp__1 = gcnew cli::array< System::Data::Common::DataColumnMapping^ >(9) {(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"Телефон")), (gcnew System::Data::Common::DataColumnMapping(L"Код", "Код"))};>oleDbDataAdapter1->TableMappings->AddRange(gcnew cli::array< System::Data::Common::DataTableMapping^ >(1) {(gcnew System::Data::Common::DataTableMapping(L"Table", "Абоненти", __mcTemp__1))});>oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand2;

//

// Form1

// >AutoScaleDimensions = System::Drawing::SizeF(6, 13);>AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;>ClientSize = System::Drawing::Size(841, 520);>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";>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->dataTable1))->EndInit();

(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataGridView1))->EndInit();

(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->bindingSource1))->EndInit();

(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataSet1))->EndInit();

(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataTable2))->EndInit();>ResumeLayout(false);>PerformLayout();

}

#pragma endregion: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)

{

Form2 ^F2=gcnew Form2();

F2->ShowDialog();

}: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e)

{

int i=dataGridView1->HitTestInfo->RowIndex->CellIndex;->Rows->RemoveAt(i);

}: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e)

{

oleDbDataAdapter1->Fill(dataTable1);

}: System::Void Form1_FormClosing(System::Object^ sender, System::Windows::Forms::FormClosingEventArgs^ e)

{

oleDbDataAdapter1->Update(dataTable1);

}: System::Void button3_Click(System::Object^ sender, System::EventArgs^ e)

{

Abonent Abn;

Abn.search();

};

}

Додаток 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::TextBox^ textBox8;: System::Windows::Forms::Label^ label8;: System::Windows::Forms::Button^ button1;: System::Data::OleDb::OleDbCommand^ oleDbSelectCommand1;: System::Data::OleDb::OleDbConnection^ oleDbConnection1;: System::Data::OleDb::OleDbCommand^ oleDbInsertCommand1;: System::Data::OleDb::OleDbCommand^ oleDbUpdateCommand1;: System::Data::OleDb::OleDbCommand^ oleDbDeleteCommand1;: System::Data::OleDb::OleDbDataAdapter^ oleDbDataAdapter1;: 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;:

/// <summary>

/// Требуется переменная конструктора.

/// </summary>::ComponentModel::Container ^components;

#pragma region Windows Form Designer generated code

/// <summary>

/// Обязательный метод для поддержки конструктора - не изменяйте

/// содержимое данного метода при помощи редактора кода.

/// </summary>InitializeComponent(void)

{

/*

Ініціалізація компонентів форми

*/

}

#pragma endregion: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)

{Abn;PD;.get();Adr;.get();.get();.set();

};

}