load Extended Event file into datatable C#

Question

load Extended Event file into datatable C#

John Couch 181

How to load an Extended Event file from BLOB Storage into a DataTable using C#

Sumarigo-MSFT 47,511 Reputation points Microsoft Employee Moderator

2021-07-12T09:37:46.66+00:00

@John Couch May I know what exactly are you trying to accomplish? Can you please elaborate bit more on your query?
John Couch 181 Reputation points

2021-07-12T15:30:38.343+00:00

I built a C# windows for application that I use to connect to Azure Blob storage, list the XEL files in a datagridview. I want to double click the file, and have it pull the file from Blob storage and import it into a datagridview.
shiva patpi 13,376 Reputation points Microsoft Employee Moderator

2021-07-19T21:30:13.81+00:00

@John Couch ,
Trying to understand more on this:

Your current design:
You have built a C#.net Windows Application which has got a datagridview control , right now datagridview shows all the files in each row which are pulled from Azure Blob Storage.

Your requirement:
When you click on a row in the datagridview (lets says row is pointing to a text file path of Blob Storage) , in the same gridview you want to display the contents of that text file ?

Questions:
So where exactly you were blocked as of now ?
What is the format of those files in the datagridview (.xls or .txt or .csv) ?
Why you want to display the contents of the file in the same datagridview ?
Is it something like you have a '+' icon mark before each row and you are clicking on that '+' icon mark to display the contents of the file ?
John Couch 181 Reputation points

2021-07-19T21:57:26.027+00:00

Yes, right now I have a C# application that connects to Azure Blob Storage and lists all of the Extended Event files in a particular blob storage account. I want to be able to double click on one or several of those files and have them open into a datagridview in a modal window. I can handle the coding outside of how to read an extended event file from blob storage into a datagridview.
John Couch 181 Reputation points

2021-07-19T22:00:25+00:00

XEL files (extended Event files are XML format (I believe).

https://stackoverflow.com/questions/53147992/how-to-read-extended-events-xel-file

https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/advanced-viewing-of-target-data-from-extended-events-in-sql-server?view=sql-server-ver15

There USED to be some classes you could import into your project, but apparently they are no longer usable??? I see they replaced some functionality in Powershell and you can use this:

https://tsql.tech/how-to-programmatically-read-from-sql-server-extended-events-files-xel-with-powershell/

But I cannot find a C# equivelant.