Hi all,
I am just wandering, is it possible to programmatically detect each
column's data type of SalDataReader, DataSet.Tables[i], DataTable?
Thanks for any suggestion!

--
WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy

Hi,

There is SqlDataReader.GetFieldType method and DataColumn.DataType property.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Hardy Wang" <(E-Mail Removed)> wrote in message
news:ehoJQ%23T$(E-Mail Removed)...
> Hi all,
> I am just wandering, is it possible to programmatically detect each
> column's data type of SalDataReader, DataSet.Tables[i], DataTable?
> Thanks for any suggestion!
>
> --
> WWW: http://hardywang.1accesshost.com
> ICQ: 3359839
> yours Hardy
>
>

Thanks, I found another wway like:
object o = dataReader.GetValue(i);
Type t = o.GetType();
t.FullName;

I think they work pretty the same way.

--
WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:uNW1lDU$(E-Mail Removed)...
> Hi,
>
> There is SqlDataReader.GetFieldType method and DataColumn.DataType
property.
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software development
> miha at rthand com
> www.rthand.com
>
> "Hardy Wang" <(E-Mail Removed)> wrote in message
> news:ehoJQ%23T$(E-Mail Removed)...
> > Hi all,
> > I am just wandering, is it possible to programmatically detect each
> > column's data type of SalDataReader, DataSet.Tables[i], DataTable?
> > Thanks for any suggestion!
> >
> > --
> > WWW: http://hardywang.1accesshost.com
> > ICQ: 3359839
> > yours Hardy
> >
> >
>
>

Hardy Wang <(E-Mail Removed)> wrote:
> Thanks, I found another wway like:
> object o = dataReader.GetValue(i);
> Type t = o.GetType();
> t.FullName;
>
> I think they work pretty the same way.

Not necessarily - if the value is DbNull, for instance, that will give
a very different result.

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

I ran some test. If the result is null, it will return DBNull, this is also
what I need.

--
WWW: http://hardywang.1accesshost.com
ICQ: 3359839
yours Hardy
"Jon Skeet [C# MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hardy Wang <(E-Mail Removed)> wrote:
> > Thanks, I found another wway like:
> > object o = dataReader.GetValue(i);
> > Type t = o.GetType();
> > t.FullName;
> >
> > I think they work pretty the same way.
>
> Not necessarily - if the value is DbNull, for instance, that will give
> a very different result.
>
> --
> Jon Skeet - <(E-Mail Removed)>
> http://www.pobox.com/~skeet
> If replying to the group, please do not mail me too

Hardy Wang <(E-Mail Removed)> wrote:
> I ran some test. If the result is null, it will return DBNull, this is also
> what I need.

If that's what you need, that's fine - but it's certainly not what you
originally asked for (the column type) nor is it what Miha's code would
have given you.

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too