Column and dataset

[Gabriel]

Hello

I have this :

foreach (DataRow row in dataset.Tables[0].Rows)

{

....... //

}

In the loop how can I retrieve a specific column value but from the column
name and from the index ?

Regards,

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

Each item in the DataColumns collection has a ColumnName property. You can
get these before you start the foreach.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"Gabriel" wrote:

Hello

I have this :

foreach (DataRow row in dataset.Tables[0].Rows)

{

....... //

}

In the loop how can I retrieve a specific column value but from the column
name and from the index ?

Regards,

[Gabriel]

Each item in the DataColumns collection has a ColumnName property. You can
get these before you start the foreach.

It's not possible to do something like this (int the loop) :
row[0]["ColumnName"]

??

Thanks,

[Shishir Kumar Mishra]

HTH

http://msdn2.microsoft.com/en-us/lib...arow.item.aspx

Thanks and Regards
Shishir Kumar Mishra

"Gabriel" <no****@nospam.comwrote in message
news:Os**************@TK2MSFTNGP05.phx.gbl...

Hello

I have this :

foreach (DataRow row in dataset.Tables[0].Rows)

{

...... //

}

In the loop how can I retrieve a specific column value but from the column
name and from the index ?

Regards,

[Cor Ligthert[MVP]]

Gabriel,

It is the Item property which is the default.

Therefore in C# you use it as you wrote, you can reference it with
an integer (the slowest) a string and the DataColumn as that is a property
from the Columncollection from the dataset. The latter is the fastest.

Cor