form1.h

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

#pragma once


namespace sort
{
	using namespace System;
	using namespace System::ComponentModel;
	using namespace System::Collections;
	using namespace System::Windows::Forms;
	using namespace System::Data;
	using namespace System::Drawing;

	/// <summary> 
	/// Form1 摘要
	///
	/// 警告: 如果您更改该类的名称，则需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class Form1 : public System::Windows::Forms::Form
	{	
	public:
		Form1(void)
		{
			InitializeComponent();
		}
  
	protected:
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}
	private: System::Data::OleDb::OleDbDataAdapter *  oleDbDataAdapter1;
	private: System::Data::OleDb::OleDbCommand *  oleDbSelectCommand1;
	private: System::Data::OleDb::OleDbCommand *  oleDbInsertCommand1;
	private: System::Data::OleDb::OleDbCommand *  oleDbUpdateCommand1;
	private: System::Data::OleDb::OleDbCommand *  oleDbDeleteCommand1;
	private: System::Data::OleDb::OleDbConnection *  oleDbConnection1;
	private: sort::DataSet1 *  dataSet11;
	private: System::Data::DataView *  dataView1;
	private: System::Windows::Forms::Button *  button1;
	private: System::Windows::Forms::ComboBox *  comboBox1;
	private: System::Windows::Forms::DataGrid *  dataGrid1;

	private:
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		System::ComponentModel::Container * components;

		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->oleDbDataAdapter1 = new System::Data::OleDb::OleDbDataAdapter();
			this->oleDbDeleteCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbConnection1 = new System::Data::OleDb::OleDbConnection();
			this->oleDbInsertCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbSelectCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbUpdateCommand1 = new System::Data::OleDb::OleDbCommand();
			this->dataSet11 = new sort::DataSet1();
			this->dataView1 = new System::Data::DataView();
			this->button1 = new System::Windows::Forms::Button();
			this->comboBox1 = new System::Windows::Forms::ComboBox();
			this->dataGrid1 = new System::Windows::Forms::DataGrid();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataSet11))->BeginInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataView1))->BeginInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->BeginInit();
			this->SuspendLayout();
			// 
			// oleDbDataAdapter1
			// 
			this->oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;
			this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
			this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
			System::Data::Common::DataTableMapping* __mcTemp__1[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__2[] = new System::Data::Common::DataColumnMapping*[5];
			__mcTemp__2[0] = new System::Data::Common::DataColumnMapping(S"Name", S"Name");
			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"Expr1001", S"Expr1001");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"Math", S"Math");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"Literary", S"Literary");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"Total", S"Total");
			__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;
			// 
			// 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";
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO grade(Name, NO, Math, Literary, Total) 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"NO", System::Data::OleDb::OleDbType::Integer, 0, S"NO"));
			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"));
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT Name, NO, Math, Literary, Total FROM grade";