form1.h

《VC++2005编程实例》第二章的源代码

#pragma once


namespace Example {

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

	using namespace System::Data::OleDb;
	/// <summary>
	/// Form1 摘要
	///
	/// 警告: 如果更改此类的名称，则需要更改
	///          与此类所依赖的所有 .resx 文件关联的托管资源编译器工具的
	///          “资源文件名”属性。否则，
	///          设计器将不能与此窗体的关联
	///          本地化资源正确交互。
	/// </summary>
	public ref class Form1 : public System::Windows::Forms::Form
	{
	public:
		Form1(void)
		{
			InitializeComponent();
			//
			//TODO: 在此处添加构造函数代码
			//
		}

	protected:
		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		~Form1()
		{
			if (components)
			{
				delete components;
			}
		}
	private: System::Windows::Forms::Label^  label1;
	protected: 
	private: System::Windows::Forms::TextBox^  textBox1;
	private: System::Windows::Forms::TextBox^  textBox2;
	private: System::Windows::Forms::Label^  label2;
	private: System::Windows::Forms::Button^  button1;
	private: System::Windows::Forms::Button^  button2;
	private: System::Windows::Forms::DataGridView^  dataGridView1;

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

#pragma region Windows Form Designer generated code
		/// <summary>
		/// 设计器支持所需的方法 - 不要
		/// 使用代码编辑器修改此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->label1 = (gcnew System::Windows::Forms::Label());
			this->textBox1 = (gcnew System::Windows::Forms::TextBox());
			this->textBox2 = (gcnew System::Windows::Forms::TextBox());
			this->label2 = (gcnew System::Windows::Forms::Label());
			this->button1 = (gcnew System::Windows::Forms::Button());
			this->button2 = (gcnew System::Windows::Forms::Button());
			this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->dataGridView1))->BeginInit();
			this->SuspendLayout();
			// 
			// label1
			// 
			this->label1->AutoSize = true;
			this->label1->Location = System::Drawing::Point(13, 16);
			this->label1->Name = L"label1";
			this->label1->Size = System::Drawing::Size(59, 12);
			this->label1->TabIndex = 0;
			this->label1->Text = L"SQL语句：";
			// 
			// textBox1
			// 
			this->textBox1->Location = System::Drawing::Point(79, 10);
			this->textBox1->Name = L"textBox1";
			this->textBox1->Size = System::Drawing::Size(299, 21);
			this->textBox1->TabIndex = 1;
			this->textBox1->Text = L"SELECT * FROM 订单";
			// 
			// textBox2
			// 
			this->textBox2->Location = System::Drawing::Point(79, 37);
			this->textBox2->Name = L"textBox2";
			this->textBox2->Size = System::Drawing::Size(105, 21);
			this->textBox2->TabIndex = 3;
			// 
			// label2
			// 
			this->label2->AutoSize = true;
			this->label2->Location = System::Drawing::Point(13, 43);
			this->label2->Name = L"label2";
			this->label2->Size = System::Drawing::Size(65, 12);
			this->label2->TabIndex = 2;
			this->label2->Text = L"耗费时间：";
			// 
			// button1
			// 
			this->button1->Location = System::Drawing::Point(190, 35);
			this->button1->Name = L"button1";
			this->button1->Size = System::Drawing::Size(91, 23);
			this->button1->TabIndex = 4;
			this->button1->Text = L"执行查询(1)";
			this->button1->UseVisualStyleBackColor = true;
			this->button1->Click += gcnew System::EventHandler(this, &Form1::button1_Click);
			// 
			// button2
			// 
			this->button2->Location = System::Drawing::Point(287, 35);
			this->button2->Name = L"button2";
			this->button2->Size = System::Drawing::Size(91, 23);
			this->button2->TabIndex = 5;
			this->button2->Text = L"执行查询(2)";
			this->button2->UseVisualStyleBackColor = true;
			this->button2->Click += gcnew System::EventHandler(this, &Form1::button2_Click);
			// 
			// dataGridView1
			// 
			this->dataGridView1->Anchor = static_cast<System::Windows::Forms::AnchorStyles>((((System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Bottom) 
				| System::Windows::Forms::AnchorStyles::Left) 
				| System::Windows::Forms::AnchorStyles::Right));
			this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
			this->dataGridView1->Location = System::Drawing::Point(13, 68);
			this->dataGridView1->Name = L"dataGridView1";
			this->dataGridView1->RowTemplate->Height = 23;
			this->dataGridView1->Size = System::Drawing::Size(365, 134);
			this->dataGridView1->TabIndex = 6;
			// 
			// Form1
			// 
			this->AutoScaleDimensions = System::Drawing::SizeF(6, 12);
			this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
			this->ClientSize = System::Drawing::Size(390, 214);
			this->Controls->Add(this->dataGridView1);
			this->Controls->Add(this->button2);
			this->Controls->Add(this->button1);
			this->Controls->Add(this->textBox2);
			this->Controls->Add(this->label2);
			this->Controls->Add(this->textBox1);
			this->Controls->Add(this->label1);
			this->Name = L"Form1";
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;
			this->Text = L"演示使用Stopwatch实现高精度计时";
			(cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->dataGridView1))->EndInit();
			this->ResumeLayout(false);
			this->PerformLayout();

		}
#pragma endregion
	//执行查询(1)
	private: System::Void button1_Click(System::Object^  sender, System::EventArgs^  e) {
		   System::Diagnostics::Stopwatch^ MyWatch = gcnew System::Diagnostics::Stopwatch();
		   MyWatch->Start();
		   try
		   {
			   OleDbConnection^ MyConnection = gcnew OleDbConnection("Provider= Microsoft.Jet.OLEDB.4.0;Data Source="+Application::StartupPath+"\\Northwind.mdb");
			 OleDbCommand^ MyCommand = gcnew OleDbCommand(this->textBox1->Text, MyConnection);
			 MyConnection->Open();
			 OleDbDataReader^ MyReader = MyCommand->ExecuteReader();
			 DataTable^ MyTable = gcnew DataTable();
			 MyTable->Load(MyReader);
			 this->dataGridView1->DataSource = MyTable;
			 MyConnection->Close();
		   }
		   catch(Exception^ MyEx)
		   {
			   MessageBox::Show(MyEx->Message, "信息提示", MessageBoxButtons::OK, MessageBoxIcon::Information);
			}
			MyWatch->Stop();
			this->textBox2->Text = MyWatch->ElapsedMilliseconds.ToString()+"毫秒";            
	 }
    //执行查询(2)
private: System::Void button2_Click(System::Object^  sender, System::EventArgs^  e) {
	  System::Diagnostics::Stopwatch^ MyWatch = gcnew System::Diagnostics::Stopwatch();
	  MyWatch->Start();
	  try
	  {
		DataSet^ MySet = gcnew DataSet();
		OleDbConnection^ MyConnection = gcnew OleDbConnection("Provider= Microsoft.Jet.OLEDB.4.0;Data Source="+Application::StartupPath+"\\Northwind.mdb");
		OleDbCommand^ MyCommand = gcnew OleDbCommand(this->textBox1->Text, MyConnection);
		MyConnection->Open();
		OleDbDataAdapter^ MyAdapter = gcnew OleDbDataAdapter(MyCommand);
		MyAdapter->Fill(MySet);
		this->dataGridView1->DataSource =MySet->Tables[0];
		MyConnection->Close();
	 }
     catch (Exception^ MyEx)
     {
		 MessageBox::Show(MyEx->Message, "信息提示", MessageBoxButtons::OK, MessageBoxIcon::Information);
     }
     MyWatch->Stop();
	 this->textBox2->Text = MyWatch->ElapsedMilliseconds.ToString() + "毫秒";
 }
};
}