Vista CRM Search Gadget

private static void add2DataTable(ref DataTable dataTable, BusinessEntityCollection entityCollection)
{
       // adding records
       for (int i = 0; i < entityCollection.BusinessEntities.Length; i++)
       {
           DynamicEntity dynamicEntity = (DynamicEntity)entityCollection.BusinessEntities[i];
   DataRow dataRow = dataTable.NewRow();
   try
           {
               dataRow["type"] = dynamicEntity.Name;
               dataRow["id"] = ((KeyProperty)dynamicEntity.Properties[0]).Value.Value;
               if (((StringProperty)dynamicEntity.Properties[1]).Value != null)
                   dataRow["field1"] = ((StringProperty)dynamicEntity.Properties[1]).Value;
               if (((StringProperty)dynamicEntity.Properties[2]).Value != null)
                   dataRow["field2"] = ((StringProperty)dynamicEntity.Properties[2]).Value;
               if (((StringProperty)dynamicEntity.Properties[3]).Value != null)
                   dataRow["field3"] = ((StringProperty)dynamicEntity.Properties[3]).Value;
               if (((StringProperty)dynamicEntity.Properties[4]).Value != null)
                   dataRow["field4"] = ((StringProperty)dynamicEntity.Properties[4]).Value;
               dataTable.Rows.Add(dataRow);
           }
           catch (Exception)
           {
            if (dataRow != null && dataRow["id"] != null && dataRow["id"] != String.Empty)
              {
                  dataTable.Rows.Add(dataRow);
              }
           }
       }
   }

TourismVI, thank you very much for sharing this with the community!