views:

23

answers:

2

For j = 0 To wcData.Tables(0).Rows.Count - 1 For i = 900 To 1700 wcData.Tables("db").Rows(j)("range") = i Next Next

trying to insert "i" into each column cell of "range"

any suggestion.

Thanks.

+1  A: 
Dim rowOffset As Integer = 900;

For j = 0 To wcData.Tables(0).Rows.Count - 1 
    wcData.Tables("db").Rows(j).Item("range") =  rowOffset + j
Next
treefrog
it inserts only 1700. This is what i'm trying to achevefor example: if i = 900, j = 0; i = 901, j = 1; i = 902, j = 2..... etc.thanksT
Gbolahan
Does that solve what you're wanting?
treefrog
this worked for now. thanks
Gbolahan
No problem Gbolahan. Please mark the answer if it solved your issue.
treefrog
A: 
 Dim rowOffset As Integer = 900

  For j = 0 To wcData.Tables(0).Rows.Count - 1
   wcData.Tables("ratingout").Rows(j).Item("range") = rowOffset + j
   If i >= 1700 Then
    Exit For
   End If
 Next

this worked for now. thanks

Gbolahan