Load DataSet : DataSet « Database ADO.net « Visual C++ .NET

1. Visual C++ .NET
2. Database ADO.net
3. DataSet

Load DataSet

 
#include "stdafx.h"
using namespace System;
using namespace System::Data;
using namespace System::Data::OleDb;

void main()
{
        OleDbConnection^ myConnection = nullptr;
        myConnection = gcnew OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=UltraMax-Music.mdb");
        myConnection->Open();
        
        OleDbCommand^ myCommand = gcnew OleDbCommand("SELECT * FROM Music",myConnection);
        
        OleDbDataReader^ myReader = myCommand->ExecuteReader();

        DataSet^ myDataSet = gcnew DataSet();
        array<String^>^ tables = {"Music"};
        myDataSet->Load(myReader, LoadOption::OverwriteChanges, tables);
        
        Console::WriteLine("{0} rows loaded",myDataSet->Tables[0]->Rows->Count);
        myConnection->Close();
}

   
  

Related examples in the same category