Mega Code Archive

 

Categories / Visual C++ .NET / ADO Database

 

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(); }