Using CommandBuilder : OleDbCommandBuilder « Database ADO.net « Visual C++ .NET

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

Using CommandBuilder

 
#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=Music.mdb");
    myConnection->Open();
    OleDbDataAdapter^ dataAdapter = gcnew OleDbDataAdapter("SELECT * FROM Music", myConnection);
    OleDbCommandBuilder^ commandBuilder = gcnew OleDbCommandBuilder(dataAdapter);
    dataAdapter->UpdateCommand = commandBuilder->GetUpdateCommand();
    dataAdapter->DeleteCommand = commandBuilder->GetDeleteCommand();
    dataAdapter->InsertCommand = commandBuilder->GetInsertCommand();
    DataSet^ myDataSet = gcnew DataSet();
    dataAdapter->MissingSchemaAction = MissingSchemaAction::AddWithKey;
    dataAdapter->Fill(myDataSet);
    DataTable^ myTable = myDataSet->Tables[0];
    DataRow^ row = myTable->Rows->Find("Consequential2");
    if ( row != nullptr )
        row->Delete();
    row = myTable->Rows->Find("S");
    if ( row != nullptr )
        row["Title"] = "S";
    row = myTable->NewRow();
    row["Title"] = "TT";
    row["GenreName"] = "Classical";
    row["Duration"] = "4:20";
    myTable->Rows->Add(row);
    dataAdapter->Update(myDataSet);
    myConnection->Close();
}

   
  

Related examples in the same category