How to get the row number from a datatable

Question

I am looping through every row in a datatable   foreach  DataRow row in dt Rows       I would like to get the index of the current row within the dt datatable  for example   int index   dt Rows current row number    How do i do this

User · Answer

You have two options here    You can create your own index counter and increment it Rather than using a foreach loop  you can use a for loop   The individual row simply represents data  so it will not know what row it is located in

User · Answer

Try   int i   Convert ToInt32 dt Rows Count     I think it s the shortest  thus the simplest way

User · Answer

You do know that DataRow is the row of a DataTable correct   What you currently have already loop through each row    You just have to keep track of how many rows there are in order to get the current row   int i   0  int index   0  foreach  DataRow row in dt Rows     index   i     do stuff i

User · Answer

ArrayList check   new ArrayList                 for  int i   0  i  lt  oDS Tables 0  Rows Count  i          int iValue   Convert ToInt32 oDS Tables 0  Rows i  3  ToString         check Add iValue

User · Answer

If you need the index of the item you re working with then using a foreach loop is the wrong method of iterating over the collection  Change the way you re looping so you have the index   for int i   0  i  lt  dt Rows Count  i             your index is in i     var row   dt Rows i

User · Answer

Why don t you try this    for int i 0  i  lt  dt Rows Count  i           u can use here the i

User · Answer

int index   dt Rows IndexOf row     But you re probably better off using a for loop instead of foreach

[c#] How to get the row number from a datatable?

Examples related to c#

Examples related to datatable