O‘zbekiston respublikasi axborot texnologiyalari va kommunikatsiyalarini
Yüklə 1,31 Mb.
|
|
Studentlarni_yangilash.h
#pragma once #include"TTJ_sinf.h"; //#include"Form1.h"; //#include"Form1.h" namespace TTJ_New { using namespace System::ComponentModel; using namespace System::Collections; using namespace System::Windows::Forms; using namespace System::Data; using namespace System::Drawing; using namespace System::IO; using namespace System::Data::OleDb; /// /// Summary for Studentlarni_yangilash /// public ref class Studentlarni_yangilash : public System::Windows::Forms::Form { private: Object^ F1; public: Studentlarni_yangilash(Object^ o) { F1 = o; InitializeComponent(); // //TODO: Add the constructor code here // } public: System::Windows::Forms::Button^ button2; public: System::Windows::Forms::Label^ label18; private: System::Windows::Forms::DataGridView^ dataGridView1; public: System::Windows::Forms::TextBox^ textBox6; private: private: public: public: TTJ_sinf^ TTJ_3; protected: /// /// Clean up any resources being used. /// ~Studentlarni_yangilash() { if (components) { delete components; } } public: System::Windows::Forms::PictureBox^ pictureBox1; public: System::Windows::Forms::TabControl^ tabControl1; public: System::Windows::Forms::TabPage^ tabPage1; private: public: System::Windows::Forms::TextBox^ textBox1; public: private: System::Windows::Forms::TabPage^ tabPage2; private: System::Windows::Forms::TabPage^ tabPage3; public: System::Windows::Forms::Label^ label2; private: public: System::Windows::Forms::TextBox^ textBox2; public: System::Windows::Forms::Label^ label1; public: System::Windows::Forms::Label^ label8; public: System::Windows::Forms::Label^ label7; private: public: System::Windows::Forms::TextBox^ textBox8; public: System::Windows::Forms::Label^ label6; private: public: public: System::Windows::Forms::TextBox^ textBox7; private: public: System::Windows::Forms::Label^ label5; public: public: System::Windows::Forms::TextBox^ textBox5; public: System::Windows::Forms::Label^ label4; private: public: public: System::Windows::Forms::TextBox^ textBox4; public: System::Windows::Forms::Label^ label3; private: public: public: System::Windows::Forms::TextBox^ textBox3; public: System::Windows::Forms::Label^ label9; public: System::Windows::Forms::Label^ label10; private: public: public: System::Windows::Forms::TextBox^ textBox9; public: System::Windows::Forms::Label^ label11; private: public: public: System::Windows::Forms::TextBox^ textBox10; private: public: System::Windows::Forms::TextBox^ textBox11; public: System::Windows::Forms::Label^ label13; public: private: public: public: System::Windows::Forms::TextBox^ textBox13; public: System::Windows::Forms::Label^ label14; private: public: public: System::Windows::Forms::TextBox^ textBox14; public: System::Windows::Forms::Label^ label15; private: public: public: System::Windows::Forms::TextBox^ textBox15; public: System::Windows::Forms::Label^ label16; private: public: public: System::Windows::Forms::TextBox^ textBox16; public: System::Windows::Forms::Label^ label20; private: public: public: System::Windows::Forms::TextBox^ textBox20; public: System::Windows::Forms::Label^ label21; private: public: public: System::Windows::Forms::TextBox^ textBox21; public: System::Windows::Forms::Label^ label22; private: public: public: System::Windows::Forms::TextBox^ textBox22; public: System::Windows::Forms::Label^ label23; private: public: public: System::Windows::Forms::TextBox^ textBox23; public: System::Windows::Forms::Label^ label24; private: public: public: System::Windows::Forms::TextBox^ textBox24; public: System::Windows::Forms::Label^ label12; public: public: System::Windows::Forms::TextBox^ textBox12; public: System::Windows::Forms::Label^ label17; public: public: System::Windows::Forms::TextBox^ textBox17; public: System::Windows::Forms::Button^ button1; public: private: private: private: public: private: public: protected: protected: private: /// /// Required designer variable. /// System::ComponentModel::Container ^components; #pragma region Windows Form Designer generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// void InitializeComponent(void) { System::ComponentModel::ComponentResourceManager^ resources = (gcnew System::ComponentModel::ComponentResourceManager(Studentlarni_yangilash::typeid)); this->pictureBox1 = (gcnew System::Windows::Forms::PictureBox()); this->tabControl1 = (gcnew System::Windows::Forms::TabControl()); this->tabPage1 = (gcnew System::Windows::Forms::TabPage()); this->textBox6 = (gcnew System::Windows::Forms::TextBox()); this->label8 = (gcnew System::Windows::Forms::Label()); this->label7 = (gcnew System::Windows::Forms::Label()); this->textBox8 = (gcnew System::Windows::Forms::TextBox()); this->label6 = (gcnew System::Windows::Forms::Label()); this->textBox7 = (gcnew System::Windows::Forms::TextBox()); this->label5 = (gcnew System::Windows::Forms::Label()); this->textBox5 = (gcnew System::Windows::Forms::TextBox()); this->label4 = (gcnew System::Windows::Forms::Label()); this->textBox4 = (gcnew System::Windows::Forms::TextBox()); this->label3 = (gcnew System::Windows::Forms::Label()); this->textBox3 = (gcnew System::Windows::Forms::TextBox()); this->label2 = (gcnew System::Windows::Forms::Label()); this->textBox2 = (gcnew System::Windows::Forms::TextBox()); this->label1 = (gcnew System::Windows::Forms::Label()); this->textBox1 = (gcnew System::Windows::Forms::TextBox()); this->tabPage2 = (gcnew System::Windows::Forms::TabPage()); this->label9 = (gcnew System::Windows::Forms::Label()); this->label10 = (gcnew System::Windows::Forms::Label()); this->textBox9 = (gcnew System::Windows::Forms::TextBox()); this->label11 = (gcnew System::Windows::Forms::Label()); this->textBox10 = (gcnew System::Windows::Forms::TextBox()); this->textBox11 = (gcnew System::Windows::Forms::TextBox()); this->label13 = (gcnew System::Windows::Forms::Label()); this->textBox13 = (gcnew System::Windows::Forms::TextBox()); this->label14 = (gcnew System::Windows::Forms::Label()); this->textBox14 = (gcnew System::Windows::Forms::TextBox()); this->label15 = (gcnew System::Windows::Forms::Label()); this->textBox15 = (gcnew System::Windows::Forms::TextBox()); this->label16 = (gcnew System::Windows::Forms::Label()); this->textBox16 = (gcnew System::Windows::Forms::TextBox()); this->tabPage3 = (gcnew System::Windows::Forms::TabPage()); this->label17 = (gcnew System::Windows::Forms::Label()); this->label12 = (gcnew System::Windows::Forms::Label()); this->label20 = (gcnew System::Windows::Forms::Label()); this->textBox20 = (gcnew System::Windows::Forms::TextBox()); this->label21 = (gcnew System::Windows::Forms::Label()); this->textBox21 = (gcnew System::Windows::Forms::TextBox()); this->label22 = (gcnew System::Windows::Forms::Label()); this->textBox22 = (gcnew System::Windows::Forms::TextBox()); this->label23 = (gcnew System::Windows::Forms::Label()); this->textBox17 = (gcnew System::Windows::Forms::TextBox()); this->textBox23 = (gcnew System::Windows::Forms::TextBox()); this->textBox12 = (gcnew System::Windows::Forms::TextBox()); this->label24 = (gcnew System::Windows::Forms::Label()); this->textBox24 = (gcnew System::Windows::Forms::TextBox()); this->button1 = (gcnew System::Windows::Forms::Button()); this->label18 = (gcnew System::Windows::Forms::Label()); this->button2 = (gcnew System::Windows::Forms::Button()); this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView()); (cli::safe_cast this->tabControl1->SuspendLayout(); this->tabPage1->SuspendLayout(); this->tabPage2->SuspendLayout(); this->tabPage3->SuspendLayout(); (cli::safe_cast this->SuspendLayout(); // // pictureBox1 // this->pictureBox1->Image = (cli::safe_cast this->pictureBox1->Location = System::Drawing::Point(12, 66); this->pictureBox1->Name = L"pictureBox1"; this->pictureBox1->Size = System::Drawing::Size(161, 163); this->pictureBox1->SizeMode = System::Windows::Forms::PictureBoxSizeMode::StretchImage; this->pictureBox1->TabIndex = 3; this->pictureBox1->TabStop = false; this->pictureBox1->WaitOnLoad = true; this->pictureBox1->Click += gcnew System::EventHandler(this, &Studentlarni_yangilash::pictureBox1_Click); // // tabControl1 // this->tabControl1->Controls->Add(this->tabPage1); this->tabControl1->Controls->Add(this->tabPage2); this->tabControl1->Controls->Add(this->tabPage3); this->tabControl1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 10.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->tabControl1->Location = System::Drawing::Point(179, 12); this->tabControl1->Name = L"tabControl1"; this->tabControl1->SelectedIndex = 0; this->tabControl1->Size = System::Drawing::Size(535, 375); this->tabControl1->TabIndex = 0; // // tabPage1 // this->tabPage1->BackColor = System::Drawing::Color::WhiteSmoke; this->tabPage1->Controls->Add(this->textBox6); this->tabPage1->Controls->Add(this->label8); this->tabPage1->Controls->Add(this->label7); this->tabPage1->Controls->Add(this->textBox8); this->tabPage1->Controls->Add(this->label6); this->tabPage1->Controls->Add(this->textBox7); this->tabPage1->Controls->Add(this->label5); this->tabPage1->Controls->Add(this->textBox5); this->tabPage1->Controls->Add(this->label4); this->tabPage1->Controls->Add(this->textBox4); this->tabPage1->Controls->Add(this->label3); this->tabPage1->Controls->Add(this->textBox3); this->tabPage1->Controls->Add(this->label2); this->tabPage1->Controls->Add(this->textBox2); this->tabPage1->Controls->Add(this->label1); this->tabPage1->Controls->Add(this->textBox1); this->tabPage1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->tabPage1->Location = System::Drawing::Point(4, 26); this->tabPage1->Name = L"tabPage1"; this->tabPage1->Padding = System::Windows::Forms::Padding(3); this->tabPage1->Size = System::Drawing::Size(527, 345); this->tabPage1->TabIndex = 0; this->tabPage1->Text = L"Asosiy ma`lumotlar"; // // textBox6 // this->textBox6->Location = System::Drawing::Point(168, 225); this->textBox6->Multiline = true; this->textBox6->Name = L"textBox6"; this->textBox6->Size = System::Drawing::Size(353, 33); this->textBox6->TabIndex = 5; this->textBox6->Text = L"A,B,V"; this->textBox6->TextChanged += gcnew System::EventHandler(this, &Studentlarni_yangilash::textBox6_TextChanged); // // label8 // this->label8->AutoSize = true; this->label8->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label8->Location = System::Drawing::Point(12, 308); this->label8->Name = L"label8"; this->label8->Size = System::Drawing::Size(83, 24); this->label8->TabIndex = 3; this->label8->Text = L"Telefoni:"; // // label7 // this->label7->AutoSize = true; this->label7->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label7->Location = System::Drawing::Point(12, 267); this->label7->Name = L"label7"; this->label7->Size = System::Drawing::Size(132, 24); this->label7->TabIndex = 3; this->label7->Text = L"Qavat_nomeri:"; // // textBox8 // this->textBox8->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox8->Location = System::Drawing::Point(169, 305); this->textBox8->Multiline = true; this->textBox8->Name = L"textBox8"; this->textBox8->Size = System::Drawing::Size(354, 34); this->textBox8->TabIndex = 7; // // label6 // this->label6->AutoSize = true; this->label6->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label6->Location = System::Drawing::Point(12, 227); this->label6->Name = L"label6"; this->label6->Size = System::Drawing::Size(100, 24); this->label6->TabIndex = 3; this->label6->Text = L"Bino nomi:"; // // textBox7 // this->textBox7->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox7->Location = System::Drawing::Point(169, 264); this->textBox7->Multiline = true; this->textBox7->Name = L"textBox7"; this->textBox7->Size = System::Drawing::Size(354, 34); this->textBox7->TabIndex = 6; // // label5 // this->label5->AutoSize = true; this->label5->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label5->Location = System::Drawing::Point(12, 188); this->label5->Name = L"label5"; this->label5->Size = System::Drawing::Size(125, 24); this->label5->TabIndex = 3; this->label5->Text = L"Xona nomeri:"; // // textBox5 // this->textBox5->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox5->Location = System::Drawing::Point(169, 185); this->textBox5->Multiline = true; this->textBox5->Name = L"textBox5"; this->textBox5->Size = System::Drawing::Size(354, 34); this->textBox5->TabIndex = 4; this->textBox5->TextChanged += gcnew System::EventHandler(this, &Studentlarni_yangilash::textBox5_TextChanged); // // label4 // this->label4->AutoSize = true; this->label4->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label4->Location = System::Drawing::Point(12, 149); this->label4->Name = L"label4"; this->label4->Size = System::Drawing::Size(72, 24); this->label4->TabIndex = 1; this->label4->Text = L"Guruhi:"; // // textBox4 // this->textBox4->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox4->Location = System::Drawing::Point(169, 146); this->textBox4->Multiline = true; this->textBox4->Name = L"textBox4"; this->textBox4->Size = System::Drawing::Size(354, 34); this->textBox4->TabIndex = 3; this->textBox4->TextChanged += gcnew System::EventHandler(this, &Studentlarni_yangilash::textBox4_TextChanged); // // label3 // this->label3->AutoSize = true; this->label3->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label3->Location = System::Drawing::Point(12, 109); this->label3->Name = L"label3"; this->label3->Size = System::Drawing::Size(62, 24); this->label3->TabIndex = 1; this->label3->Text = L"Sharfi:"; // // textBox3 // this->textBox3->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox3->Location = System::Drawing::Point(169, 106); this->textBox3->Multiline = true; this->textBox3->Name = L"textBox3"; this->textBox3->Size = System::Drawing::Size(354, 34); this->textBox3->TabIndex = 2; // // label2 // this->label2->AutoSize = true; this->label2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label2->Location = System::Drawing::Point(12, 69); this->label2->Name = L"label2"; this->label2->Size = System::Drawing::Size(48, 24); this->label2->TabIndex = 1; this->label2->Text = L"Ismi:"; // // textBox2 // this->textBox2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox2->Location = System::Drawing::Point(169, 66); this->textBox2->Multiline = true; this->textBox2->Name = L"textBox2"; this->textBox2->Size = System::Drawing::Size(354, 34); this->textBox2->TabIndex = 1; // // label1 // this->label1->AutoSize = true; this->label1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label1->Location = System::Drawing::Point(12, 28); this->label1->Name = L"label1"; this->label1->Size = System::Drawing::Size(53, 24); this->label1->TabIndex = 1; this->label1->Text = L"Fam:"; // // textBox1 // this->textBox1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox1->Location = System::Drawing::Point(169, 25); this->textBox1->Multiline = true; this->textBox1->Name = L"textBox1"; this->textBox1->Size = System::Drawing::Size(354, 34); this->textBox1->TabIndex = 0; // // tabPage2 // this->tabPage2->BackColor = System::Drawing::Color::WhiteSmoke; this->tabPage2->Controls->Add(this->label9); this->tabPage2->Controls->Add(this->label10); this->tabPage2->Controls->Add(this->textBox9); this->tabPage2->Controls->Add(this->label11); this->tabPage2->Controls->Add(this->textBox10); this->tabPage2->Controls->Add(this->textBox11); this->tabPage2->Controls->Add(this->label13); this->tabPage2->Controls->Add(this->textBox13); this->tabPage2->Controls->Add(this->label14); this->tabPage2->Controls->Add(this->textBox14); this->tabPage2->Controls->Add(this->label15); this->tabPage2->Controls->Add(this->textBox15); this->tabPage2->Controls->Add(this->label16); this->tabPage2->Controls->Add(this->textBox16); this->tabPage2->Location = System::Drawing::Point(4, 26); this->tabPage2->Name = L"tabPage2"; this->tabPage2->Padding = System::Windows::Forms::Padding(3); this->tabPage2->Size = System::Drawing::Size(527, 345); this->tabPage2->TabIndex = 1; this->tabPage2->Text = L"Qo`shimcha ma`lumotlar_1"; // // label9 // this->label9->AutoSize = true; this->label9->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label9->Location = System::Drawing::Point(15, 265); this->label9->Name = L"label9"; this->label9->Size = System::Drawing::Size(129, 24); this->label9->TabIndex = 16; this->label9->Text = L"Tugilgan kuni:"; // // label10 // this->label10->AutoSize = true; this->label10->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label10->Location = System::Drawing::Point(15, 224); this->label10->Name = L"label10"; this->label10->Size = System::Drawing::Size(118, 24); this->label10->TabIndex = 17; this->label10->Text = L"Tugilgan oyi:"; // // textBox9 // this->textBox9->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox9->Location = System::Drawing::Point(167, 19); this->textBox9->Multiline = true; this->textBox9->Name = L"textBox9"; this->textBox9->Size = System::Drawing::Size(333, 34); this->textBox9->TabIndex = 0; // // label11 // this->label11->AutoSize = true; this->label11->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label11->Location = System::Drawing::Point(15, 184); this->label11->Name = L"label11"; this->label11->Size = System::Drawing::Size(115, 24); this->label11->TabIndex = 18; this->label11->Text = L"Tugilgan yili:"; // // textBox10 // this->textBox10->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox10->Location = System::Drawing::Point(167, 59); this->textBox10->Multiline = true; this->textBox10->Name = L"textBox10"; this->textBox10->Size = System::Drawing::Size(333, 34); this->textBox10->TabIndex = 1; // // textBox11 // this->textBox11->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox11->Location = System::Drawing::Point(167, 100); this->textBox11->Multiline = true; this->textBox11->Name = L"textBox11"; this->textBox11->Size = System::Drawing::Size(333, 34); this->textBox11->TabIndex = 2; this->textBox11->Text = L"12.12.1998"; this->textBox11->TextChanged += gcnew System::EventHandler(this, &Studentlarni_yangilash::textBox11_TextChanged); // // label13 // this->label13->AutoSize = true; this->label13->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label13->Location = System::Drawing::Point(15, 143); this->label13->Name = L"label13"; this->label13->Size = System::Drawing::Size(142, 24); this->label13->TabIndex = 8; this->label13->Text = L"Pasport nomeri:"; // // textBox13 // this->textBox13->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox13->Location = System::Drawing::Point(167, 140); this->textBox13->Multiline = true; this->textBox13->Name = L"textBox13"; this->textBox13->Size = System::Drawing::Size(333, 34); this->textBox13->TabIndex = 3; // // label14 // this->label14->AutoSize = true; this->label14->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label14->Location = System::Drawing::Point(15, 103); this->label14->Name = L"label14"; this->label14->Size = System::Drawing::Size(134, 24); this->label14->TabIndex = 9; this->label14->Text = L"Tugilgan sana:"; // // textBox14 // this->textBox14->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox14->Location = System::Drawing::Point(167, 180); this->textBox14->Multiline = true; this->textBox14->Name = L"textBox14"; this->textBox14->Size = System::Drawing::Size(333, 34); this->textBox14->TabIndex = 4; // // label15 // this->label15->AutoSize = true; this->label15->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label15->Location = System::Drawing::Point(15, 63); this->label15->Name = L"label15"; this->label15->Size = System::Drawing::Size(136, 24); this->label15->TabIndex = 10; this->label15->Text = L"Pasport seriasi:"; // // textBox15 // this->textBox15->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox15->Location = System::Drawing::Point(167, 220); this->textBox15->Multiline = true; this->textBox15->Name = L"textBox15"; this->textBox15->Size = System::Drawing::Size(333, 34); this->textBox15->TabIndex = 5; // // label16 // this->label16->AutoSize = true; this->label16->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label16->Location = System::Drawing::Point(12, 22); this->label16->Name = L"label16"; this->label16->Size = System::Drawing::Size(149, 24); this->label16->TabIndex = 11; this->label16->Text = L"Tugilgan viloyati:"; // // textBox16 // this->textBox16->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox16->Location = System::Drawing::Point(167, 260); this->textBox16->Multiline = true; this->textBox16->Name = L"textBox16"; this->textBox16->Size = System::Drawing::Size(333, 34); this->textBox16->TabIndex = 6; // // tabPage3 // this->tabPage3->BackColor = System::Drawing::Color::WhiteSmoke; this->tabPage3->Controls->Add(this->label17); this->tabPage3->Controls->Add(this->label12); this->tabPage3->Controls->Add(this->label20); this->tabPage3->Controls->Add(this->textBox20); this->tabPage3->Controls->Add(this->label21); this->tabPage3->Controls->Add(this->textBox21); this->tabPage3->Controls->Add(this->label22); this->tabPage3->Controls->Add(this->textBox22); this->tabPage3->Controls->Add(this->label23); this->tabPage3->Controls->Add(this->textBox17); this->tabPage3->Controls->Add(this->textBox23); this->tabPage3->Controls->Add(this->textBox12); this->tabPage3->Controls->Add(this->label24); this->tabPage3->Controls->Add(this->textBox24); this->tabPage3->Location = System::Drawing::Point(4, 26); this->tabPage3->Name = L"tabPage3"; this->tabPage3->Padding = System::Windows::Forms::Padding(3); this->tabPage3->Size = System::Drawing::Size(527, 345); this->tabPage3->TabIndex = 2; this->tabPage3->Text = L"Qo`shimcha ma`lumotlar_2"; // // label17 // this->label17->AutoSize = true; this->label17->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label17->Location = System::Drawing::Point(10, 275); this->label17->Name = L"label17"; this->label17->Size = System::Drawing::Size(87, 24); this->label17->TabIndex = 35; this->label17->Text = L"Bosqichi:"; // // label12 // this->label12->AutoSize = true; this->label12->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label12->Location = System::Drawing::Point(10, 233); this->label12->Name = L"label12"; this->label12->Size = System::Drawing::Size(150, 24); this->label12->TabIndex = 35; this->label12->Text = L"Yashash manzili:"; // // label20 // this->label20->AutoSize = true; this->label20->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label20->Location = System::Drawing::Point(10, 192); this->label20->Name = L"label20"; this->label20->Size = System::Drawing::Size(84, 24); this->label20->TabIndex = 35; this->label20->Text = L"Lavozim:"; // // textBox20 // this->textBox20->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox20->Location = System::Drawing::Point(175, 23); this->textBox20->Multiline = true; this->textBox20->Name = L"textBox20"; this->textBox20->Size = System::Drawing::Size(333, 34); this->textBox20->TabIndex = 0; // // label21 // this->label21->AutoSize = true; this->label21->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label21->Location = System::Drawing::Point(10, 153); this->label21->Name = L"label21"; this->label21->Size = System::Drawing::Size(52, 24); this->label21->TabIndex = 24; this->label21->Text = L"Jinsi:"; // // textBox21 // this->textBox21->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox21->Location = System::Drawing::Point(175, 63); this->textBox21->Multiline = true; this->textBox21->Name = L"textBox21"; this->textBox21->Size = System::Drawing::Size(333, 34); this->textBox21->TabIndex = 1; // // label22 // this->label22->AutoSize = true; this->label22->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label22->Location = System::Drawing::Point(10, 113); this->label22->Name = L"label22"; this->label22->Size = System::Drawing::Size(154, 24); this->label22->TabIndex = 25; this->label22->Text = L"Tug\'ilgan tumani:"; // // textBox22 // this->textBox22->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox22->Location = System::Drawing::Point(175, 103); this->textBox22->Multiline = true; this->textBox22->Name = L"textBox22"; this->textBox22->Size = System::Drawing::Size(333, 34); this->textBox22->TabIndex = 2; // // label23 // this->label23->AutoSize = true; this->label23->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label23->Location = System::Drawing::Point(10, 73); this->label23->Name = L"label23"; this->label23->Size = System::Drawing::Size(91, 24); this->label23->TabIndex = 26; this->label23->Text = L"Yonalishi:"; // // textBox17 // this->textBox17->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox17->Location = System::Drawing::Point(175, 265); this->textBox17->Multiline = true; this->textBox17->Name = L"textBox17"; this->textBox17->Size = System::Drawing::Size(333, 34); this->textBox17->TabIndex = 6; // // textBox23 // this->textBox23->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox23->Location = System::Drawing::Point(175, 143); this->textBox23->Multiline = true; this->textBox23->Name = L"textBox23"; this->textBox23->Size = System::Drawing::Size(333, 34); this->textBox23->TabIndex = 3; // // textBox12 // this->textBox12->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox12->Location = System::Drawing::Point(175, 223); this->textBox12->Multiline = true; this->textBox12->Name = L"textBox12"; this->textBox12->Size = System::Drawing::Size(333, 34); this->textBox12->TabIndex = 5; // // label24 // this->label24->AutoSize = true; this->label24->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->label24->Location = System::Drawing::Point(7, 32); this->label24->Name = L"label24"; this->label24->Size = System::Drawing::Size(84, 24); this->label24->TabIndex = 27; this->label24->Text = L"Fakulteti:"; // // textBox24 // this->textBox24->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->textBox24->Location = System::Drawing::Point(175, 182); this->textBox24->Multiline = true; this->textBox24->Name = L"textBox24"; this->textBox24->Size = System::Drawing::Size(333, 34); this->textBox24->TabIndex = 4; // // button1 // this->button1->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->button1->Location = System::Drawing::Point(351, 387); this->button1->Name = L"button1"; this->button1->Size = System::Drawing::Size(131, 38); this->button1->TabIndex = 1; this->button1->Text = L"Yangilash"; this->button1->UseVisualStyleBackColor = true; this->button1->Click += gcnew System::EventHandler(this, &Studentlarni_yangilash::button1_Click); // // label18 // this->label18->AutoSize = true; this->label18->Location = System::Drawing::Point(180, 402); this->label18->Name = L"label18"; this->label18->Size = System::Drawing::Size(41, 13); this->label18->TabIndex = 8; this->label18->Text = L"label18"; this->label18->Visible = false; // // button2 // this->button2->Font = (gcnew System::Drawing::Font(L"Microsoft Sans Serif", 14.25F, System::Drawing::FontStyle::Regular, System::Drawing::GraphicsUnit::Point, static_cast this->button2->Location = System::Drawing::Point(576, 385); this->button2->Name = L"button2"; this->button2->Size = System::Drawing::Size(132, 38); this->button2->TabIndex = 9; this->button2->Text = L"Saqlash"; this->button2->UseVisualStyleBackColor = true; this->button2->Click += gcnew System::EventHandler(this, &Studentlarni_yangilash::button2_Click); // // dataGridView1 // this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize; this->dataGridView1->Location = System::Drawing::Point(28, 235); this->dataGridView1->Name = L"dataGridView1"; this->dataGridView1->Size = System::Drawing::Size(132, 76); this->dataGridView1->TabIndex = 10; this->dataGridView1->Visible = false; // // Studentlarni_yangilash // this->AutoScaleDimensions = System::Drawing::SizeF(6, 13); this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font; this->ClientSize = System::Drawing::Size(721, 430); this->Controls->Add(this->dataGridView1); this->Controls->Add(this->button2); this->Controls->Add(this->label18); this->Controls->Add(this->button1); this->Controls->Add(this->tabControl1); this->Controls->Add(this->pictureBox1); this->MaximizeBox = false; this->Name = L"Studentlarni_yangilash"; this->StartPosition = System::Windows::Forms::FormStartPosition::Manual; this->Text = L"Studentlarning ma\'lumotlarini yangilash oynasi"; this->FormClosed += gcnew System::Windows::Forms::FormClosedEventHandler(this, &Studentlarni_yangilash::Studentlarni_yangilash_FormClosed); this->Load += gcnew System::EventHandler(this, &Studentlarni_yangilash::Studentlarni_yangilash_Load); (cli::safe_cast this->tabControl1->ResumeLayout(false); this->tabPage1->ResumeLayout(false); this->tabPage1->PerformLayout(); this->tabPage2->ResumeLayout(false); this->tabPage2->PerformLayout(); this->tabPage3->ResumeLayout(false); this->tabPage3->PerformLayout(); (cli::safe_cast this->ResumeLayout(false); this->PerformLayout(); }
private: array MemoryStream^ ms=gcnew MemoryStream(); pictureBox1->Image->Save(ms,pictureBox1->Image->RawFormat); return ms->GetBuffer(); } DataSet ^ НаборДанных; OleDb::OleDbDataAdapter ^ Адаптер; OleDb::OleDbConnection ^ Ulanish; OleDb::OleDbCommand ^ Команда; public: static int Id, Kornat; private: void ornatish(int h){ //ulanish_new(); OleDbConnection^ con = gcnew OleDbConnection("Data Source=\"TTJ.mdb\";User " + "ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";"); con->Open(); if(h==1){ try{ //if(DialogResult.Equals( MessageBox::Show("Ma'lumotlarni yangilash", "Haqiqatdan ham ushbu talabani yangilamoqchimisiz?", //MessageBoxButtons::OKCancel, MessageBoxIcon::Information))!=0) Команда = gcnew OleDb::OleDbCommand("Select * From [Talabalar]", con); Команда->CommandText = "UPDATE Talabalar SET Fam = @Fam, Ism = @Ism, Sharf = @Sharf, Guruh = @Guruh, Xona_nomeri = @Xona_nomeri, Blok_nomi = @Blok_nomi,"+ "Qavat_nomeri = @Qavat_nomeri, Telefoni = @Telefoni, Tugilgan_viloyati = @Tugilgan_viloyati, Pasport_seriasi = @Pasport_seriasi, "+ " Tugilgan_Sana = @Tugilgan_Sana, Pasport_nomeri = @Pasport_nomeri, Tugilgan_yili = @Tugilgan_yili, Tugilgan_oyi = @Tugilgan_oyi,"+ " Tugilgan_kuni = @Tugilgan_kuni, Fakulteti = @Fakulteti, Yonalishi = @Yonalishi, Tugilgan_tumani = @Tugilgan_tumani,"+ " Jinsi = @Jinsi, Lavozim = @Lavozim, Yashash_manzili = @Yashash_manzili, Bosqich = @Bosqich, Rasm = @Rasm WHERE id = @Id"; Команда->Parameters->AddWithValue("@Fam",textBox1->Text); Команда->Parameters->AddWithValue("@Ism",textBox2->Text); Команда->Parameters->AddWithValue("@Sharf",textBox3->Text); Команда->Parameters->AddWithValue("@Guruh",textBox4->Text); Команда->Parameters->AddWithValue("@Xona_nomeri",textBox5->Text); Команда->Parameters->AddWithValue("@Blok_nomi",textBox6->Text); Команда->Parameters->AddWithValue("@Qavat_nomeri",textBox7->Text); Команда->Parameters->AddWithValue("@Telefoni",textBox8->Text); Команда->Parameters->AddWithValue("@Tugilgan_viloyati",textBox9->Text); Команда->Parameters->AddWithValue("@Pasport_seriasi",textBox10->Text); Команда->Parameters->AddWithValue("@Tugilgan_Sana",textBox11->Text); Команда->Parameters->AddWithValue("@Pasport_nomeri",textBox13->Text); Команда->Parameters->AddWithValue("@Tugilgan_yili",textBox14->Text); Команда->Parameters->AddWithValue("@Tugilgan_oyi",textBox15->Text); Команда->Parameters->AddWithValue("@Tugilgan_kuni",textBox16->Text); Команда->Parameters->AddWithValue("@Fakulteti",textBox20->Text); Команда->Parameters->AddWithValue("@Yonalishi",textBox21->Text); Команда->Parameters->AddWithValue("@Tugilgan_tumani",textBox22->Text); Команда->Parameters->AddWithValue("@Jinsi",textBox23->Text); Команда->Parameters->AddWithValue("@Lavozim",textBox24->Text); Команда->Parameters->AddWithValue("@Yashash_manzili",textBox12->Text); Команда->Parameters->AddWithValue("@Bosqich",textBox17->Text); Команда->Parameters->AddWithValue("@Rasm",SaveRasm()); Команда->Parameters->AddWithValue("@Id",Id); Команда->ExecuteNonQuery(); MessageBox::Show("Talabalar jadvalining ma'lumotlari muaafaqiyatli yangilandi");} //else{MessageBox::Show("Ma'lumotlar o'zgartirilmadi");} catch(Exception^ vaziyat) {MessageBox::Show("Talabalar jadvalini yangilashda xatolik yuz berdi");} } else if(h==2) { try{ Команда = gcnew OleDb::OleDbCommand("Select * From [Qarindoshlar]", con); Команда->CommandText = "UPDATE Qarindoshlar SET Fam = @Fam, Ismi = @Ism, Sharfi = @Sharf, Yashash_manzili = @Yashash_manzili, Tugilgan_sana = @Tugilgan_sana, Qarindoshlik_turi = @Qarindoshlik_turi,"+ "Id_nomeri = @Id_nomeri, Ish_joyi = @Ish_joyi, Telefoni = @Telefoni WHERE id = @Id"; Команда->Parameters->AddWithValue("@Fam",textBox1->Text); Команда->Parameters->AddWithValue("@Ism",textBox2->Text); Команда->Parameters->AddWithValue("@Sharf",textBox3->Text); Команда->Parameters->AddWithValue("@Yashash_manzili",textBox4->Text); Команда->Parameters->AddWithValue("@Tugilgan_sana",textBox5->Text); Команда->Parameters->AddWithValue("@Qarindoshlik_turi",textBox6->Text); Команда->Parameters->AddWithValue("@Id_nomeri",textBox7->Text); Команда->Parameters->AddWithValue("@Ish_joyi",textBox8->Text); Команда->Parameters->AddWithValue("@Telefoni",textBox9->Text); Команда->Parameters->AddWithValue("@Id",Id); Команда->ExecuteNonQuery(); MessageBox::Show("Qarindoshlar jadvalining ma'lumotlari muaafaqiyatli yangilandi");} //else{MessageBox::Show("Ma'lumotlar o'zgartirilmadi");} catch(Exception^ vaziyat) {MessageBox::Show("Qarindoshlar jadvalini yangilashda xatolik yuz berdi");} } TTJ_3 = gcnew TTJ_sinf(); bool s; TTJ_3->ShowRecord(dataGridView1,"Select * From Talabalar"); delete TTJ_3; }
ornatish(Kornat); }
OpenFileDialog^ och=gcnew OpenFileDialog(); och->Title="Rasmni tanlash oynasi"; och->Filter="Image File(*.png; *.jpg; *.bmp; *.gif)|*.png; *.jpg; *.bmp; *.gif"; och->ShowDialog(); //if( DialogResult.Equals(och->ShowDialog) ) try{ pictureBox1->Image = gcnew Bitmap(och->FileName);} catch(Exception^ vaziyat){ MessageBox::Show("Rasm tanlamadingiz"); } } public: System::Void Saqlash(){ OleDbConnection^ con = gcnew OleDbConnection("Data Source=\"TTJ.mdb\";User " + "ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";"); con->Open(); try{ //if(DialogResult.Equals( MessageBox::Show("Ma'lumotlarni yangilash", "Haqiqatdan ham ushbu talabani yangilamoqchimisiz?", //MessageBoxButtons::OKCancel, MessageBoxIcon::Information))!=0) Команда = gcnew OleDb::OleDbCommand("Select * From [Talabalar]", con); Команда->CommandText = "INSERT INTO Talabalar (Fam, Ism, Sharf, Guruh, Xona_nomeri, Blok_nomi, Qavat_nomeri, Telefoni, Tugilgan_viloyati, Pasport_seriasi, "+ " Tugilgan_Sana, Pasport_nomeri, Tugilgan_yili, Tugilgan_oyi, Tugilgan_kuni, Fakulteti, Yonalishi, Tugilgan_tumani,"+ " Jinsi, Lavozim, Yashash_manzili, Bosqich, Rasm) VALUES(@Fam, @Ism, @Sharf, @Guruh, @Xona_nomeri, @Blok_nomi, @Qavat_nomeri, @Telefoni, @Tugilgan_viloyati, @Pasport_seriasi, "+ " @Tugilgan_Sana, @Pasport_nomeri, @Tugilgan_yili, @Tugilgan_oyi, @Tugilgan_kuni, @Fakulteti, @Yonalishi, @Tugilgan_tumani,"+ " @Jinsi, @Lavozim, @Yashash_manzili, @Bosqich, @Rasm)"; Команда->Parameters->AddWithValue("@Fam",textBox1->Text); Команда->Parameters->AddWithValue("@Ism",textBox2->Text); Команда->Parameters->AddWithValue("@Sharf",textBox3->Text); Команда->Parameters->AddWithValue("@Guruh",textBox4->Text); Команда->Parameters->AddWithValue("@Xona_nomeri",textBox5->Text); Команда->Parameters->AddWithValue("@Blok_nomi",textBox6->Text); Команда->Parameters->AddWithValue("@Qavat_nomeri",textBox7->Text); Команда->Parameters->AddWithValue("@Telefoni",textBox8->Text); Команда->Parameters->AddWithValue("@Tugilgan_viloyati",textBox9->Text); Команда->Parameters->AddWithValue("@Pasport_seriasi",textBox10->Text); Команда->Parameters->AddWithValue("@Tugilgan_Sana",textBox11->Text); Команда->Parameters->AddWithValue("@Pasport_nomeri",textBox13->Text); Команда->Parameters->AddWithValue("@Tugilgan_yili",textBox14->Text); Команда->Parameters->AddWithValue("@Tugilgan_oyi",textBox15->Text); Команда->Parameters->AddWithValue("@Tugilgan_kuni",textBox16->Text); Команда->Parameters->AddWithValue("@Fakulteti",textBox20->Text); Команда->Parameters->AddWithValue("@Yonalishi",textBox21->Text); Команда->Parameters->AddWithValue("@Tugilgan_tumani",textBox22->Text); Команда->Parameters->AddWithValue("@Jinsi",textBox23->Text); Команда->Parameters->AddWithValue("@Lavozim",textBox24->Text); Команда->Parameters->AddWithValue("@Yashash_manzili",textBox12->Text); Команда->Parameters->AddWithValue("@Bosqich",textBox17->Text); Команда->Parameters->AddWithValue("@Rasm",SaveRasm()); Команда->ExecuteNonQuery(); MessageBox::Show("Talabalar jadvaliga yangi ma'lumotlar kiritildi");} //else{MessageBox::Show("Ma'lumotlar o'zgartirilmadi");} catch(Exception^ vaziyat) {MessageBox::Show(Convert::ToString(vaziyat));} //
//"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TTJ.mdb"); //// Открытие подключения: //Подключение->Open(); //OleDb::OleDbDataAdapter ^ Adapter; // //// Создание экземпляра объекта Command с заданием SQL-запроса: //auto Команда = gcnew OleDbCommand( //"INSERT INTO [Talabalar] (Fam, Ism, Sharf, Guruh, Bosqich,Tugilgan_viloyati, Pasport_seriasi,"+ //"Tugilgan_Sana, Pasport_nomeri, Xona_nomeri, Blok_nomi, Qavat_nomeri, Lavozim, Telefoni, Tugilgan_yili,"+ //"Tugilgan_oyi, Tugilgan_kuni, Jinsi, Fakulteti, Yonalishi, Tugilgan_tumani, Yashash_manzili, Rasm) VALUES ('" // +textBox1->Text+"', '"+textBox2->Text+"', '"+textBox3->Text+"', '"+textBox4->Text+"', '"+textBox17->Text+ //"', '"+textBox9->Text+"', '"+textBox10->Text+"', '"+textBox11->Text+"', '"+textBox13->Text+ //"', '"+textBox5->Text+"', '"+textBox6->Text+"', '"+textBox7->Text+"', '"+textBox24->Text+ //"', '"+textBox8->Text+"', '"+textBox14->Text+"', '"+textBox15->Text+"', '"+textBox16->Text+ //"', '"+textBox23->Text+"', '"+textBox20->Text+"', '"+textBox21->Text+"', '"+textBox22->Text+ //"', '"+textBox12->Text+"', '"+SaveRasm()+"')"); // //// Для добавления записи в таблицу БД эта команда обязательна: ////Adapter->InsertCommand = Команда; //Команда->Connection = Подключение; //// Выполнение команды SQL: //Команда->ExecuteNonQuery(); //MessageBox::Show("Talabalr jadvaliga yangi ma'lumotlar yozildi"); //Команда->CommandText = "UPDATE Talabalar SET Rasm = @Rasm WHERE id = @Id"; // Команда->Parameters->AddWithValue("@Rasm",SaveRasm()); // Команда->Parameters->AddWithValue("@Id",Id); // //Команда->ExecuteNonQuery(); //Подключение->Close(); TTJ_3 = gcnew TTJ_sinf(); bool s; TTJ_3->ShowRecord(dataGridView1,"Select * From Talabalar"); delete TTJ_3; /* int rowToUpdate = Convert::ToInt32(dataGridView1->RowCount); MessageBox::Show( (rowToUpdate-1).ToString()); int id = Convert::ToInt32(dataGridView1->Rows[rowToUpdate-1]->Cells["id"]->Value); OleDbConnection^ con2 = gcnew OleDbConnection("Data Source=\"TTJ.mdb\";User " + "ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";"); con2->Open(); Команда = gcnew OleDb::OleDbCommand("Select * From [Talabalar]", con2); Команда->CommandText = "UPDATE Talabalar SET Rasm = @Rasm WHERE id = @id"; Команда->Parameters->AddWithValue("@Rasm",SaveRasm()); Команда->Parameters->AddWithValue("@id",id); Команда->ExecuteNonQuery(); MessageBox::Show("Talabalar jadvalining ma'lumotlari muaafaqiyatli yangilandi!!!!!!!!!!!!!!!"); */ //Application::Restart(); } void nol(){ textBox1->Text = " "; textBox2->Text = " "; textBox3->Text = " "; //textBox4->Text = "218-17"; //textBox5->Text = "207"; //textBox6->Text = "A,B,C"; //textBox7->Text = "2"; textBox8->Text = " "; textBox9->Text = " "; textBox10->Text = " "; //textBox11->Text = " "; textBox12->Text = " "; textBox13->Text = " "; textBox14->Text = " "; textBox15->Text = " "; //textBox16->Text = " "; textBox17->Text = " "; textBox20->Text = " "; textBox21->Text = " "; textBox22->Text = " "; textBox23->Text = " "; textBox24->Text = " "; } private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e) { //Saqlash(); TTJ_3 = gcnew TTJ_sinf(); bool s; TTJ_3->ShowRecord(dataGridView1,"Select count (*) as soni From Talabalar Where Blok_nomi ='"+ textBox6->Text+"' AND Xona_nomeri ="+textBox5->Text); delete TTJ_3; int id = Convert::ToInt32(dataGridView1->Rows[0]->Cells["soni"]->Value); if(id<=2){ auto MBox = MessageBox::Show("3 - talabani qo'shasizmi? ", "3 talik xonami", MessageBoxButtons::YesNoCancel, MessageBoxIcon::Exclamation); // YES — диалог; NO — выход; CANCEL - редактировать if (MBox == Windows::Forms::DialogResult::No) return; //if (MBox == Windows::Forms::DialogResult::Cancel){ this->Close();} if (MBox == Windows::Forms::DialogResult::Yes){ Saqlash();} } else {MessageBox::Show("3 tadan ortiq talaba qo'shish mumkin emas");} //int row_count =dataGridView1->Rows->GetR // label18->Text ="soni= "+ (id).ToString(); } private: System::Void Studentlarni_yangilash_Load(System::Object^ sender, System::EventArgs^ e) { nol(); //textBox11->Text = " "; } private: System::Void textBox11_TextChanged(System::Object^ sender, System::EventArgs^ e) { try{textBox16->Text = textBox11->Text->Substring(0,2); textBox15->Text = textBox11->Text->Substring(3,2); textBox14->Text = textBox11->Text->Substring(6,4); } catch(Exception^ vaz){} } private: System::Void textBox5_TextChanged(System::Object^ sender, System::EventArgs^ e) { try{ textBox7->Text = textBox5->Text->Substring(0,1);//Convert::ToString(textBox5->Text[0]); } catch(Exception^ vaz){} }
int id; if(textBox6->Text=="A"){ textBox6->Text="A"; goto bir; } if(textBox6->Text=="B"){ textBox6->Text="B"; goto bir; } if(textBox6->Text=="V"){ textBox6->Text="V"; } else textBox6->Text=""; bir: id=2; } private: System::Void textBox4_TextChanged(System::Object^ sender, System::EventArgs^ e) { DateTime^ dd= DateTime::Now; String^ yil= Convert::ToString(dd); //label18->Text = yil->Substring(8,2); try{ //MessageBox::Show(textBox4->Text->Substring(4,2)); int a=Convert::ToInt32(textBox4->Text->Substring(4,2)); int b=Convert::ToInt32(yil->Substring(8,2)); if(a==b){textBox17->Text="1";} if(a+1==b){textBox17->Text="2";} if(a+2==b){textBox17->Text="3";} if(a+3==b){textBox17->Text="4";} } catch(Exception^ v){} } private: System::Void Studentlarni_yangilash_FormClosed(System::Object^ sender, System::Windows::Forms::FormClosedEventArgs^ e) { safe_cast //this->Close(); //} } }; } Yüklə 1,31 Mb. Dostları ilə paylaş:
|