Enumerating SqlDataReader column name

[A.M]

Hi,

How can I have column names of a SqlDataReader ?

Thanks,
Ali

 

[AlexS]

Hi, A.M.

check SqlDataReader.GetName Method

HTH
Alex

 

[William Ryan eMVP]

In addition to Alex's recommendation, you can use the GetSchemeTable method
to get more in depth info about the reader
http://www.knowdotnet.com/articles/schemas2.html This may be more
information than you need but it's there if you need it.

HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/

 

[hrothenb]

Try

for col As Integer = 0 To SqlReader.FieldCount - 1 Console.Write(SqlReader.GetName(col).ToString())
Next