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

/// <summary>

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

/// </summary>

#pragma region Windows Form Designer generated code

/// <summary>

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

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

/// </summary>InitializeComponent(void)

{>components = (gcnew System::ComponentModel::Container());::ComponentModel::ComponentResourceManager^ resources = (gcnew System::ComponentModel::ComponentResourceManager(Form1::typeid));>label2 = (gcnew System::Windows::Forms::Label());>listBox1 = (gcnew System::Windows::Forms::ListBox());>oleDbSelectCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>label1 = (gcnew System::Windows::Forms::Label());>oleDbInsertCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>textBox1 = (gcnew System::Windows::Forms::TextBox());>button3 = (gcnew System::Windows::Forms::Button());>dataColumn8 = (gcnew System::Data::DataColumn());>button2 = (gcnew System::Windows::Forms::Button());>oleDbUpdateCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>button1 = (gcnew System::Windows::Forms::Button());>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());>dataGridView1 = (gcnew System::Windows::Forms::DataGridView());>пІБDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>датаНародженняDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>містоDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>областьDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>районDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>вулицяDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>будинокDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>телефонDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());>bindingSource1 = (gcnew System::Windows::Forms::BindingSource(this->components));>dataSet1 = (gcnew System::Data::DataSet());>dataTable2 = (gcnew System::Data::DataTable());>dataColumn9 = (gcnew System::Data::DataColumn());>dataColumn10 = (gcnew System::Data::DataColumn());>dataColumn11 = (gcnew System::Data::DataColumn());>dataColumn12 = (gcnew System::Data::DataColumn());>dataColumn13 = (gcnew System::Data::DataColumn());>dataColumn14 = (gcnew System::Data::DataColumn());>dataColumn15 = (gcnew System::Data::DataColumn());>dataColumn16 = (gcnew System::Data::DataColumn());>oleDbDeleteCommand1 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbSelectCommand2 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbConnection1 = (gcnew System::Data::OleDb::OleDbConnection());>oleDbInsertCommand2 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbUpdateCommand2 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbDeleteCommand2 = (gcnew System::Data::OleDb::OleDbCommand());>oleDbDataAdapter1 = (gcnew System::Data::OleDb::OleDbDataAdapter());

(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataTable1))->BeginInit();

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

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

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

(cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataTable2))->BeginInit();>SuspendLayout();

//

// label2

// >label2->AutoSize = true;>label2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, _cast<System::Byte>(204)));>label2->Location = System::Drawing::Point(320, 530);>label2->Name = L"label2";>label2->Size = System::Drawing::Size(182, 24);>label2->TabIndex = 15;>label2->Text = L"Результати пошуку";

//

// listBox1

// >listBox1->FormattingEnabled = true;>listBox1->Location = System::Drawing::Point(22, 569);>listBox1->Name = L"listBox1";>listBox1->Size = System::Drawing::Size(796, 134);>listBox1->TabIndex = 14;

//

// oleDbSelectCommand1

// >oleDbSelectCommand1->CommandText = L"SELECT ПІБ, [Дата народження], Місто, Телефон, Область, Район, Вулиця, Будинок, К" "од FROM Абоненти";

//

// label1

// >label1->AutoSize = true;>label1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 12, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, _cast<System::Byte>(204)));>label1->Location = System::Drawing::Point(463, 468);>label1->Name = L"label1";>label1->Size = System::Drawing::Size(196, 20);>label1->TabIndex = 13;>label1->Text = L"Введіть критерій пошуку";

// oleDbInsertCommand1

// >oleDbInsertCommand1->CommandText = L"INSERT INTO `Абоненти` (`ПІБ`, `Дата народження`, `Місто`, `Телефон`, `Область`, " "`Район`, `Вулиця`, `Будинок`) VALUES (\?, \?, \?, \?, \?, \?, \?, \?)";>oleDbInsertCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(8) {(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, "Місто")), (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"Вулиця", System::Data::OleDb::OleDbType::VarWChar,

, L"Вулиця")), (gcnew System::Data::OleDb::OleDbParameter(L"Будинок", System::Data::OleDb::OleDbType::VarWChar, 0, L"Будинок"))});

//

// textBox1

// >textBox1->Location = System::Drawing::Point(467, 491);>textBox1->Name = L"textBox1";>textBox1->Size = System::Drawing::Size(244, 20);>textBox1->TabIndex = 12;

//

// button3

// >button3->Location = System::Drawing::Point(738, 478);>button3->Name = L"button3";>button3->Size = System::Drawing::Size(95, 38);>button3->TabIndex = 11;>button3->Text = L"Знайти абонента";>button3->UseVisualStyleBackColor = true;

//

// dataColumn8

// >dataColumn8->ColumnName = L"Телефон";

//

// button2

// >button2->Location = System::Drawing::Point(123, 478);>button2->Name = L"button2";>button2->Size = System::Drawing::Size(95, 38);>button2->TabIndex = 10;>button2->Text = L"Видалити абонента";>button2->UseVisualStyleBackColor = true;

//

// oleDbUpdateCommand1

// >oleDbUpdateCommand1->CommandText = resources->GetString(L"oleDbUpdateCommand1.CommandText");>oleDbUpdateCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(25) {(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, "Місто")), (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"Вулиця", 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"IsNull_ПІБ", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, _cast<System::Byte>(0), static_cast<System::Byte>(0), L"ПІБ", System::Data::DataRowVersion::Original, true, nullptr)),

(gcnew System::Data::OleDb::OleDbParameter(L"Original_ПІБ", System::Data::OleDb::OleDbType::VarWChar, 0, 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"IsNull_Дата_народження", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, _cast<System::Byte>(0), static_cast<System::Byte>(0), L"Дата народження", System::Data::DataRowVersion::Original, true, )), (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"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, ))});

//

// button1

// >button1->Location = System::Drawing::Point(22, 478);>button1->Name = L"button1";>button1->Size = System::Drawing::Size(95, 38);>button1->TabIndex = 9;>button1->Text = L"Додати абонента";>button1->UseVisualStyleBackColor = true;>button1->Click += gcnew System::EventHandler(this, &Form1::button1_Click);

//

// 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->ColumnName = L"Місто";

//

// dataColumn4

// >dataColumn4->ColumnName = L"Обасть";

//

// dataColumn5

// >dataColumn5->ColumnName = L"Район";

//

// dataColumn6

// >dataColumn6->ColumnName = L"Вулиця";

//

// dataColumn7

// >dataColumn7->ColumnName = L"Будинок";

//

// dataGridView1

// >dataGridView1->AutoGenerateColumns = false;>dataGridView1->BackgroundColor = System::Drawing::SystemColors::ButtonFace;>dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;>dataGridView1->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(8) {this->пІБDataGridViewTextBoxColumn, >датаНародженняDataGridViewTextBoxColumn, this->містоDataGridViewTextBoxColumn, this->областьDataGridViewTextBoxColumn, >районDataGridViewTextBoxColumn, this->вулицяDataGridViewTextBoxColumn, this->будинокDataGridViewTextBoxColumn, this->телефонDataGridViewTextBoxColumn});>dataGridView1->DataSource = this->bindingSource1;>dataGridView1->Location = System::Drawing::Point(1, -5);>dataGridView1->Name = L"dataGridView1";>dataGridView1->Size = System::Drawing::Size(845, 462);>dataGridView1->TabIndex = 8;

//

// пІБDataGridViewTextBoxColumn

// >пІБDataGridViewTextBoxColumn->DataPropertyName = L"ПІБ";>пІБDataGridViewTextBoxColumn->HeaderText = L"ПІБ";>пІБDataGridViewTextBoxColumn->Name = L"пІБDataGridViewTextBoxColumn";

//

// датаНародженняDataGridViewTextBoxColumn

// >датаНародженняDataGridViewTextBoxColumn->DataPropertyName = L"Дата народження";>датаНародженняDataGridViewTextBoxColumn->HeaderText = L"Дата народження";>датаНародженняDataGridViewTextBoxColumn->Name = L"датаНародженняDataGridViewTextBoxColumn";

//

// містоDataGridViewTextBoxColumn

// >містоDataGridViewTextBoxColumn->DataPropertyName = L"Місто";>містоDataGridViewTextBoxColumn->HeaderText = L"Місто";>містоDataGridViewTextBoxColumn->Name = L"містоDataGridViewTextBoxColumn";

//

// областьDataGridViewTextBoxColumn

// >областьDataGridViewTextBoxColumn->DataPropertyName = L"Область";>областьDataGridViewTextBoxColumn->HeaderText = L"Область";>областьDataGridViewTextBoxColumn->Name = L"областьDataGridViewTextBoxColumn";

//

// районDataGridViewTextBoxColumn

// >районDataGridViewTextBoxColumn->DataPropertyName = L"Район";>районDataGridViewTextBoxColumn->HeaderText = L"Район";>районDataGridViewTextBoxColumn->Name = L"районDataGridViewTextBoxColumn";

//

// вулицяDataGridViewTextBoxColumn

// >вулицяDataGridViewTextBoxColumn->DataPropertyName = L"Вулиця";>вулицяDataGridViewTextBoxColumn->HeaderText = L"Вулиця";>вулицяDataGridViewTextBoxColumn->Name = L"вулицяDataGridViewTextBoxColumn";

//

// будинокDataGridViewTextBoxColumn

// >будинокDataGridViewTextBoxColumn->DataPropertyName = L"Будинок";>будинокDataGridViewTextBoxColumn->HeaderText = L"Будинок";>будинокDataGridViewTextBoxColumn->Name = L"будинокDataGridViewTextBoxColumn";

//

// телефонDataGridViewTextBoxColumn

// >телефонDataGridViewTextBoxColumn->DataPropertyName = L"Телефон";>телефонDataGridViewTextBoxColumn->HeaderText = L"Телефон";>телефонDataGridViewTextBoxColumn->Name = L"телефонDataGridViewTextBoxColumn";

//

// bindingSource1

// >bindingSource1->DataMember = L"Table1";>bindingSource1->DataSource = this->dataSet1;

//

// dataSet1

// >dataSet1->DataSetName = L"NewDataSet";>dataSet1->Tables->AddRange(gcnew cli::array< System::Data::DataTable^ >(1) {this->dataTable2});

//

// dataTable2

// >dataTable2->Columns->AddRange(gcnew cli::array< System::Data::DataColumn^ >(8) {this->dataColumn9, this->dataColumn10, >dataColumn11, this->dataColumn12, this->dataColumn13, this->dataColumn14, this->dataColumn15, this->dataColumn16});>dataTable2->TableName = L"Table1";

//

// dataColumn9

// >dataColumn9->ColumnName = L"ПІБ";

//

// dataColumn10

// >dataColumn10->ColumnName = L"Дата народження";

//

// dataColumn11

// >dataColumn11->ColumnName = L"Місто";

//

// dataColumn12

// >dataColumn12->ColumnName = L"Область";

//

// dataColumn13

// >dataColumn13->ColumnName = L"Район";

//

// dataColumn14

// >dataColumn14->ColumnName = L"Вулиця";

//

// dataColumn15

// >dataColumn15->ColumnName = L"Будинок";

//

// dataColumn16

// >dataColumn16->ColumnName = L"Телефон";

//

// oleDbDeleteCommand1

// >oleDbDeleteCommand1->CommandText = resources->GetString(L"oleDbDeleteCommand1.CommandText");>oleDbDeleteCommand1->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))});

//

// oleDbSelectCommand2

// >oleDbSelectCommand2->CommandText = L"SELECT ПІБ, [Дата народження], Місто, Область, Район, Вулиця, Будинок, Телефон, К" "од FROM Абоненти";>oleDbSelectCommand2->Connection = this->oleDbConnection1;

//

// oleDbConnection1

// >oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\Users\\Андрій\\Desktop\\Система обл" "іку абонентів\\Абоненти.mdb\"";

//

// oleDbInsertCommand2

// >oleDbInsertCommand2->CommandText = L"INSERT INTO `Абоненти` (`ПІБ`, `Дата народження`, `Місто`, `Область`, `Район`, `В" "улиця`, `Будинок`, `Телефон`) VALUES (\?, \?, \?, \?, \?, \?, \?, \?)";>oleDbInsertCommand2->Connection = this->oleDbConnection1;>oleDbInsertCommand2->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(8) {(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, "Місто")), (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"Будинок", System::Data::OleDb::OleDbType::VarWChar,

, L"Будинок")), (gcnew System::Data::OleDb::OleDbParameter(L"Телефон", System::Data::OleDb::OleDbType::VarWChar, 0, L"Телефон"))});

//

// oleDbUpdateCommand2

// >oleDbUpdateCommand2->CommandText = resources->GetString(L"oleDbUpdateCommand2.CommandText");>oleDbUpdateCommand2->Connection = this->oleDbConnection1;>oleDbUpdateCommand2->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(25) {(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, "Місто")), (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"Будинок", 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"IsNull_ПІБ", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, _cast<System::Byte>(0), static_cast<System::Byte>(0), L"ПІБ", System::Data::DataRowVersion::Original, true, nullptr)),

(gcnew System::Data::OleDb::OleDbParameter(L"Original_ПІБ", System::Data::OleDb::OleDbType::VarWChar, 0, 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"IsNull_Дата_народження", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, _cast<System::Byte>(0), static_cast<System::Byte>(0), L"Дата народження", System::Data::DataRowVersion::Original, true, )), (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,