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

Home
Visual C++ .NET
1.2D
2.Class
3.Collections
4.Data Type
5.Database ADO.net
6.Delegate
7.Development
8.File Directory
9.Function
10.Generics
11.GUI Form
12.Language Basics
13.Network
14.Reflection
15.Security
16.Statement
17.Structure
18.Thread
19.XML
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Visual C++ .NET » Database ADO.net » 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
1.Convert data table from database to xml
2.Create XmlDataDocument from DataSet
3.Add tables to DataSet
4.Create DataSet
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.