Slow data binding - LinqToXML to DataGridView

See more:

LINQ

C#3.5

DataGridView

XmlReader

, +

Hey Guys,

Assigning the Linq query result to the DataGrid datasource it takes a lot of time (40 seconds) and I only have 8000 entries (rows)in the XML file. I know that this can be fixed by looping through the Linq result elements and adding them to the grid view one by one but is there any other easy way that comes to your mind?

Thanks in advance

var Log =
    from c in xmlDoc.Descendants("Event")
    select new
    {
        Type = ((string)c.Element("Type").Value),
        Class = ((string)c.Element("Class").Value),
        Method = ((string)c.Element("Method").Value),
        DateTime = ((string)c.Element("DateTime").Value),
        Text = ((string)c.Element("Text").Value),
        StackTrace = ((string)c.Element("StackTrace").Value),
        SourceTable = ((string)c.Element("SourceTable").Value),
        SourceField = ((string)c.Element("SourceField").Value),
        SourceValue = ((string)c.Element("SourceValue").Value),
        TargetTable = ((string)c.Element("TargetTable").Value)
    };

dbGridLog.AutoGenerateColumns = true;
dbGridLog.DataSource = Log.ToList();