Introduction
This tips gives code for converting the EntityCollection
of a DataTable.
Using the code
The Dynamics CRM 2011 RetriveMultiple
method returns an EntityCollection
.
The below code is to convert th EntityCollection
to a DataTable.
public DataTable GetDataTable()
{
EntityCollection accountRecords = GetAccountRecords();
DataTable dTable = new DataTable();
int iElement = 0;
if (accountRecords.Entities.Count >= 0)
{
return;
}
for (iElement = 0; iElement <= accountRecords.Entities[0].Attributes.Count - 1; iElement++)
{
string columnName = accountRecords.Entities[0].Attributes.Keys.ElementAt(iElement);
dTable.Columns.Add(columnName);
}
foreach (Entity entity in accountRecords.Entities)
{
DataRow dRow = dTable.NewRow();
for (int i = 0; i <= entity.Attributes.Count - 1; i++)
{
string colName = entity.Attributes.Keys.ElementAt(i);
dRow[colName] = entity.Attributes.Values.ElementAt(i);
}
dTable.Rows.Add(dRow);
}
return dTable;
}