API tools faq
paste
Advertisement
gvldiiii

Ване

gvldiiii
Jun 24th, 2018
101
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 27.44 KB | None | 0 0
raw download clone embed print report
  1. #pragma once
  2.  
  3. namespace Project1 {
  4.  
  5.     using namespace System;
  6.     using namespace System::ComponentModel;
  7.     using namespace System::Collections;
  8.     using namespace System::Windows::Forms;
  9.     using namespace System::Data;
  10.     using namespace System::Drawing;
  11.  
  12.     /// <summary>
  13.     /// Сводка для MyForm
  14.     /// </summary>
  15.     public ref class MyForm : public System::Windows::Forms::Form
  16.     {
  17.     public:
  18.         MyForm(void)
  19.         {
  20.             InitializeComponent();
  21.             //
  22.             //TODO: добавьте код конструктора
  23.             //
  24.         }
  25.  
  26.     protected:
  27.         /// <summary>
  28.         /// Освободить все используемые ресурсы.
  29.         /// </summary>
  30.         ~MyForm()
  31.         {
  32.             if (components)
  33.             {
  34.                 delete components;
  35.             }
  36.         }
  37.     private: System::Data::OleDb::OleDbConnection^  oleDbConnection1;
  38.     protected:
  39.  
  40.  
  41.  
  42.  
  43.  
  44.     private: System::Data::DataSet^  dataSet1;
  45.     private: System::Data::DataTable^  dataTable1;
  46.     private: System::Data::DataColumn^  dataColumn1;
  47.     private: System::Data::DataColumn^  dataColumn2;
  48.     private: System::Data::DataColumn^  dataColumn3;
  49.     private: System::Data::DataColumn^  dataColumn4;
  50.     private: System::Data::DataColumn^  dataColumn5;
  51.     private: System::Data::DataColumn^  dataColumn6;
  52.     private: System::Windows::Forms::DataGridView^  dataGridView1;
  53.  
  54.  
  55.  
  56.  
  57.  
  58.  
  59.     private: System::Windows::Forms::TextBox^  textBox1;
  60.     private: System::Windows::Forms::Button^  button1;
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67.     private: System::Windows::Forms::Button^  button4;
  68.  
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76.     private: System::Windows::Forms::Label^  label3;
  77.     private: System::Windows::Forms::DataGridViewTextBoxColumn^  кодDataGridViewTextBoxColumn;
  78.     private: System::Windows::Forms::DataGridViewTextBoxColumn^  nameDataGridViewTextBoxColumn;
  79.     private: System::Windows::Forms::DataGridViewTextBoxColumn^  specialnostDataGridViewTextBoxColumn;
  80.     private: System::Windows::Forms::DataGridViewTextBoxColumn^  temaDataGridViewTextBoxColumn;
  81.     private: System::Windows::Forms::DataGridViewTextBoxColumn^  timeDataGridViewTextBoxColumn;
  82.     private: System::Windows::Forms::DataGridViewTextBoxColumn^  rezultatDataGridViewTextBoxColumn;
  83.  
  84.     private: System::Data::OleDb::OleDbCommand^  oleDbSelectCommand1;
  85.     private: System::Data::OleDb::OleDbCommand^  oleDbInsertCommand1;
  86.     private: System::Data::OleDb::OleDbDataAdapter^  oleDbDataAdapter1;
  87.     private: System::Windows::Forms::MenuStrip^  menuStrip1;
  88.     private: System::Windows::Forms::ToolStripMenuItem^  менюToolStripMenuItem;
  89.  
  90.  
  91.  
  92.  
  93.  
  94.     private: System::Windows::Forms::ToolStripMenuItem^  выходToolStripMenuItem;
  95.  
  96.     private: System::Windows::Forms::ComboBox^  comboBox3;
  97.     private: System::Windows::Forms::GroupBox^  groupBox1;
  98.     private: System::Windows::Forms::Label^  label4;
  99.     private: System::Windows::Forms::ToolStripMenuItem^  отменитьToolStripMenuItem;
  100.     private: System::Windows::Forms::ToolStripMenuItem^  поискToolStripMenuItem;
  101.     private: System::Windows::Forms::ToolStripMenuItem^  сохранитьToolStripMenuItem;
  102.     private: System::Windows::Forms::ContextMenuStrip^  contextMenuStrip1;
  103.  
  104.  
  105.  
  106.  
  107.  
  108.  
  109.  
  110.  
  111.  
  112.  
  113.  
  114.  
  115.  
  116.  
  117.  
  118.  
  119.     private: System::ComponentModel::IContainer^  components;
  120.  
  121.  
  122.  
  123.     protected:
  124.  
  125.     private:
  126.         /// <summary>
  127.         /// Обязательная переменная конструктора.
  128.         /// </summary>
  129.  
  130.  
  131. #pragma region Windows Form Designer generated code
  132.         /// <summary>
  133.         /// Требуемый метод для поддержки конструктора — не изменяйте
  134.         /// содержимое этого метода с помощью редактора кода.
  135.         /// </summary>
  136.         void InitializeComponent(void)
  137.         {
  138.             this->components = (gcnew System::ComponentModel::Container());
  139.             System::ComponentModel::ComponentResourceManager^  resources = (gcnew System::ComponentModel::ComponentResourceManager(MyForm::typeid));
  140.             this->oleDbConnection1 = (gcnew System::Data::OleDb::OleDbConnection());
  141.             this->dataSet1 = (gcnew System::Data::DataSet());
  142.             this->dataTable1 = (gcnew System::Data::DataTable());
  143.             this->dataColumn1 = (gcnew System::Data::DataColumn());
  144.             this->dataColumn2 = (gcnew System::Data::DataColumn());
  145.             this->dataColumn3 = (gcnew System::Data::DataColumn());
  146.             this->dataColumn4 = (gcnew System::Data::DataColumn());
  147.             this->dataColumn5 = (gcnew System::Data::DataColumn());
  148.             this->dataColumn6 = (gcnew System::Data::DataColumn());
  149.             this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());
  150.             this->кодDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
  151.             this->nameDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
  152.             this->specialnostDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
  153.             this->temaDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
  154.             this->timeDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
  155.             this->rezultatDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
  156.             this->textBox1 = (gcnew System::Windows::Forms::TextBox());
  157.             this->button1 = (gcnew System::Windows::Forms::Button());
  158.             this->button4 = (gcnew System::Windows::Forms::Button());
  159.             this->label3 = (gcnew System::Windows::Forms::Label());
  160.             this->oleDbSelectCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
  161.             this->oleDbInsertCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
  162.             this->oleDbDataAdapter1 = (gcnew System::Data::OleDb::OleDbDataAdapter());
  163.             this->menuStrip1 = (gcnew System::Windows::Forms::MenuStrip());
  164.             this->менюToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
  165.             this->поискToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
  166.             this->сохранитьToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
  167.             this->отменитьToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
  168.             this->выходToolStripMenuItem = (gcnew System::Windows::Forms::ToolStripMenuItem());
  169.             this->comboBox3 = (gcnew System::Windows::Forms::ComboBox());
  170.             this->groupBox1 = (gcnew System::Windows::Forms::GroupBox());
  171.             this->label4 = (gcnew System::Windows::Forms::Label());
  172.             this->contextMenuStrip1 = (gcnew System::Windows::Forms::ContextMenuStrip(this->components));
  173.             (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataSet1))->BeginInit();
  174.             (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataTable1))->BeginInit();
  175.             (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataGridView1))->BeginInit();
  176.             this->menuStrip1->SuspendLayout();
  177.             this->groupBox1->SuspendLayout();
  178.             this->SuspendLayout();
  179.             //
  180.             // oleDbConnection1
  181.             //
  182.             this->oleDbConnection1->ConnectionString = L"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"F:\\2ctvtcnh и и ит\\КУРСАСЧ\\КУРСАСЧ\\"
  183.                 L"Project1\\NPK.mdb\"";
  184.             this->oleDbConnection1->InfoMessage += gcnew System::Data::OleDb::OleDbInfoMessageEventHandler(this, &MyForm::oleDbConnection1_InfoMessage);
  185.             //
  186.             // dataSet1
  187.             //
  188.             this->dataSet1->DataSetName = L"NewDataSet";
  189.             this->dataSet1->Tables->AddRange(gcnew cli::array< System::Data::DataTable^  >(1) { this->dataTable1 });
  190.             //
  191.             // dataTable1
  192.             //
  193.             this->dataTable1->Columns->AddRange(gcnew cli::array< System::Data::DataColumn^  >(6) {
  194.                 this->dataColumn1, this->dataColumn2,
  195.                     this->dataColumn3, this->dataColumn4, this->dataColumn5, this->dataColumn6
  196.             });
  197.             cli::array< System::String^ >^ __mcTemp__1 = gcnew cli::array< System::String^  >(6) { L"Код", L"Name", L"Specialnost", L"Tema", L"Time", L"Rezultat" };
  198.             this->dataTable1->Constraints->AddRange(gcnew cli::array< System::Data::Constraint^  >(1) {
  199.                 (gcnew System::Data::UniqueConstraint(L"Constraint1",
  200.                     __mcTemp__1, true))
  201.             });
  202.             this->dataTable1->PrimaryKey = gcnew cli::array< System::Data::DataColumn^  >(6) {
  203.                 this->dataColumn1, this->dataColumn2, this->dataColumn3,
  204.                     this->dataColumn4, this->dataColumn5, this->dataColumn6
  205.             };
  206.             this->dataTable1->TableName = L"NPK";
  207.             //
  208.             // dataColumn1
  209.             //
  210.             this->dataColumn1->AllowDBNull = false;
  211.             this->dataColumn1->ColumnName = L"Код";
  212.             //
  213.             // dataColumn2
  214.             //
  215.             this->dataColumn2->AllowDBNull = false;
  216.             this->dataColumn2->ColumnName = L"Name";
  217.             //
  218.             // dataColumn3
  219.             //
  220.             this->dataColumn3->AllowDBNull = false;
  221.             this->dataColumn3->ColumnName = L"Specialnost";
  222.             //
  223.             // dataColumn4
  224.             //
  225.             this->dataColumn4->AllowDBNull = false;
  226.             this->dataColumn4->ColumnName = L"Tema";
  227.             //
  228.             // dataColumn5
  229.             //
  230.             this->dataColumn5->AllowDBNull = false;
  231.             this->dataColumn5->ColumnName = L"Time";
  232.             //
  233.             // dataColumn6
  234.             //
  235.             this->dataColumn6->AllowDBNull = false;
  236.             this->dataColumn6->ColumnName = L"Rezultat";
  237.             //
  238.             // dataGridView1
  239.             //
  240.             this->dataGridView1->AutoGenerateColumns = false;
  241.             this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
  242.             this->dataGridView1->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^  >(6) {
  243.                 this->кодDataGridViewTextBoxColumn,
  244.                     this->nameDataGridViewTextBoxColumn, this->specialnostDataGridViewTextBoxColumn, this->temaDataGridViewTextBoxColumn, this->timeDataGridViewTextBoxColumn,
  245.                     this->rezultatDataGridViewTextBoxColumn
  246.             });
  247.             this->dataGridView1->DataMember = L"NPK";
  248.             this->dataGridView1->DataSource = this->dataSet1;
  249.             this->dataGridView1->Location = System::Drawing::Point(6, 27);
  250.             this->dataGridView1->Name = L"dataGridView1";
  251.             this->dataGridView1->Size = System::Drawing::Size(575, 188);
  252.             this->dataGridView1->TabIndex = 0;
  253.             this->dataGridView1->CellContentClick += gcnew System::Windows::Forms::DataGridViewCellEventHandler(this, &MyForm::dataGridView1_CellContentClick);
  254.             this->dataGridView1->UserDeletingRow += gcnew System::Windows::Forms::DataGridViewRowCancelEventHandler(this, &MyForm::dataGridView1_UserDeletingRow);
  255.             //
  256.             // кодDataGridViewTextBoxColumn
  257.             //
  258.             this->кодDataGridViewTextBoxColumn->DataPropertyName = L"Код";
  259.             this->кодDataGridViewTextBoxColumn->HeaderText = L"Код";
  260.             this->кодDataGridViewTextBoxColumn->Name = L"кодDataGridViewTextBoxColumn";
  261.             this->кодDataGridViewTextBoxColumn->Width = 30;
  262.             //
  263.             // nameDataGridViewTextBoxColumn
  264.             //
  265.             this->nameDataGridViewTextBoxColumn->DataPropertyName = L"Name";
  266.             this->nameDataGridViewTextBoxColumn->HeaderText = L"Имя";
  267.             this->nameDataGridViewTextBoxColumn->Name = L"nameDataGridViewTextBoxColumn";
  268.             //
  269.             // specialnostDataGridViewTextBoxColumn
  270.             //
  271.             this->specialnostDataGridViewTextBoxColumn->DataPropertyName = L"Specialnost";
  272.             this->specialnostDataGridViewTextBoxColumn->HeaderText = L"Статус";
  273.             this->specialnostDataGridViewTextBoxColumn->Name = L"specialnostDataGridViewTextBoxColumn";
  274.             //
  275.             // temaDataGridViewTextBoxColumn
  276.             //
  277.             this->temaDataGridViewTextBoxColumn->DataPropertyName = L"Tema";
  278.             this->temaDataGridViewTextBoxColumn->HeaderText = L"Тема";
  279.             this->temaDataGridViewTextBoxColumn->Name = L"temaDataGridViewTextBoxColumn";
  280.             //
  281.             // timeDataGridViewTextBoxColumn
  282.             //
  283.             this->timeDataGridViewTextBoxColumn->DataPropertyName = L"Time";
  284.             this->timeDataGridViewTextBoxColumn->HeaderText = L"Время";
  285.             this->timeDataGridViewTextBoxColumn->Name = L"timeDataGridViewTextBoxColumn";
  286.             //
  287.             // rezultatDataGridViewTextBoxColumn
  288.             //
  289.             this->rezultatDataGridViewTextBoxColumn->DataPropertyName = L"Rezultat";
  290.             this->rezultatDataGridViewTextBoxColumn->HeaderText = L"Результат";
  291.             this->rezultatDataGridViewTextBoxColumn->Name = L"rezultatDataGridViewTextBoxColumn";
  292.             //
  293.             // textBox1
  294.             //
  295.             this->textBox1->Location = System::Drawing::Point(143, 37);
  296.             this->textBox1->Name = L"textBox1";
  297.             this->textBox1->Size = System::Drawing::Size(118, 20);
  298.             this->textBox1->TabIndex = 1;
  299.             this->textBox1->TextChanged += gcnew System::EventHandler(this, &MyForm::textBox1_TextChanged);
  300.             //
  301.             // button1
  302.             //
  303.             this->button1->Location = System::Drawing::Point(291, 37);
  304.             this->button1->Name = L"button1";
  305.             this->button1->Size = System::Drawing::Size(83, 22);
  306.             this->button1->TabIndex = 2;
  307.             this->button1->Text = L"Найти";
  308.             this->button1->UseVisualStyleBackColor = true;
  309.             this->button1->Click += gcnew System::EventHandler(this, &MyForm::button1_Click);
  310.             //
  311.             // button4
  312.             //
  313.             this->button4->Location = System::Drawing::Point(412, 267);
  314.             this->button4->Name = L"button4";
  315.             this->button4->Size = System::Drawing::Size(91, 22);
  316.             this->button4->TabIndex = 9;
  317.             this->button4->Text = L"Сброс";
  318.             this->button4->UseVisualStyleBackColor = true;
  319.             this->button4->Click += gcnew System::EventHandler(this, &MyForm::button4_Click);
  320.             //
  321.             // label3
  322.             //
  323.             this->label3->AutoSize = true;
  324.             this->label3->Location = System::Drawing::Point(157, 19);
  325.             this->label3->Name = L"label3";
  326.             this->label3->Size = System::Drawing::Size(70, 13);
  327.             this->label3->TabIndex = 12;
  328.             this->label3->Text = L"Содержание";
  329.             //
  330.             // oleDbSelectCommand1
  331.             //
  332.             this->oleDbSelectCommand1->CommandText = resources->GetString(L"oleDbSelectCommand1.CommandText");
  333.             this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
  334.             this->oleDbSelectCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^  >(5) {
  335.                 (gcnew System::Data::OleDb::OleDbParameter(L"Name",
  336.                     System::Data::OleDb::OleDbType::WChar, 255, L"Expr2")), (gcnew System::Data::OleDb::OleDbParameter(L"Specialnost", System::Data::OleDb::OleDbType::WChar,
  337.                     255, L"Expr3")), (gcnew System::Data::OleDb::OleDbParameter(L"Tema", System::Data::OleDb::OleDbType::WChar,
  338.                     255, L"Expr4")), (gcnew System::Data::OleDb::OleDbParameter(L"Time", System::Data::OleDb::OleDbType::WChar,
  339.                     255, L"Expr5")), (gcnew System::Data::OleDb::OleDbParameter(L"Rezultat", System::Data::OleDb::OleDbType::WChar,
  340.                     255, L"Expr6"))
  341.             });
  342.             //
  343.             // oleDbInsertCommand1
  344.             //
  345.             this->oleDbInsertCommand1->CommandText = L"INSERT INTO `NPK` (`Name`, `Specialnost`, `Tema`, `Time`, `Rezultat`, `Name`, `Sp"
  346.                 L"ecialnost`, `Tema`, `Time`, `Rezultat`) VALUES (\?, \?, \?, \?, \?, \?, \?, \?, \?, \?)";
  347.             this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
  348.             this->oleDbInsertCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^  >(10) {
  349.                 (gcnew System::Data::OleDb::OleDbParameter(L"Expr2",
  350.                     System::Data::OleDb::OleDbType::VarWChar, 0, L"Expr2")), (gcnew System::Data::OleDb::OleDbParameter(L"Expr3", System::Data::OleDb::OleDbType::VarWChar,
  351.                     0, L"Expr3")), (gcnew System::Data::OleDb::OleDbParameter(L"Expr4", System::Data::OleDb::OleDbType::VarWChar, 0, L"Expr4")),
  352.                     (gcnew System::Data::OleDb::OleDbParameter(L"Expr5", System::Data::OleDb::OleDbType::VarWChar, 0, L"Expr5")), (gcnew System::Data::OleDb::OleDbParameter(L"Expr6",
  353.                     System::Data::OleDb::OleDbType::Integer, 0, L"Expr6")), (gcnew System::Data::OleDb::OleDbParameter(L"Name", System::Data::OleDb::OleDbType::VarWChar,
  354.                     0, L"Name")), (gcnew System::Data::OleDb::OleDbParameter(L"Specialnost", System::Data::OleDb::OleDbType::VarWChar, 0, L"Specialnost")),
  355.                     (gcnew System::Data::OleDb::OleDbParameter(L"Tema", System::Data::OleDb::OleDbType::VarWChar, 0, L"Tema")), (gcnew System::Data::OleDb::OleDbParameter(L"Time",
  356.                     System::Data::OleDb::OleDbType::VarWChar, 0, L"Time")), (gcnew System::Data::OleDb::OleDbParameter(L"Rezultat", System::Data::OleDb::OleDbType::Integer,
  357.                     0, L"Rezultat"))
  358.             });
  359.             //
  360.             // oleDbDataAdapter1
  361.             //
  362.             this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
  363.             this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
  364.             cli::array< System::Data::Common::DataColumnMapping^ >^ __mcTemp__2 = gcnew cli::array< System::Data::Common::DataColumnMapping^  >(12) {
  365.                 (gcnew System::Data::Common::DataColumnMapping(L"Expr1",
  366.                     L"Expr1")), (gcnew System::Data::Common::DataColumnMapping(L"Expr2", L"Expr2")), (gcnew System::Data::Common::DataColumnMapping(L"Expr3",
  367.                     L"Expr3")), (gcnew System::Data::Common::DataColumnMapping(L"Expr4", L"Expr4")), (gcnew System::Data::Common::DataColumnMapping(L"Expr5",
  368.                     L"Expr5")), (gcnew System::Data::Common::DataColumnMapping(L"Expr6", L"Expr6")), (gcnew System::Data::Common::DataColumnMapping(L"Код",
  369.                     L"Код")), (gcnew System::Data::Common::DataColumnMapping(L"Name", L"Name")), (gcnew System::Data::Common::DataColumnMapping(L"Specialnost",
  370.                     L"Specialnost")), (gcnew System::Data::Common::DataColumnMapping(L"Tema", L"Tema")), (gcnew System::Data::Common::DataColumnMapping(L"Time",
  371.                     L"Time")), (gcnew System::Data::Common::DataColumnMapping(L"Rezultat", L"Rezultat"))
  372.             };
  373.             this->oleDbDataAdapter1->TableMappings->AddRange(gcnew cli::array< System::Data::Common::DataTableMapping^  >(1) {
  374.                 (gcnew System::Data::Common::DataTableMapping(L"Table",
  375.                     L"NPK", __mcTemp__2))
  376.             });
  377.             this->oleDbDataAdapter1->RowUpdated += gcnew System::Data::OleDb::OleDbRowUpdatedEventHandler(this, &MyForm::oleDbDataAdapter1_RowUpdated);
  378.             //
  379.             // menuStrip1
  380.             //
  381.             this->menuStrip1->Items->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^  >(1) { this->менюToolStripMenuItem });
  382.             this->menuStrip1->Location = System::Drawing::Point(0, 0);
  383.             this->menuStrip1->Name = L"menuStrip1";
  384.             this->menuStrip1->Size = System::Drawing::Size(586, 24);
  385.             this->menuStrip1->TabIndex = 13;
  386.             this->menuStrip1->Text = L"menuStrip1";
  387.             //
  388.             // менюToolStripMenuItem
  389.             //
  390.             this->менюToolStripMenuItem->DropDownItems->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^  >(4) {
  391.                 this->поискToolStripMenuItem,
  392.                     this->сохранитьToolStripMenuItem, this->отменитьToolStripMenuItem, this->выходToolStripMenuItem
  393.             });
  394.             this->менюToolStripMenuItem->Name = L"менюToolStripMenuItem";
  395.             this->менюToolStripMenuItem->Size = System::Drawing::Size(53, 20);
  396.             this->менюToolStripMenuItem->Text = L"Меню";
  397.             //
  398.             // поискToolStripMenuItem
  399.             //
  400.             this->поискToolStripMenuItem->Name = L"поискToolStripMenuItem";
  401.             this->поискToolStripMenuItem->Size = System::Drawing::Size(132, 22);
  402.             this->поискToolStripMenuItem->Text = L"Поиск";
  403.             this->поискToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::поискToolStripMenuItem_Click);
  404.             //
  405.             // сохранитьToolStripMenuItem
  406.             //
  407.             this->сохранитьToolStripMenuItem->Name = L"сохранитьToolStripMenuItem";
  408.             this->сохранитьToolStripMenuItem->Size = System::Drawing::Size(132, 22);
  409.             this->сохранитьToolStripMenuItem->Text = L"Сохранить";
  410.             this->сохранитьToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::сохранитьToolStripMenuItem_Click);
  411.             //
  412.             // отменитьToolStripMenuItem
  413.             //
  414.             this->отменитьToolStripMenuItem->Name = L"отменитьToolStripMenuItem";
  415.             this->отменитьToolStripMenuItem->Size = System::Drawing::Size(132, 22);
  416.             this->отменитьToolStripMenuItem->Text = L"Отменить";
  417.             this->отменитьToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::отменитьToolStripMenuItem_Click);
  418.             //
  419.             // выходToolStripMenuItem
  420.             //
  421.             this->выходToolStripMenuItem->Name = L"выходToolStripMenuItem";
  422.             this->выходToolStripMenuItem->Size = System::Drawing::Size(132, 22);
  423.             this->выходToolStripMenuItem->Text = L"Выход";
  424.             this->выходToolStripMenuItem->Click += gcnew System::EventHandler(this, &MyForm::выходToolStripMenuItem_Click);
  425.             //
  426.             // comboBox3
  427.             //
  428.             this->comboBox3->FormattingEnabled = true;
  429.             this->comboBox3->Items->AddRange(gcnew cli::array< System::Object^  >(3) { L"Тема", L"Время", L"Результат" });
  430.             this->comboBox3->Location = System::Drawing::Point(6, 36);
  431.             this->comboBox3->Name = L"comboBox3";
  432.             this->comboBox3->Size = System::Drawing::Size(121, 21);
  433.             this->comboBox3->TabIndex = 15;
  434.             this->comboBox3->SelectedIndexChanged += gcnew System::EventHandler(this, &MyForm::comboBox3_SelectedIndexChanged);
  435.             //
  436.             // groupBox1
  437.             //
  438.             this->groupBox1->Controls->Add(this->label4);
  439.             this->groupBox1->Controls->Add(this->comboBox3);
  440.             this->groupBox1->Controls->Add(this->label3);
  441.             this->groupBox1->Controls->Add(this->button1);
  442.             this->groupBox1->Controls->Add(this->textBox1);
  443.             this->groupBox1->Location = System::Drawing::Point(13, 230);
  444.             this->groupBox1->Name = L"groupBox1";
  445.             this->groupBox1->Size = System::Drawing::Size(393, 76);
  446.             this->groupBox1->TabIndex = 16;
  447.             this->groupBox1->TabStop = false;
  448.             this->groupBox1->Text = L"Поиск";
  449.             this->groupBox1->Visible = false;
  450.             this->groupBox1->Enter += gcnew System::EventHandler(this, &MyForm::groupBox1_Enter);
  451.             //
  452.             // label4
  453.             //
  454.             this->label4->AutoSize = true;
  455.             this->label4->Location = System::Drawing::Point(31, 22);
  456.             this->label4->Name = L"label4";
  457.             this->label4->Size = System::Drawing::Size(49, 13);
  458.             this->label4->TabIndex = 16;
  459.             this->label4->Text = L"Столбец";
  460.             //
  461.             // contextMenuStrip1
  462.             //
  463.             this->contextMenuStrip1->Name = L"contextMenuStrip1";
  464.             this->contextMenuStrip1->Size = System::Drawing::Size(61, 4);
  465.             //
  466.             // MyForm
  467.             //
  468.             this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);
  469.             this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
  470.             this->ClientSize = System::Drawing::Size(586, 323);
  471.             this->Controls->Add(this->groupBox1);
  472.             this->Controls->Add(this->button4);
  473.             this->Controls->Add(this->dataGridView1);
  474.             this->Controls->Add(this->menuStrip1);
  475.             this->MainMenuStrip = this->menuStrip1;
  476.             this->Name = L"MyForm";
  477.             this->Text = L"MyForm";
  478.             this->Load += gcnew System::EventHandler(this, &MyForm::MyForm_Load);
  479.             (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataSet1))->EndInit();
  480.             (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataTable1))->EndInit();
  481.             (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataGridView1))->EndInit();
  482.             this->menuStrip1->ResumeLayout(false);
  483.             this->menuStrip1->PerformLayout();
  484.             this->groupBox1->ResumeLayout(false);
  485.             this->groupBox1->PerformLayout();
  486.             this->ResumeLayout(false);
  487.             this->PerformLayout();
  488.  
  489.         }
  490. #pragma endregion
  491.     private: System::Void MyForm_Load(System::Object^  sender,
  492.         System::EventArgs^  e) {
  493.         oleDbDataAdapter1->SelectCommand->Parameters[0]->Value = "%%";
  494.         oleDbDataAdapter1->SelectCommand->Parameters[1]->Value = "%%";
  495.         this->comboBox3->Items->AddRange(gcnew cli::array< System::Object^  >(2) { L"Имя", L"Статус" });
  496.         comboBox3->SelectedIndex = 0;value
  497.         oleDbDataAdapter1->Fill(dataTable1);
  498.     }
  499.              void iva()
  500.              {
  501.                  for (int x = 0; x < 100; x++) {
  502.                      if (dataGridView1->Rows[x]->Cells[2]->FormattedValue->ToString() == "") break;
  503.                      dataGridView1->Rows[x]->Visible = true;
  504.                  }
  505.              }
  506.     private: System::Void button3_Click_1(System::Object^  sender, System::EventArgs^  e) {
  507.         iva();
  508.         for (int x = 0; x < 100; x++) {
  509.             if (dataGridView1->Rows[x]->Cells[0]->FormattedValue->ToString() == "") break;
  510.             dataGridView1->CurrentCell = dataGridView1->Rows[x + 1]->Cells[0];
  511.            
  512.         }
  513.     }
  514.     private: System::Void comboBox2_SelectedIndexChanged(System::Object^  sender, System::EventArgs^  e) {
  515.     }
  516.     private: System::Void button4_Click(System::Object^  sender, System::EventArgs^  e) {
  517.    
  518.         iva();
  519.     }
  520.  
  521.     private: System::Void dataGridView1_CellContentClick(System::Object^  sender,
  522.         System::Windows::Forms::DataGridViewCellEventArgs^  e) {
  523.     }
  524.  
  525.     private: System::Void поискToolStripMenuItem_Click(System::Object^  sender, System::EventArgs^  e) {
  526.         groupBox1->Visible = true;
  527.     }
  528.     private: System::Void comboBox3_SelectedIndexChanged(System::Object^  sender, System::EventArgs^  e) {
  529.     }
  530.              void vln()
  531.              {
  532.                  switch (comboBox3->SelectedIndex) {
  533.                  case 0:
  534.                      dataSet1->Clear();
  535.                      oleDbDataAdapter1->SelectCommand->Parameters["Name"]->Value =
  536.                          "%" + textBox1->Text + "%";
  537.                      oleDbDataAdapter1->Fill(dataTable1); break;
  538.                  case 1:
  539.                      dataSet1->Clear();
  540.                      oleDbDataAdapter1->SelectCommand->Parameters["Specialnost"]->Value =
  541.                          "%" + textBox1->Text + "%";
  542.                      oleDbDataAdapter1->Fill(dataTable1); break;
  543.                  case 2:
  544.                      dataSet1->Clear();
  545.                      oleDbDataAdapter1->SelectCommand->Parameters["Tema"]->Value =
  546.                          "%" + textBox1->Text + "%";
  547.                      oleDbDataAdapter1->Fill(dataTable1); break;
  548.                  case 3:
  549.                      dataSet1->Clear();
  550.                      oleDbDataAdapter1->SelectCommand->Parameters["Time"]->Value =
  551.                          "%" + textBox1->Text + "%";
  552.                      oleDbDataAdapter1->Fill(dataTable1); break;
  553.                  case 4:
  554.                      dataSet1->Clear();
  555.                      oleDbDataAdapter1->SelectCommand->Parameters["Rezultat"]->Value =
  556.                          "%" + textBox1->Text + "%";
  557.                      oleDbDataAdapter1->Fill(dataTable1); break;
  558.                  
  559.                  }
  560.              }
  561.  
  562.     private: System::Void button1_Click(System::Object^  sender,
  563.         System::EventArgs^  e) {
  564.         vln();
  565.     }
  566.  
  567.     private: System::Void button2_Click(System::Object^  sender,
  568.         System::EventArgs^ e) {
  569.     }
  570.  
  571.  
  572.     private: System::Void button3_Click(System::Object^  sender, System::EventArgs^  e) {
  573.  
  574.     }
  575.     private: System::Void comboBox1_SelectedIndexChanged(System::Object^  sender, System::EventArgs^  e) {
  576.     }
  577.     private: System::Void label1_Click(System::Object^  sender, System::EventArgs^  e) {
  578.     }
  579.  
  580.  
  581.     private: System::Void button6_Click(System::Object^  sender, System::EventArgs^  e) {
  582.         this->dataSet1->RejectChanges();
  583.     }
  584.  
  585.     private: System::Void сохранитьToolStripMenuItem_Click(System::Object^  sender, System::EventArgs^  e) {
  586.         this->oleDbDataAdapter1->Update(dataSet1->Tables["NPK"]);
  587.     }
  588.  
  589.     private: System::Void отменитьToolStripMenuItem_Click(System::Object^  sender, System::EventArgs^  e) {
  590.         this->dataSet1->RejectChanges();
  591.     }
  592.  
  593.     private: System::Void button5_Click(System::Object^  sender, System::EventArgs^  e) {
  594.         this->oleDbDataAdapter1->Update(dataSet1->Tables["NPK"]);
  595.     }
  596.  
  597.     private: System::Void выходToolStripMenuItem_Click(System::Object^  sender, System::EventArgs^  e) {
  598.         Application::Exit();
  599.     }
  600.  
  601.     private: System::Void textBox1_TextChanged(System::Object^  sender, System::EventArgs^  e) {
  602.     }
  603.  
  604.     private: System::Void dataGridView1_UserDeletingRow(System::Object^  sender, System::Windows::Forms::DataGridViewRowCancelEventArgs^  e) {
  605.         System::Windows::Forms::DialogResult
  606.             dr = MessageBox::Show("Удалить запись?", "Удаление записи", MessageBoxButtons::OKCancel, MessageBoxIcon::Warning, MessageBoxDefaultButton::Button2);
  607.         if (dr == System::Windows::Forms::DialogResult::OK) { e->Cancel = true; }
  608.     }
  609.  
  610.     private: System::Void groupBox1_Enter(System::Object^  sender, System::EventArgs^  e) {
  611.     }
  612.              // завершение работы программы
  613.     private: System::Void Form1_FormClosing(
  614.         System::Object^  sender,
  615.         System::Windows::Forms::FormClosingEventArgs^  e)
  616.     {
  617.         // обновить данные  
  618.         oleDbDataAdapter1->Update(dataSet1->Tables["NPK"]);
  619.     }
  620. private: System::Void oleDbDataAdapter1_RowUpdated(System::Object^  sender, System::Data::OleDb::OleDbRowUpdatedEventArgs^  e) {
  621. }
  622. private: System::Void oleDbConnection1_InfoMessage(System::Object^  sender, System::Data::OleDb::OleDbInfoMessageEventArgs^  e) {
  623. }
  624. };
  625. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!