Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #pragma once
- namespace Project1 {
- using namespace System;
- using namespace System::ComponentModel;
- using namespace System::Collections;
- using namespace System::Windows::Forms;
- using namespace System::Data;
- using namespace System::Drawing;
- /// <summary>
- /// Сводка для MyForm
- /// </summary>
- public ref class MyForm : public System::Windows::Forms::Form
- {
- public:
- MyForm(void)
- {
- InitializeComponent();
- //
- //TODO: добавьте код конструктора
- //
- }
- protected:
- /// <summary>
- /// Освободить все используемые ресурсы.
- /// </summary>
- ~MyForm()
- {
- if (components)
- {
- delete components;
- }
- }
- private: System::Data::OleDb::OleDbConnection^ oleDbConnection1;
- protected:
- private: System::Data::DataSet^ dataSet1;
- private: System::Data::DataTable^ dataTable1;
- private: System::Data::DataColumn^ dataColumn1;
- private: System::Data::DataColumn^ dataColumn2;
- private: System::Data::DataColumn^ dataColumn3;
- private: System::Data::DataColumn^ dataColumn4;
- private: System::Data::DataColumn^ dataColumn5;
- private: System::Data::DataColumn^ dataColumn6;
- private: System::Windows::Forms::DataGridView^ dataGridView1;
- private: System::Windows::Forms::TextBox^ textBox1;
- private: System::Windows::Forms::Button^ button1;
- private: System::Windows::Forms::ComboBox^ comboBox1;
- private: System::Windows::Forms::Label^ label1;
- private: System::Windows::Forms::ComboBox^ comboBox2;
- private: System::Windows::Forms::Label^ label2;
- private: System::Windows::Forms::Button^ button3;
- private: System::Windows::Forms::Button^ button4;
- private: System::Windows::Forms::Label^ label3;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ кодDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ nameDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ specialnostDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ temaDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ timeDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ rezultatDataGridViewTextBoxColumn;
- private: System::Data::OleDb::OleDbCommand^ oleDbSelectCommand1;
- private: System::Data::OleDb::OleDbCommand^ oleDbInsertCommand1;
- private: System::Data::OleDb::OleDbDataAdapter^ oleDbDataAdapter1;
- private: System::Windows::Forms::MenuStrip^ menuStrip1;
- private: System::Windows::Forms::ToolStripMenuItem^ менюToolStripMenuItem;
- private: System::Windows::Forms::ToolStripMenuItem^ выходToolStripMenuItem;
- private: System::Windows::Forms::ComboBox^ comboBox3;
- private: System::Windows::Forms::GroupBox^ groupBox1;
- private: System::Windows::Forms::Label^ label4;
- private: System::Windows::Forms::ToolStripMenuItem^ отменитьToolStripMenuItem;
- private: System::Windows::Forms::ToolStripMenuItem^ поискToolStripMenuItem;
- private: System::Windows::Forms::ToolStripMenuItem^ сохранитьToolStripMenuItem;
- private: System::Windows::Forms::ContextMenuStrip^ contextMenuStrip1;
- private: System::ComponentModel::IContainer^ components;
- protected:
- private:
- /// <summary>
- /// Обязательная переменная конструктора.
- /// </summary>
- #pragma region Windows Form Designer generated code
- /// <summary>
- /// Требуемый метод для поддержки конструктора — не изменяйте
- /// содержимое этого метода с помощью редактора кода.
- /// </summary>
- void InitializeComponent(void)
- {
- this->components = (gcnew System::ComponentModel::Container());
- this->oleDbConnection1 = (gcnew System::Data::OleDb::OleDbConnection());
- this->dataSet1 = (gcnew System::Data::DataSet());
- this->dataTable1 = (gcnew System::Data::DataTable());
- this->dataColumn1 = (gcnew System::Data::DataColumn());
- this->dataColumn2 = (gcnew System::Data::DataColumn());
- this->dataColumn3 = (gcnew System::Data::DataColumn());
- this->dataColumn4 = (gcnew System::Data::DataColumn());
- this->dataColumn5 = (gcnew System::Data::DataColumn());
- this->dataColumn6 = (gcnew System::Data::DataColumn());
- this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());
- this->кодDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->nameDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->specialnostDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->temaDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->timeDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->rezultatDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->textBox1 = (gcnew System::Windows::Forms::TextBox());
- this->button1 = (gcnew System::Windows::Forms::Button());
- this->comboBox1 = (gcnew System::Windows::Forms::ComboBox());
- this->label1 = (gcnew System::Windows::Forms::Label());
- this->comboBox2 = (gcnew System::Windows::Forms::ComboBox());
- this->label2 = (gcnew System::Windows::Forms::Label());
- this->button3 = (gcnew System::Windows::Forms::Button());
- this->button4 = (gcnew System::Windows::Forms::Button());
- this->label3 = (gcnew System::Windows::Forms::Label());
- this->oleDbSelectCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
- this->oleDbInsertCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
- this->oleDbDataAdapter1 = (gcnew System::Data::OleDb::OleDbDataAdapter());
- this->menuStrip1 = (gcnew System::Windows::Forms::MenuStrip());
- this->менюToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
- this->поискToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
- this->сохранитьToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
- this->отменитьToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
- this->выходToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
- this->comboBox3 = (gcnew System::Windows::Forms::ComboBox());
- this->groupBox1 = (gcnew System::Windows::Forms::GroupBox());
- this->label4 = (gcnew System::Windows::Forms::Label());
- this->contextMenuStrip1 = (gcnew System::Windows::Forms::ContextMenuStrip(this->components));
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataSet1))->BeginInit();
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataTable1))->BeginInit();
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataGridView1))->BeginInit();
- this->menuStrip1->SuspendLayout();
- this->groupBox1->SuspendLayout();
- this->SuspendLayout();
- //
- // oleDbConnection1
- //
- this->oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\Пользователи\\User\\Документы\\Visual Stu"
- L"dio 2013\\Projects\\Проект7\\NPK.mdb\"";
- //
- // dataSet1
- //
- this->dataSet1->DataSetName = L"NewDataSet";
- this->dataSet1->Tables->AddRange(gcnew cli::array< System::Data::DataTable^ >(1) { this->dataTable1 });
- //
- // dataTable1
- //
- this->dataTable1->Columns->AddRange(gcnew cli::array< System::Data::DataColumn^ >(6) {
- this->dataColumn1, this->dataColumn2,
- this->dataColumn3, this->dataColumn4, this->dataColumn5, this->dataColumn6
- });
- this->dataTable1->TableName = L"NPK";
- //
- // dataColumn1
- //
- this->dataColumn1->ColumnName = L"Код";
- //
- // dataColumn2
- //
- this->dataColumn2->ColumnName = L"Name";
- //
- // dataColumn3
- //
- this->dataColumn3->ColumnName = L"Specialnost";
- //
- // dataColumn4
- //
- this->dataColumn4->ColumnName = L"Tema";
- //
- // dataColumn5
- //
- this->dataColumn5->ColumnName = L"Time";
- //
- // dataColumn6
- //
- this->dataColumn6->ColumnName = L"Rezultat";
- //
- // dataGridView1
- //
- this->dataGridView1->AutoGenerateColumns = false;
- this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
- this->dataGridView1->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(6) {
- this->кодDataGridViewTextBoxColumn,
- this->nameDataGridViewTextBoxColumn, this->specialnostDataGridViewTextBoxColumn, this->temaDataGridViewTextBoxColumn, this->timeDataGridViewTextBoxColumn,
- this->rezultatDataGridViewTextBoxColumn
- });
- this->dataGridView1->DataMember = L"NPK";
- this->dataGridView1->DataSource = this->dataSet1;
- this->dataGridView1->Location = System::Drawing::Point(6, 27);
- this->dataGridView1->Name = L"dataGridView1";
- this->dataGridView1->Size = System::Drawing::Size(575, 188);
- this->dataGridView1->TabIndex = 0;
- this->dataGridView1->CellContentClick += gcnew System::Windows::Forms::DataGridViewCellEventHandler(this, &MyForm::dataGridView1_CellContentClick);
- this->dataGridView1->UserDeletingRow += gcnew System::Windows::Forms::DataGridViewRowCancelEventHandler(this, &MyForm::dataGridView1_UserDeletingRow);
- //
- // кодDataGridViewTextBoxColumn
- //
- this->кодDataGridViewTextBoxColumn->DataPropertyName = L"Код";
- this->кодDataGridViewTextBoxColumn->HeaderText = L"Код";
- this->кодDataGridViewTextBoxColumn->Name = L"кодDataGridViewTextBoxColumn";
- this->кодDataGridViewTextBoxColumn->Width = 30;
- //
- // nameDataGridViewTextBoxColumn
- //
- this->nameDataGridViewTextBoxColumn->DataPropertyName = L"Name";
- this->nameDataGridViewTextBoxColumn->HeaderText = L"Имя";
- this->nameDataGridViewTextBoxColumn->Name = L"nameDataGridViewTextBoxColumn";
- //
- // specialnostDataGridViewTextBoxColumn
- //
- this->specialnostDataGridViewTextBoxColumn->DataPropertyName = L"Specialnost";
- this->specialnostDataGridViewTextBoxColumn->HeaderText = L"Статус";
- this->specialnostDataGridViewTextBoxColumn->Name = L"specialnostDataGridViewTextBoxColumn";
- //
- // temaDataGridViewTextBoxColumn
- //
- this->temaDataGridViewTextBoxColumn->DataPropertyName = L"Tema";
- this->temaDataGridViewTextBoxColumn->HeaderText = L"Тема";
- this->temaDataGridViewTextBoxColumn->Name = L"temaDataGridViewTextBoxColumn";
- //
- // timeDataGridViewTextBoxColumn
- //
- this->timeDataGridViewTextBoxColumn->DataPropertyName = L"Time";
- this->timeDataGridViewTextBoxColumn->HeaderText = L"Время";
- this->timeDataGridViewTextBoxColumn->Name = L"timeDataGridViewTextBoxColumn";
- //
- // rezultatDataGridViewTextBoxColumn
- //
- this->rezultatDataGridViewTextBoxColumn->DataPropertyName = L"Rezultat";
- this->rezultatDataGridViewTextBoxColumn->HeaderText = L"Результат";
- this->rezultatDataGridViewTextBoxColumn->Name = L"rezultatDataGridViewTextBoxColumn";
- //
- // textBox1
- //
- this->textBox1->Location = System::Drawing::Point(143, 37);
- this->textBox1->Name = L"textBox1";
- this->textBox1->Size = System::Drawing::Size(118, 20);
- this->textBox1->TabIndex = 1;
- this->textBox1->TextChanged += gcnew System::EventHandler(this, &MyForm::textBox1_TextChanged);
- //
- // button1
- //
- this->button1->Location = System::Drawing::Point(291, 37);
- this->button1->Name = L"button1";
- this->button1->Size = System::Drawing::Size(83, 22);
- this->button1->TabIndex = 2;
- this->button1->Text = L"Найти";
- this->button1->UseVisualStyleBackColor = true;
- this->button1->Click += gcnew System::EventHandler(this, &MyForm::button1_Click);
- //
- // comboBox1
- //
- this->comboBox1->FormattingEnabled = true;
- this->comboBox1->Location = System::Drawing::Point(604, 53);
- this->comboBox1->Name = L"comboBox1";
- this->comboBox1->Size = System::Drawing::Size(121, 21);
- this->comboBox1->TabIndex = 4;
- this->comboBox1->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox1_SelectedIndexChanged);
- //
- // label1
- //
- this->label1->AutoSize = true;
- this->label1->Location = System::Drawing::Point(601, 34);
- this->label1->Name = L"label1";
- this->label1->Size = System::Drawing::Size(93, 13);
- this->label1->TabIndex = 5;
- this->label1->Text = L"Выберите статус";
- this->label1->Click += gcnew System::EventHandler(this, &MyForm::label1_Click);
- //
- // comboBox2
- //
- this->comboBox2->FormattingEnabled = true;
- this->comboBox2->Location = System::Drawing::Point(604, 102);
- this->comboBox2->Name = L"comboBox2";
- this->comboBox2->Size = System::Drawing::Size(121, 21);
- this->comboBox2->TabIndex = 6;
- this->comboBox2->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox2_SelectedIndexChanged);
- //
- // label2
- //
- this->label2->AutoSize = true;
- this->label2->Location = System::Drawing::Point(604, 83);
- this->label2->Name = L"label2";
- this->label2->Size = System::Drawing::Size(84, 13);
- this->label2->TabIndex = 7;
- this->label2->Text = L"Выберите тему";
- //
- // button3
- //
- this->button3->Location = System::Drawing::Point(607, 142);
- this->button3->Name = L"button3";
- this->button3->Size = System::Drawing::Size(118, 29);
- this->button3->TabIndex = 8;
- this->button3->Text = L"Посмотреть";
- this->button3->UseVisualStyleBackColor = true;
- this->button3->Click += gcnew System::EventHandler(this, &MyForm::button3_Click_1);
- //
- // button4
- //
- this->button4->Location = System::Drawing::Point(607, 188);
- this->button4->Name = L"button4";
- this->button4->Size = System::Drawing::Size(118, 32);
- this->button4->TabIndex = 9;
- this->button4->Text = L"Сброс";
- this->button4->UseVisualStyleBackColor = true;
- this->button4->Click += gcnew System::EventHandler(this, &MyForm::button4_Click);
- //
- // label3
- //
- this->label3->AutoSize = true;
- this->label3->Location = System::Drawing::Point(157, 19);
- this->label3->Name = L"label3";
- this->label3->Size = System::Drawing::Size(70, 13);
- this->label3->TabIndex = 12;
- this->label3->Text = L"Содержание";
- //
- // oleDbSelectCommand1
- //
- this->oleDbSelectCommand1->CommandText = L"SELECT Код, Name, Specialnost, Tema, [Time], Rezultat\r\nFROM NPK"
- L"\r\nWHERE (Name LIKE \?) AND (Specialnost LIKE \?)\r\nORDER BY Rezultat DESC";
- this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
- this->oleDbSelectCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(2) {
- (gcnew System::Data::OleDb::OleDbParameter(L"Name",
- System::Data::OleDb::OleDbType::WChar, 255, L"Name")), (gcnew System::Data::OleDb::OleDbParameter(L"Specialnost", System::Data::OleDb::OleDbType::WChar,
- 255, L"Specialnost"))
- });
- //
- // oleDbInsertCommand1
- //
- this->oleDbInsertCommand1->CommandText = L"INSERT INTO `NPK` (`Name`, `Specialnost`, `Tema`, `Time`, `Rezultat`) VALUES (\?, "
- L"\?, \?, \?, \?)";
- this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
- this->oleDbInsertCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(5) {
- (gcnew System::Data::OleDb::OleDbParameter(L"Name",
- System::Data::OleDb::OleDbType::VarWChar, 0, L"Name")), (gcnew System::Data::OleDb::OleDbParameter(L"Specialnost", System::Data::OleDb::OleDbType::VarWChar,
- 0, L"Specialnost")), (gcnew System::Data::OleDb::OleDbParameter(L"Tema", System::Data::OleDb::OleDbType::VarWChar, 0, L"Tema")),
- (gcnew System::Data::OleDb::OleDbParameter(L"Time", System::Data::OleDb::OleDbType::VarWChar, 0, L"Time")), (gcnew System::Data::OleDb::OleDbParameter(L"Rezultat",
- System::Data::OleDb::OleDbType::Integer, 0, L"Rezultat"))
- });
- //
- // oleDbDataAdapter1
- //
- this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
- this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
- cli::array< System::Data::Common::DataColumnMapping^ >^ __mcTemp__1 = gcnew cli::array< System::Data::Common::DataColumnMapping^ >(6) {
- (gcnew System::Data::Common::DataColumnMapping(L"Код",
- L"Код")), (gcnew System::Data::Common::DataColumnMapping(L"Name", L"Name")), (gcnew System::Data::Common::DataColumnMapping(L"Specialnost",
- L"Specialnost")), (gcnew System::Data::Common::DataColumnMapping(L"Tema", L"Tema")), (gcnew System::Data::Common::DataColumnMapping(L"Time",
- L"Time")), (gcnew System::Data::Common::DataColumnMapping(L"Rezultat", L"Rezultat"))
- };
- this->oleDbDataAdapter1->TableMappings->AddRange(gcnew cli::array< System::Data::Common::DataTableMapping^ >(1) {
- (gcnew System::Data::Common::DataTableMapping(L"Table",
- L"NPK", __mcTemp__1))
- });
- //
- // menuStrip1
- //
- this->menuStrip1->Items->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^ >(1) { this->менюToolStripMenuItem });
- this->menuStrip1->Location = System::Drawing::Point(0, 0);
- this->menuStrip1->Name = L"menuStrip1";
- this->menuStrip1->Size = System::Drawing::Size(737, 24);
- this->menuStrip1->TabIndex = 13;
- this->menuStrip1->Text = L"menuStrip1";
- //
- // менюToolStripMenuItem
- //
- this->менюToolStripMenuItem->DropDownItems->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^ >(4) {
- this->поискToolStripMenuItem,
- this->сохранитьToolStripMenuItem, this->отменитьToolStripMenuItem, this->выходToolStripMenuItem
- });
- this->менюToolStripMenuItem->Name = L"менюToolStripMenuItem";
- this->менюToolStripMenuItem->Size = System::Drawing::Size(53, 20);
- this->менюToolStripMenuItem->Text = L"Меню";
- //
- // поискToolStripMenuItem
- //
- this->поискToolStripMenuItem->Name = L"поискToolStripMenuItem";
- this->поискToolStripMenuItem->Size = System::Drawing::Size(132, 22);
- this->поискToolStripMenuItem->Text = L"Поиск";
- this->поискToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::поискToolStripMenuItem_Click);
- //
- // сохранитьToolStripMenuItem
- //
- this->сохранитьToolStripMenuItem->Name = L"сохранитьToolStripMenuItem";
- this->сохранитьToolStripMenuItem->Size = System::Drawing::Size(132, 22);
- this->сохранитьToolStripMenuItem->Text = L"Сохранить";
- this->сохранитьToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::сохранитьToolStripMenuItem_Click);
- //
- // отменитьToolStripMenuItem
- //
- this->отменитьToolStripMenuItem->Name = L"отменитьToolStripMenuItem";
- this->отменитьToolStripMenuItem->Size = System::Drawing::Size(132, 22);
- this->отменитьToolStripMenuItem->Text = L"Отменить";
- this->отменитьToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::отменитьToolStripMenuItem_Click);
- //
- // выходToolStripMenuItem
- //
- this->выходToolStripMenuItem->Name = L"выходToolStripMenuItem";
- this->выходToolStripMenuItem->Size = System::Drawing::Size(132, 22);
- this->выходToolStripMenuItem->Text = L"Выход";
- this->выходToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::выходToolStripMenuItem_Click);
- //
- // comboBox3
- //
- this->comboBox3->FormattingEnabled = true;
- this->comboBox3->Location = System::Drawing::Point(6, 36);
- this->comboBox3->Name = L"comboBox3";
- this->comboBox3->Size = System::Drawing::Size(121, 21);
- this->comboBox3->TabIndex = 15;
- this->comboBox3->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox3_SelectedIndexChanged);
- //
- // groupBox1
- //
- this->groupBox1->Controls->Add(this->label4);
- this->groupBox1->Controls->Add(this->comboBox3);
- this->groupBox1->Controls->Add(this->label3);
- this->groupBox1->Controls->Add(this->button1);
- this->groupBox1->Controls->Add(this->textBox1);
- this->groupBox1->Location = System::Drawing::Point(13, 230);
- this->groupBox1->Name = L"groupBox1";
- this->groupBox1->Size = System::Drawing::Size(393, 76);
- this->groupBox1->TabIndex = 16;
- this->groupBox1->TabStop = false;
- this->groupBox1->Text = L"Поиск";
- this->groupBox1->Enter += gcnew System::EventHandler(this, &MyForm::groupBox1_Enter);
- //
- // label4
- //
- this->label4->AutoSize = true;
- this->label4->Location = System::Drawing::Point(31, 22);
- this->label4->Name = L"label4";
- this->label4->Size = System::Drawing::Size(49, 13);
- this->label4->TabIndex = 16;
- this->label4->Text = L"Столбец";
- //
- // MyForm
- //
- this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);
- this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
- this->ClientSize = System::Drawing::Size(737, 323);
- this->Controls->Add(this->groupBox1);
- this->Controls->Add(this->button4);
- this->Controls->Add(this->button3);
- this->Controls->Add(this->label2);
- this->Controls->Add(this->comboBox2);
- this->Controls->Add(this->label1);
- this->Controls->Add(this->comboBox1);
- this->Controls->Add(this->dataGridView1);
- this->Controls->Add(this->menuStrip1);
- this->MainMenuStrip = this->menuStrip1;
- this->Name = L"MyForm";
- this->Text = L"MyForm";
- this->Load += gcnew System::EventHandler(this, &MyForm::MyForm_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->dataGridView1))->EndInit();
- this->menuStrip1->ResumeLayout(false);
- this->menuStrip1->PerformLayout();
- this->groupBox1->ResumeLayout(false);
- this->groupBox1->PerformLayout();
- this->ResumeLayout(false);
- this->PerformLayout();
- }
- #pragma endregion
- private: System::Void MyForm_Load(System::Object^ sender,
- System::EventArgs^ e) {
- oleDbDataAdapter1->SelectCommand->Parameters[0]->Value = "%%";
- oleDbDataAdapter1->SelectCommand->Parameters[1]->Value = "%%";
- oleDbDataAdapter1->Fill(dataTable1);
- this->comboBox1->Items->AddRange(gcnew cli::array< System::Object^ >(4) { L"Студент", L"Аспирант", L"Преподователь", L"Гость" });
- this->comboBox2->Items->AddRange(gcnew cli::array< System::Object^ >(6) { L"С++", L"Pascal", L"Java", L"Basic", L"C#", L"-" });
- this->comboBox3->Items->AddRange(gcnew cli::array< System::Object^ >(2) { L"Имя", L"Статус" });
- comboBox3->SelectedIndex = 0;
- }
- void rea()
- {
- for (int x = 0; x < 100; x++) {
- if (dataGridView1->Rows[x]->Cells[2]->FormattedValue->ToString() == "") break;
- dataGridView1->Rows[x]->Visible = true;
- }
- }
- private: System::Void button3_Click_1(System::Object^ sender, System::EventArgs^ e) {
- rea();
- for (int x = 0; x < 100; x++) {
- if (dataGridView1->Rows[x]->Cells[0]->FormattedValue->ToString() == "") break;
- dataGridView1->CurrentCell = dataGridView1->Rows[x + 1]->Cells[0];
- if (comboBox1->Text != this->dataGridView1->Rows[x]->Cells[2]->FormattedValue->ToString() && comboBox1->Text != "") dataGridView1->Rows[x]->Visible = false;
- if (comboBox2->Text != this->dataGridView1->Rows[x]->Cells[3]->FormattedValue->ToString() && comboBox2->Text != "") dataGridView1->Rows[x]->Visible = false;
- }
- }
- private: System::Void comboBox2_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) {
- }
- private: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e) {
- comboBox1->Text = "";
- comboBox2->Text = "";
- rea();
- }
- private: System::Void dataGridView1_CellContentClick(System::Object^ sender,
- System::Windows::Forms::DataGridViewCellEventArgs^ e) {
- }
- private: System::Void поискToolStripMenuItem_Click(System::Object^ sender, System::EventArgs^ e) {
- groupBox1->Visible = true;
- }
- private: System::Void comboBox3_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) {
- }
- void f()
- {
- switch (comboBox3->SelectedIndex) {
- case 0:
- dataSet1->Clear();
- oleDbDataAdapter1->SelectCommand->Parameters["name"]->Value =
- "%" + textBox1->Text + "%";
- oleDbDataAdapter1->Fill(dataTable1); break;
- case 1:
- dataSet1->Clear();
- oleDbDataAdapter1->SelectCommand->Parameters["Specialnost"]->Value =
- "%" + textBox1->Text + "%";
- oleDbDataAdapter1->Fill(dataTable1); break;
- }
- }
- private: System::Void button1_Click(System::Object^ sender,
- System::EventArgs^ e) {
- f();
- }
- private: System::Void button2_Click(System::Object^ sender,
- System::EventArgs^ e) {
- }
- private: System::Void button3_Click(System::Object^ sender, System::EventArgs^ e) {
- }
- private: System::Void comboBox1_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) {
- }
- private: System::Void label1_Click(System::Object^ sender, System::EventArgs^ e) {
- }
- private: System::Void button6_Click(System::Object^ sender, System::EventArgs^ e) {
- this->dataSet1->RejectChanges();
- }
- private: System::Void сохранитьToolStripMenuItem_Click(System::Object^ sender, System::EventArgs^ e) {
- this->oleDbDataAdapter1->Update(dataSet1->Tables["NPK"]);
- }
- private: System::Void отменитьToolStripMenuItem_Click(System::Object^ sender, System::EventArgs^ e) {
- this->dataSet1->RejectChanges();
- }
- private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e) {
- this->oleDbDataAdapter1->Update(dataSet1->Tables["NPK"]);
- }
- private: System::Void выходToolStripMenuItem_Click(System::Object^ sender, System::EventArgs^ e) {
- Application::Exit();
- }
- private: System::Void textBox1_TextChanged(System::Object^ sender, System::EventArgs^ e) {
- }
- private: System::Void dataGridView1_UserDeletingRow(System::Object^ sender, System::Windows::Forms::DataGridViewRowCancelEventArgs^ e) {
- System::Windows::Forms::DialogResult
- dr = MessageBox::Show("Удалить запись?", "Удаление записи", MessageBoxButtons::OKCancel, MessageBoxIcon::Warning, MessageBoxDefaultButton::Button2);
- if (dr == System::Windows::Forms::DialogResult::OK) { e->Cancel = true; }
- }
- private: System::Void groupBox1_Enter(System::Object^ sender, System::EventArgs^ e) {
- }
- // завершение работы программы
- private: System::Void Form1_FormClosing(
- System::Object^ sender,
- System::Windows::Forms::FormClosingEventArgs^ e)
- {
- // обновить данные
- oleDbDataAdapter1->Update(dataSet1->Tables["NPK"]);
- }
- };
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement