How to export a table from a SQLite database to a excel file

Hello experts,

So i’ve created a new dataset called “TesteDB”

And inside this dataset i’ve created a table wich i populated with some data

I want to export this data into an excel file, how can i write a script that allows me to do this?

You could load this table into a DataGrid component and use the DataGridName.ExportToCSV() method in the codebehind of the used display.
In this image you can see an example of this:

1 Like