Loop through the rows of a particular DataTable

Question

IDE   VS 2008  Platform    NET 3 5   Hi   Here is my DataTable columns    ID Note Detail  I want to write sth like this      below code block is not the right syntax   For each q in dtDataTable Column  Detail        strDetail   Row of Column Detail   Next   Can anyone give me a suggestion and show me a code sample please   Thanks

User · Answer

Dim row As DataRow For Each row In dtDataTable Rows     Dim strDetail As String     strDetail   row  Detail       Console WriteLine  Processing Detail  0    strDetail  Next row

User · Answer

For Each row As DataRow In dtDataTable Rows     strDetail   row Item  Detail   Next row   There s also a shorthand   For Each row As DataRow In dtDataTable Rows     strDetail   row  Detail   Next row   Note that Microsoft s style guidelines for  Net now specifically recommend against using hungarian type prefixes for variables   Instead of  strDetail   for example  you should just use  Detail

User · Answer

Here s the best way I found       For Each row As DataRow In your table Rows         For Each cell As String In row ItemArray              do what you want          Next     Next

User · Answer

You want to loop on the  Rows  and access the column for the row like q  column    Just           For Each q In dtDataTable Rows             strDetail   q  Detail           Next   Also make sure to check msdn doc for any class you are using   use intellisense

[vb.net] Loop through the rows of a particular DataTable

Examples related to vb.net

Examples related to datatable