Checking for datareader returned types at runtime

's Computer Specifications

dr is a dataset, str1 is a string. How can I know the type inside the
datareader field?
I tried:

if(dr.GetValue(n) is System.Int32)
str1=Convert.ToString(dr.GetSqlInt32(n))
else
str1=dr.GetString(n)

But the compiler warns the if is always false.
Thanks in advance

's Computer Specifications

Sorry, dr is a SqlDatareader

"João Costa" wrote:

> dr is a dataset, str1 is a string. How can I know the type inside the
> datareader field?
> I tried:
>
> if(dr.GetValue(n) is System.Int32)
> str1=Convert.ToString(dr.GetSqlInt32(n))
> else
> str1=dr.GetString(n)
>
> But the compiler warns the if is always false.
> Thanks in advance

's Computer Specifications

I solved the problem with:
if(rsAux.GetFieldType(n).FullName == "System.Int32" )

"João Costa" wrote:

> Sorry, dr is a SqlDatareader
>
> "João Costa" wrote:
>
> > dr is a dataset, str1 is a string. How can I know the type inside the
> > datareader field?
> > I tried:
> >
> > if(dr.GetValue(n) is System.Int32)
> > str1=Convert.ToString(dr.GetSqlInt32(n))
> > else
> > str1=dr.GetString(n)
> >
> > But the compiler warns the if is always false.
> > Thanks in advance

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types"	roadsidetree	Microsoft Excel Charting	17	12th May 2010 06:51 PM
How to process datareader nulls coming from datareader?	JB	Microsoft C# .NET	4	3rd Nov 2008 01:56 AM
Should I close a datareader returned using daab?	hansiman	Microsoft ASP .NET	7	11th May 2005 01:02 PM
DataReader and Returned Parms	Jim Heavey	Microsoft ADO .NET	3	19th Dec 2003 09:39 PM
records returned from datareader error	Davef	Microsoft ASP .NET	1	28th Aug 2003 04:40 AM