SqlDataReader

[SC]

Hi,

After a SqlDataReader.ExecuteReader method has returned,
how can I get the field names of every column that were
returned?

It has to be possible, right? I looked through the
different methods and properties but I couldn't find
anything. Maybe I missed it!

Thanks a lot,

SC

[Jon Skeet [C# MVP]]

SC <an*******@discussions.microsoft.com> wrote:

After a SqlDataReader.ExecuteReader method has returned,
how can I get the field names of every column that were
returned?

Use SqlDataReader.FieldCount to get how many fields there are (in the
current row) and then SqlDataReader.GetName(int) to find the name for
any particular column.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Miha Markic]

Hi SC,

There is FieldCount (count of columns) and GetName() method which returns
column name.
Is this you were after?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"SC" <an*******@discussions.microsoft.com> wrote in message
news:02****************************@phx.gbl...

Hi,

After a SqlDataReader.ExecuteReader method has returned,
how can I get the field names of every column that were
returned?

It has to be possible, right? I looked through the
different methods and properties but I couldn't find
anything. Maybe I missed it!

Thanks a lot,

SC