в 15:31, 26 мая 2010

2010-05-26T15:31:02Z

Admin: 1 версия

2010-05-26T12:06:22Z

1 версия

Новая страница

==Add tables to DataSet==

<source lang="csharp">
#include "stdafx.h"
using namespace System;
using namespace System::Data;
void main()
{
DataSet^ myDataSet = gcnew DataSet("Game Data");
myDataSet->Tables->Add("Player");
myDataSet->Tables->Add("Score");
DataTable^ playerTable = myDataSet->Tables["Player"];
DataColumn^ firstNameColumn1 = playerTable->Columns->Add("First Name",String::typeid);
DataColumn^ lastNameColumn1 = playerTable->Columns->Add("Last Name",String::typeid);
playerTable->Columns->Add("Email", String::typeid);
}

</source>

==Convert data table from database to xml==

<source lang="csharp">
#include "stdafx.h"
using namespace System;
using namespace System::Configuration;
using namespace System::Data;
using namespace System::Data::SqlClient;
using namespace System::Xml;
void Navigate(XmlNode ^node, int depth)
{
if (node == nullptr)
return;
Console::WriteLine(depth);
Console::WriteLine(node->NodeType.ToString());
Console::WriteLine(node->Name);
Console::WriteLine(node->Value);
if (node->Attributes != nullptr)
{
for (int i = 0; i < node->Attributes->Count; i++)
{
Console::WriteLine(node->Attributes[i]->Name);
Console::WriteLine(node->Attributes[i]->Value);
}
}
Navigate(node->FirstChild, depth+1);
Navigate(node->NextSibling, depth);
}
void main(){
XmlDocument ^doc = gcnew XmlDocument();
SqlConnection ^connect = gcnew SqlConnection();

connect->ConnectionString = "SQLConnection";
SqlDataAdapter ^dAdapt = gcnew SqlDataAdapter();
DataSet ^dSet = gcnew DataSet();
dAdapt->SelectCommand = gcnew SqlCommand("SELECT * FROM Authors", connect);

dAdapt->Fill(dSet, "Authors");
XmlDataDocument ^doc1 = gcnew XmlDataDocument(dSet);
Navigate(doc1->DocumentElement, 0);
}

</source>

==Create DataSet==

<source lang="csharp">
#include "stdafx.h"
using namespace System;
using namespace System::Data;
void main()
{
DataSet^ myDataSet = gcnew DataSet("Game Data");
myDataSet->Tables->Add("Player");
myDataSet->Tables->Add("Score");
DataTable^ playerTable = myDataSet->Tables["Player"];
DataColumn^ firstNameColumn1 = playerTable->Columns->Add("First Name",String::typeid);
DataColumn^ lastNameColumn1 = playerTable->Columns->Add("Last Name",String::typeid);
playerTable->Columns->Add("Email", String::typeid);
}

</source>

==Create XmlDataDocument from DataSet==

<source lang="csharp">

#include "stdafx.h"
using namespace System;
using namespace System::Configuration;
using namespace System::Data;
using namespace System::Data::SqlClient;
using namespace System::Xml;
void Navigate(XmlNode ^node, int depth)
{
if (node == nullptr)
return;
Console::WriteLine(depth);
Console::WriteLine(node->NodeType.ToString());
Console::WriteLine(node->Name);
Console::WriteLine(node->Value);
if (node->Attributes != nullptr)
{
for (int i = 0; i < node->Attributes->Count; i++)
{
Console::WriteLine(node->Attributes[i]->Name);
Console::WriteLine(node->Attributes[i]->Value);
}
}
Navigate(node->FirstChild, depth+1);
Navigate(node->NextSibling, depth);
}
void main(){
XmlDocument ^doc = gcnew XmlDocument();
SqlConnection ^connect = gcnew SqlConnection();

connect->ConnectionString = "SQLConnection";
SqlDataAdapter ^dAdapt = gcnew SqlDataAdapter();
DataSet ^dSet = gcnew DataSet();
dAdapt->SelectCommand = gcnew SqlCommand("SELECT * FROM Authors", connect);

dAdapt->Fill(dSet, "Authors");
XmlDataDocument ^doc1 = gcnew XmlDataDocument(dSet);
Navigate(doc1->DocumentElement, 0);
}

</source>

==Load DataSet==

<source lang="csharp">
#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();
}

</source>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Visual C++ .NET/Database ADO.net/DataSet - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия