form1.h

来自「Visual_C++.NET实用编程百例」· C头文件 代码 · 共 265 行 · 第 1/2 页

			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// oleDbUpdateCommand1
			// 
			this->oleDbUpdateCommand1->CommandText = S"UPDATE grade SET Name = \?, NO = \?, Math = \?, Literary = \?, Total = \? WHERE (NO = " 
				S"\?) AND (Literary = \? OR \? IS NULL AND Literary IS NULL) AND (Math = \? OR \? IS NU" 
				S"LL AND Math IS NULL) AND (Name = \? OR \? IS NULL AND Name IS NULL) AND (Total = \?" 
				S" OR \? IS NULL AND Total IS NULL)";
			this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Name", System::Data::OleDb::OleDbType::VarWChar, 50, S"Name"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NO", System::Data::OleDb::OleDbType::Integer, 0, S"NO"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Math", System::Data::OleDb::OleDbType::Single, 0, S"Math"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Literary", System::Data::OleDb::OleDbType::Single, 0, S"Literary"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Total", System::Data::OleDb::OleDbType::Single, 0, S"Total"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NO", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NO", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Literary", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Literary", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Literary1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Literary", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Math", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Math", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Math1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Math", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Name", System::Data::OleDb::OleDbType::VarWChar, 50, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Name", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Name1", System::Data::OleDb::OleDbType::VarWChar, 50, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Name", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Total", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Total", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Total1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Total", System::Data::DataRowVersion::Original, 0));
			// 
			// dataSet11
			// 
			this->dataSet11->DataSetName = S"DataSet1";
			this->dataSet11->Locale = new System::Globalization::CultureInfo(S"zh-CN");
			// 
			// dataView1
			// 
			this->dataView1->Table = this->dataSet11->grade;
			// 
			// button1
			// 
			this->button1->Location = System::Drawing::Point(240, 248);
			this->button1->Name = S"button1";
			this->button1->TabIndex = 0;
			this->button1->Text = S"排序";
			this->button1->Click += new System::EventHandler(this, button1_Click);
			// 
			// comboBox1
			// 
			System::Object* __mcTemp__3[] = new System::Object*[4];
			__mcTemp__3[0] = S"姓名";
			__mcTemp__3[1] = S"数学";
			__mcTemp__3[2] = S"文学";
			__mcTemp__3[3] = S"总分";
			this->comboBox1->Items->AddRange(__mcTemp__3);
			this->comboBox1->Location = System::Drawing::Point(64, 248);
			this->comboBox1->Name = S"comboBox1";
			this->comboBox1->Size = System::Drawing::Size(121, 20);
			this->comboBox1->TabIndex = 1;
			this->comboBox1->Text = S"选择排序方式";
			// 
			// dataGrid1
			// 
			this->dataGrid1->AlternatingBackColor = System::Drawing::Color::GhostWhite;
			this->dataGrid1->BackColor = System::Drawing::Color::GhostWhite;
			this->dataGrid1->BackgroundColor = System::Drawing::Color::Lavender;
			this->dataGrid1->BorderStyle = System::Windows::Forms::BorderStyle::None;
			this->dataGrid1->CaptionBackColor = System::Drawing::Color::RoyalBlue;
			this->dataGrid1->CaptionForeColor = System::Drawing::Color::White;
			this->dataGrid1->DataMember = S"";
			this->dataGrid1->DataSource = this->dataView1;
			this->dataGrid1->FlatMode = true;
			this->dataGrid1->Font = new System::Drawing::Font(S"Tahoma", 8);
			this->dataGrid1->ForeColor = System::Drawing::Color::MidnightBlue;
			this->dataGrid1->GridLineColor = System::Drawing::Color::RoyalBlue;
			this->dataGrid1->HeaderBackColor = System::Drawing::Color::MidnightBlue;
			this->dataGrid1->HeaderFont = new System::Drawing::Font(S"Tahoma", 8, System::Drawing::FontStyle::Bold);
			this->dataGrid1->HeaderForeColor = System::Drawing::Color::Lavender;
			this->dataGrid1->LinkColor = System::Drawing::Color::Teal;
			this->dataGrid1->Location = System::Drawing::Point(8, 16);
			this->dataGrid1->Name = S"dataGrid1";
			this->dataGrid1->ParentRowsBackColor = System::Drawing::Color::Lavender;
			this->dataGrid1->ParentRowsForeColor = System::Drawing::Color::MidnightBlue;
			this->dataGrid1->SelectionBackColor = System::Drawing::Color::Teal;
			this->dataGrid1->SelectionForeColor = System::Drawing::Color::PaleGreen;
			this->dataGrid1->Size = System::Drawing::Size(344, 200);
			this->dataGrid1->TabIndex = 2;
			// 
			// Form1
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(362, 280);
			this->Controls->Add(this->dataGrid1);
			this->Controls->Add(this->comboBox1);
			this->Controls->Add(this->button1);
			this->FormBorderStyle = System::Windows::Forms::FormBorderStyle::FixedSingle;
			this->MaximizeBox = false;
			this->Name = S"Form1";
			this->Text = S"排序";
			this->Load += new System::EventHandler(this, Form1_Load);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataSet11))->EndInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataView1))->EndInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->EndInit();
			this->ResumeLayout(false);

		}	
	private: System::Void Form1_Load(System::Object *  sender, System::EventArgs *  e)
			 {
				  oleDbDataAdapter1->Fill(dataSet11);
			 }

private: System::Void button1_Click(System::Object *  sender, System::EventArgs *  e)
		 {
			 switch(comboBox1->SelectedIndex)
			 {
			 case 0:
				 dataView1->Sort ="Name";
				 break;
			 case 1:
				 dataView1->Sort ="Math";
				 break;
			 case 2:
				 dataView1->Sort ="Literary";
				 break;
			 case 3:
				 dataView1->Sort ="Total";
				 break;
			 default:
				 break;
			 }
			 oleDbDataAdapter1->Update (dataSet11);
		 }

};
}