Hello people,

I have made a sql query that stores the query result into a data-table.
my issue is now...

I need to put my text-strings (str1,str2,str3 and str4)
to certain columns and same row (in the same loop)

below is my code.
Code:
        For Each dt2row As DataRow In HashDataTable4.Rows

            Dim CmString As String = (dt2row.Item(0).ToString()) ' Here is how I get my textstring.

            Dim str1 As String = dt2row.Item(0).ToString()
            str1 = Regex.Replace(str1, "(\d{5})", "$1") ' ordernr

            Dim str2 As String = dt2row.Item(0).ToString()
            str2 = Regex.Replace(str2, "(\d{5})(.*)(Language: )(\w{3})(.*)", "$4") ' source language

            Dim str3 As String = dt2row.Item(0).ToString()
            str3 = Regex.Replace(str3, "(.*)(\w{3})(-)(\w{3})(.*)", "$4") ' target language

            Dim str4 As String = dt2row.Item(0).ToString()
            str4 = Regex.Replace(str4, "(.*)(Context Match: )(.*)(;)", "$3") ' Context Match

        Next
Could someone help me?

thank you in advance