How can I convert one element in this array to uppercase as it is being written to a file? I want dr(1) in Upper Case. I tried
vbUpperCase(dr(1)) but it gives me an error.
vbUpperCase(dr(1)) but it gives me an error.
Code:
Dim sw As New System.IO.StreamWriter("F:\myfiles\" & Format(Now, "MMddyy") & ".tmp")
'Loop through each DataRow in the DataTable within the DataSet
For Each dr As DataRow In myDataSet.Tables(0).Rows
sw.WriteLine(dr(0) & "," & dr(1))
Next