Blog Post
AndreaF
5 months agoContributor III
Hi, if used in an Extensible rule instead of a Data Set rule, how would I pass the rows from the dataset to a writer?
For example, I am currently using this piece of code to export to csv an application table:
Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)
Using dt As DataTable = BRApi.Database.ExecuteSql(dbConnApp, SqlString.ToString, True)
Using writer As New StreamWriter(filePath)
For Each row As DataRow In dt.Rows
writer.WriteLine(String.Join(",", row.ItemArray))
Next
End Using
End Using
End Using
I would like to export to csv the join between an application and a framework table. I can create the dataset as you have shown above, but then how do I get the rows of the dataset? Is that possible?
Thank you