using namespace System::Data::OleDb;

 

 

       /// <summary>

       /// Summary for Form1

       ///

       /// WARNING: If you change the name of this class, you will need to change the

       ///          'Resource File Name' property for the managed resource compiler tool

       ///          associated with all .resx files this class depends on.  Otherwise,

       ///          the designers will not be able to interact properly with localized

       ///          resources associated with this form.

       /// </summary>

       public ref class Form1 : public System::Windows::Forms::Form

       {

       public:

              Form1(void)

              {

                     InitializeComponent();

                     //

                     //TODO: Add the constructor code here

                     //

              }

 

       protected:

              /// <summary>

              /// Clean up any resources being used.

              /// </summary>

              ~Form1()

              {

                     if (components)

                     {

                            delete components;

                     }

              }

       private: System::Windows::Forms::DataGridView^  dataGridView1;

       protected:

 

       private:

              /// <summary>

              /// Required designer variable.

              /// </summary>

              System::ComponentModel::Container ^components;

 

#pragma region Windows Form Designer generated code

              /// <summary>

              /// Required method for Designer support - do not modify

              /// the contents of this method with the code editor.

              /// </summary>

              void InitializeComponent(void)

              {

                     this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());

                     (cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->dataGridView1))->BeginInit();

                     (cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->dataSet1))->BeginInit();

                     this->SuspendLayout();

                     //

                     // dataGridView1

                     //

                     this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;

                     this->dataGridView1->Location = System::Drawing::Point(12, 12);

                     this->dataGridView1->Name = L"dataGridView1";

                     this->dataGridView1->Size = System::Drawing::Size(268, 198);

                     this->dataGridView1->TabIndex = 0;

 

                     //

                     // Form1

                     //

                     this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);

                     this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;

                     this->ClientSize = System::Drawing::Size(362, 322);

                     this->Controls->Add(this->dataGridView1);

                     this->Name = L"Form1";

                     this->Text = L"Form1";

                     this->Load += gcnew System::EventHandler(this, &Form1::Form1_Load);

                     (cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->dataGridView1))->EndInit();

                     (cli::safe_cast<System::ComponentModel::ISupportInitialize^  >(this->dataSet1))->EndInit();

                     this->ResumeLayout(false);

 

              }

#pragma endregion

       private: System::Void Form1_Load(System::Object^  sender, System::EventArgs^  e)

                      {   

                             System::Data::DataSet^ ds = gcnew System::Data::DataSet();

 

                            OleDbConnection^ conn = gcnew OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\\Database1.accdb;Persist Security Info=True");

                           

                            OleDbCommand^ com = gcnew OleDbCommand();

                            com->Connection = conn;

                            com->CommandText = "select * from table1";

                           

                            OleDbDataAdapter^ adapt = gcnew OleDbDataAdapter();

 

                            adapt->SelectCommand = com;

 

                            adapt->Fill(ds, "dt1");

 

                            dataGridView1->DataSource = ds->Tables["dt1"];

 

                      }

       };