appropriate C# types for SqlDbType.Money and SqlDbType.DateT ime?

[jason]

hello all,

silly question, but i can't find a thread that answers it. i have
stored procedures that have output parameters of the datatypes Money
and DateTime.

i have the following sample code to extract those parameters into class
properties:

public float P1 = (float) oSqlCmd.Paramet ers["@Money1"].Value;
publid DateTime P2 = (DateTime) oSqlCmd.Paramet ers["@Date1"].Value;

however, those are not legal implicit conversions. so my questions are:

1) what's the appropriate datatype to use for members in c# classes for
these datatypes?
2) what's the appropriate way to convert from these datatypes to the c#
datatypes (unless of course implicit conversion is possible)

thanks for any help,

jason

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

IIRC there is an article in MSDN about this.

Money can be represented as decimal and DateTime with DateTime :)

In anyway you should use the correct Convert.ToXXXX method
Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"jason" <ia****@yahoo.c om> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

hello all,

silly question, but i can't find a thread that answers it. i have
stored procedures that have output parameters of the datatypes Money
and DateTime.

i have the following sample code to extract those parameters into class
properties:

public float P1 = (float) oSqlCmd.Paramet ers["@Money1"].Value;
publid DateTime P2 = (DateTime) oSqlCmd.Paramet ers["@Date1"].Value;

however, those are not legal implicit conversions. so my questions are:

1) what's the appropriate datatype to use for members in c# classes for
these datatypes?
2) what's the appropriate way to convert from these datatypes to the c#
datatypes (unless of course implicit conversion is possible)

thanks for any help,

jason

[jason]

ahh, convert instead of implicit casting. that must be what i was
missing. thanks!