>>I want to organize rows in a datatable into 3 columns without scanning the table using a counter.
>>My brain just won't work on this one.
>>
>>Assuming that I know rownumber r, is there a mathematical function using r that will return the proper column (1,2 or 3) for each row?
>
>I am not sure I understand the question.
>
>myDataTable.Rows[rowNumber].Columns[0]
will return value for the first column. (rowNumber is 0 based)
rownumber 1 would be column 1, rownumber 2 would be column 2, rownumber 3 would be column 3, 4 would be 1, 5 would be 2, 6 would be 3, 7 would be 1 etc.
Is there a mathematical function using rownumber that will return the column number?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.