Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Brain Freeze
Message
 
 
À
20/05/2014 22:43:41
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
Versions des environnements
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01600361
Message ID:
01600364
Vues:
62
>>>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?

I am still confused and I am going out, but looks like you need to consider modulus operator of division by 3.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform