SqlDataReader.GetChar ?? exist or not

[MattB]

Hello,

If this exists

http://msdn.microsoft.com/library/d...tasqlclientsqldatareaderclassgetchartopic.asp

Why doesn't it show in intellisense in VS.NET 1.1 and throw errors.

I have a stored procedure returning a char(1) datatype....

How should I pull this datafield from my DataReader, I know I could
use
dr.GetSqlString(i) but shouldn't there be something for a char or
fixed length?

Thanks,
Matt

 

[Guest]

GetChar() exists because SqlDataReader implements IDataReader. You can even
see it in the Object Browser and it is "well" documented. However the .NET
Framework does not "really" implement it. Instead it throws an exception.
It seems the documentation guys and the developers have a disconnect.

The MSDN shows the following under the subject "Mapping .NET Framework Data
Provider Data Types to .NET Framework Data Types":

http://msdn.microsoft.com/library/d...aproviderdatatypestonetframeworkdatatypes.asp

Sql Server Type: char
..NET Framework Type: String or Char[]
..NET Framework typed accessor: GetString() or GetChars()
SqlType typed accessor: GetSqlString()

Don't ask me the reasoning behind not implementing GetChar().

HTH,

 

[Pablo Castro [MS]]

SqlDataReader.GetChar is not supported. It's an error in the docs. I filed a
bug so we fix the docs. Thanks for posting.

You can access char data by using GetString() or GetChars().

--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.