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.

Answer 1

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".