Comments by gspeedtech

gspeedtech 14-Jul-11 13:31pm View

If I try to change it, it wont accept dr instead of bo

.CustomerID = dr.CustomerID(CustomerID is not a member of System.Data.DataRow)

gspeedtech 10-Jun-11 18:07pm View

Thanks

gspeedtech 10-Jun-11 18:06pm View

Thanks

gspeedtech 3-Jun-11 16:47pm View

If I try:

Dim TransactionData as datarow
For Each TransactionData In z_Transaction
Regex.Replace(TransactionData, "vbCrLf", " ")
Next
End If

I get a "datarow cannot be converted to a String" error on the "Replace" line of code.

If I try
Dim TransactionData as String

I get a similar conversion error.

gspeedtech 3-Jun-11 12:00pm View

Thanks for the reply,

My problem is, according to my limited knowledge, "Replace" only works on String objects.
How do you For/Each through a collection of Objects and target only the String objects?

gspeedtech 2-Jun-11 17:54pm View

The data is Customer information. It is periodically collected, and transfomed into an XML file. The problem is, there are CRLF characters randomly across all the data which is not acceptable to the application that uploads the XML file.

Looking for a way to edit out undesireable characters from the entire TransactionFile.

gspeedtech 4-Jan-11 20:04pm View

Thanks for the input.

gspeedtech 4-Jan-11 20:04pm View

No wait, that's just the DataSet DataTable and DataRow info, not the source table info.

Comments by gspeedtech (Top 8 by date)