The Dutiful Dead, or: A Tale Of Mixed DataSets
Updated 2 years ago
Version 5.0Hi, 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 UsingI 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