Hello People,
below is a picture of how my result looks in the datagridview
I have made a simple SQL Query that put the results in a data-table where I already prepared certain columns I have created.
there are 20 different columns.
The picture below includes a column headed ”order number” (column 2). I need a function that contains a loop that will perform the following function:
If an item exists twice in the column, regardless of row, the first instance must control all identical instances throughout. When an identical instance is identified, the content from the “target language” column in the first instance must be copied to the “target language” columns in all the other instances.
Could someone help me with a code?
here is what I got so far this is a part of old code
Thank you in advance
below is a picture of how my result looks in the datagridview
I have made a simple SQL Query that put the results in a data-table where I already prepared certain columns I have created.
there are 20 different columns.
The picture below includes a column headed ”order number” (column 2). I need a function that contains a loop that will perform the following function:
If an item exists twice in the column, regardless of row, the first instance must control all identical instances throughout. When an identical instance is identified, the content from the “target language” column in the first instance must be copied to the “target language” columns in all the other instances.
Could someone help me with a code?
here is what I got so far this is a part of old code
Code:
If HashDatatable1.Rows.Count > 0 Then
For i As Integer = 0 To HashDatatable1.Rows.Count - 1
If Not HashDatatable1.Rows(i).Item(18).ToString.Contains("Language:") Then
HashDatatable1.Rows(i)(18) = "0"
End If
' MsgBox(HashDatatable1.Rows(i).Item(18).ToString())
Next
End If
Thank you in advance