DataReader question - Sql datatypes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all
My datareader reads a tinyint SQL column. How do I
retrieve the value of the column.

SqlDr.GetInt16(MyTinyIntColumnOrdinal) fails and causes a
InvalidCastException. Thanks for your help.
 
Hi,

The data types in SQL & .NET do not usually match , you can use
Convert.ToInt16().

tinyint is defined in SQL as a 8 bit data, therefore GetInt16() give you
error, you should use GetByte() instead.

Cheers,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dataset vs DataReader Please Help 7
Datareader question 4
datareader reader questions 2
How to fill DataReader to a ListView? 0
How is memory managed for Database connections and DataReaders 4
datareader and mssql text datatype 3
datareader return with one result instead of two 2
Converting DataReader to a DataTable Performance issue 7

Back
Top