form1.h

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

			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"Math", S"Math");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"Literary", S"Literary");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"Total", S"Total");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"Expr1004", S"Expr1004");
			__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"grade", __mcTemp__2);
			this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
			this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
			// 
			// button2
			// 
			this->button2->Location = System::Drawing::Point(224, 192);
			this->button2->Name = S"button2";
			this->button2->Size = System::Drawing::Size(96, 23);
			this->button2->TabIndex = 3;
			this->button2->Text = S"保存到XML文件";
			this->button2->Click += new System::EventHandler(this, button2_Click);
			// 
			// button1
			// 
			this->button1->Location = System::Drawing::Point(88, 192);
			this->button1->Name = S"button1";
			this->button1->Size = System::Drawing::Size(80, 23);
			this->button1->TabIndex = 4;
			this->button1->Text = S"加载数据";
			this->button1->Click += new System::EventHandler(this, button1_Click);
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT Name, Math, Literary, Total, NO FROM grade";
			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO grade(Name, Math, Literary, Total, NO) VALUES (\?, \?, \?, \?, \?)";
			this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Name", System::Data::OleDb::OleDbType::VarWChar, 50, S"Name"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Math", System::Data::OleDb::OleDbType::Single, 0, S"Math"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Literary", System::Data::OleDb::OleDbType::Single, 0, S"Literary"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Total", System::Data::OleDb::OleDbType::Single, 0, S"Total"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NO", System::Data::OleDb::OleDbType::Integer, 0, S"NO"));
			// 
			// oleDbUpdateCommand1
			// 
			this->oleDbUpdateCommand1->CommandText = S"UPDATE grade SET Name = \?, Math = \?, Literary = \?, Total = \?, NO = \? 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"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"NO", System::Data::OleDb::OleDbType::Integer, 0, S"NO"));
			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));
			// 
			// oleDbDeleteCommand1
			// 
			this->oleDbDeleteCommand1->CommandText = S"DELETE FROM grade WHERE (NO = \?) AND (Literary = \? OR \? IS NULL AND Literary IS N" 
				S"ULL) AND (Math = \? OR \? IS NULL AND Math IS NULL) AND (Name = \? OR \? IS NULL AND" 
				S" Name IS NULL) AND (Total = \? OR \? IS NULL AND Total IS NULL)";
			this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
			this->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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->oleDbDeleteCommand1->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));
			// 
			// oleDbConnection1
			// 
			this->oleDbConnection1->ConnectionString = S"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" 
				S"ocking Mode=1;Data Source=\"testdb.mdb\";Jet OLEDB:Engine Type=5;Provider=\"Microso" 
				S"ft.Jet.OLEDB.4.0\";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist securit" 
				S"y info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Databas" 
				S"e=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don\'t Copy Locale on Co" 
				S"mpact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLE" 
				S"DB:Global Bulk Transactions=1";
			// 
			// dataSet11
			// 
			this->dataSet11->DataSetName = S"DataSet1";
			this->dataSet11->Locale = new System::Globalization::CultureInfo(S"zh-CN");
			// 
			// Form1
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(384, 230);
			this->Controls->Add(this->button1);
			this->Controls->Add(this->button2);
			this->Controls->Add(this->dataGrid1);
			this->FormBorderStyle = System::Windows::Forms::FormBorderStyle::FixedSingle;
			this->MaximizeBox = false;
			this->Name = S"Form1";
			this->Text = S"XML文件";
			this->Load += new System::EventHandler(this, Form1_Load);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->EndInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataView1))->EndInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataSet11))->EndInit();
			this->ResumeLayout(false);

		}	
	private: System::Void Form1_Load(System::Object *  sender, System::EventArgs *  e)
			 {
				 button2->Enabled =false;
				 
			 }
private: System::Void button1_Click(System::Object *  sender, System::EventArgs *  e)
		 {
			 oleDbDataAdapter1->Fill(dataSet11);
			 button2->Enabled =true;
		 }
private: System::Void button2_Click(System::Object *  sender, System::EventArgs *  e)
		 {			
			 dataSet11->WriteXml("C:\\myXml.xml");
			 MessageBox::Show("保存到C:\\myXml.xml 成功！", "保存成功");
		 }



};
}