Nicholas Trevatt posted on Thursday, January 11, 2007

I am having trouble with the SafeDataReader not being able to read SQL Server TinyInt data types. I have tried using .GetInt32 and .GetInt16 without success. If I convert the same DB field to just Int then it works fine.

Am I missing something?

Thanks,
Nicholas Trevatt

Brian Criswell replied on Thursday, January 11, 2007

Isn't there a GetByte()?

Skafa replied on Thursday, January 11, 2007

there is :-)

ward0093 replied on Thursday, January 11, 2007

consider creating a sub-class of Rocky's SafeDataReader in your middle tier... i did that to add some functionality...

for instance:

if i have a String Field returning NULL I want my SafeDataReader to return NOTHING (not string.empty) so that my Infragistics Grid will display what is setup in the NullText Field... other wise Infragistics Grid will display a blank cell.

ward0093