#pragma once

namespace DataGridThread
{
    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::Threading;
    using namespace System::Data::SqlClient;

    /// <summary> 
    /// Summary for Form1
    /// </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::Windows::Forms::Button *  button1;
private: System::Windows::Forms::Button *  button2;
private: System::Windows::Forms::Label *  label1;
private: System::Windows::Forms::TextBox *  textBox1;
private: System::Windows::Forms::DataGrid *  dataGrid1;

private:
    /// <summary>
    /// Required designer variable.
    /// </summary>
    System::ComponentModel::Container * components;

    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    void InitializeComponent(void)
    {
        this->button1 = new System::Windows::Forms::Button();
        this->button2 = new System::Windows::Forms::Button();
        this->label1 = new System::Windows::Forms::Label();
        this->textBox1 = new System::Windows::Forms::TextBox();
        this->dataGrid1 = new System::Windows::Forms::DataGrid();
        (__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->BeginInit();
        this->SuspendLayout();
        // 
        // button1
        // 
        this->button1->Location = System::Drawing::Point(180, 16);
        this->button1->Name = S"button1";
        this->button1->Size = System::Drawing::Size(104, 23);
        this->button1->TabIndex = 0;
        this->button1->Text = S"Query on Thread";
        this->button1->Click += new System::EventHandler(this, button1_Click);
        // 
        // button2
        // 
        this->button2->Location = System::Drawing::Point(316, 16);
        this->button2->Name = S"button2";
        this->button2->Size = System::Drawing::Size(104, 23);
        this->button2->TabIndex = 1;
        this->button2->Text = S"Query on Form";
        this->button2->Click += new System::EventHandler(this, button2_Click);
        // 
        // label1
        // 
        this->label1->Location = System::Drawing::Point(24, 48);
        this->label1->Name = S"label1";
        this->label1->Size = System::Drawing::Size(496, 23);
        this->label1->TabIndex = 2;
        // 
        // textBox1
        // 
        this->textBox1->Location = System::Drawing::Point(24, 80);
        this->textBox1->Name = S"textBox1";
        this->textBox1->TabIndex = 3;
        this->textBox1->Text = S"textBox1";
        // 
        // dataGrid1
        // 
        this->dataGrid1->DataMember = S"";
        this->dataGrid1->HeaderForeColor = System::Drawing::SystemColors::ControlText;
        this->dataGrid1->Location = System::Drawing::Point(8, 112);
        this->dataGrid1->Name = S"dataGrid1";
        this->dataGrid1->Size = System::Drawing::Size(584, 296);
        this->dataGrid1->TabIndex = 4;
        // 
        // Form1
        // 
        this->AutoScaleBaseSize = System::Drawing::Size(5, 13);
        this->ClientSize = System::Drawing::Size(600, 421);
        this->Controls->Add(this->dataGrid1);
        this->Controls->Add(this->textBox1);
        this->Controls->Add(this->label1);
        this->Controls->Add(this->button2);
        this->Controls->Add(this->button1);
        this->Name = S"Form1";
        this->Text = S"Form1";
        (__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->EndInit();
        this->ResumeLayout(false);
        MyForm = this;

    }
    static Form1 * MyForm; 

    Thread  * UpdateThread;
    static ThreadStart * UpdateThreadStart = new ThreadStart(0,&Form1::QueryDataBase);
    static MethodInvoker  * CallDataBindToDataGrid = new MethodInvoker(0,&Form1::DataBindToDataGrid);
    static DataSet * MyDataSet;
    static SqlDataAdapter * MyDataAdapter;
    static String * MyQueryString = S"SELECT [Order Details].*, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate FROM [Order Details] CROSS JOIN Orders";
    static SqlConnection * MyConnection = new SqlConnection("data source=localhost;initial catalog=Northwind;integrated security=SSPI;");

private: System::Void button1_Click(System::Object *  sender, System::EventArgs *  e)
         {
             UpdateThread = new Thread(UpdateThreadStart);
             UpdateThread->Name = S"Update Thread";
             UpdateThread->IsBackground = true;
             UpdateThread->Start();
         }
private: System::Void button2_Click(System::Object *  sender, System::EventArgs *  e)
         {
             QueryDataBase();
         }
         // Subroutine that is to be run on the form's thread.
         static void DataBindToDataGrid()
         {
             MyForm->dataGrid1->DataSource = MyDataSet;
             MyForm->dataGrid1->DataMember = S"MyTable";
             MyDataSet = NULL;
             MyDataAdapter = NULL;
         }

         // Subroutine that is used by the background thread to query the database.
         static void QueryDataBase()
         {
             MyDataSet = new DataSet();
             MyConnection->Open();
             MyDataAdapter = new SqlDataAdapter(MyQueryString, MyConnection);       
             MyForm->label1->Text = S"Filling the DataSet";
             MyDataAdapter->Fill(MyDataSet, S"MyTable");
             MyConnection->Close();
             MyForm->label1->Text = S"DataSet Filled";
             MyForm->BeginInvoke(CallDataBindToDataGrid);   
         }
    };
}

#include "stdafx.h"
#include "Form1.h"
#include <windows.h>

using namespace DataGridThread;

int APIENTRY _tWinMain(HINSTANCE hInstance,
                     HINSTANCE hPrevInstance,
                     LPTSTR    lpCmdLine,
                     int       nCmdShow)
{
    Form1 * MyForm;
    MyForm = new Form1();
    Application::Run(MyForm);
}