Forum Discussion
FredLucas
Contributor III
Hi syedfasiullah,
In that case you might want to export the content of the table to .csv via a business rule.
You could do this by getting the data you want to export into a data table object like this:
Dim dtResult As DataTable
Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
Dim strSQL As New Text.StringBuilder
strSQL.AppendLine("Select * from TableToExport")
dtResult = BRApi.Database.ExecuteSqlUsingReader(dbConnApp, strSQL.ToString, False)
End Using
And then use the DataTableToFile function that I've shared on this post:
syedfasiullah
5 months agoNew Contributor II
Thank you for providing help, let me try this and get back to you.
Related Content
- 6 months ago
- 4 months ago