How to show a datetime field in a TextBox

[ad]

I have a datetime filed, name Birthday.
I use aTexBox.Text= ((DateTime)dr["Birthday"]).ToShortDateString();
but it result in an .InvalidCastException:

How can I datetime field in a TextBox?

[Ludwig Stuyck]

On Mon, 28 Mar 2005 21:56:53 +0800, "ad" <[e-mail]> wrote:

I have a datetime filed, name Birthday.
I use aTexBox.Text= ((DateTime)dr["Birthday"]).ToShortDateString();
but it result in an .InvalidCastException:

How can I datetime field in a TextBox?

What type is the Birthday column, and does it allow nulls?
--
Ludwig Stuyck
http://www.coders-lab.net

[Helge Jensen]

ad wrote:

I have a datetime filed, name Birthday.
I use aTexBox.Text= ((DateTime)dr["Birthday"]).ToShortDateString();
but it result in an .InvalidCastException:
That's because dr["Birthday"] doesn't evaluate to a DateTime instance
(or more precisely, a boxed DateTime struct).
How can I datetime field in a TextBox?

Like you are doing. Try printing dr["Birhtday"].GetType().FullName :)

--
Helge Jensen
mailto:he**********@slog.dk
sip:he**********@slog.dk
-=> Sebastian cover-music: http://ungdomshus.nu <=-

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

hi,
what is dr ? it's a DataRow or a DataReader ?

what is the type of "BirthDay"column?

Does it support null ?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"ad" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I have a datetime filed, name Birthday.
I use aTexBox.Text= ((DateTime)dr["Birthday"]).ToShortDateString();
but it result in an .InvalidCastException:

How can I datetime field in a TextBox?

[ad]

Thank
1. dr is a DataReader
2. the type of "BirthDay"column is DateTime
3. it support null

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> ¼¶¼g©ó
¶l¥ó·s»D:OC**************@TK2MSFTNGP14.phx.gbl...

hi,
what is dr ? it's a DataRow or a DataReader ?

what is the type of "BirthDay"column?

Does it support null ?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"ad" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I have a datetime filed, name Birthday.
I use aTexBox.Text= ((DateTime)dr["Birthday"]).ToShortDateString();
but it result in an .InvalidCastException:

How can I datetime field in a TextBox?

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

Hi,

If it does support null you have to check for that:

textbox.Text = dr["Birthday"] == DBNull.Value? " N/A" :
((DateTime)dr["BirthDay"]).ToShortDateString();

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"ad" <[e-mail]> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

Thank
1. dr is a DataReader
2. the type of "BirthDay"column is DateTime
3. it support null

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
¼¶¼g©ó
¶l¥ó·s»D:OC**************@TK2MSFTNGP14.phx.gbl...

hi,
what is dr ? it's a DataRow or a DataReader ?

what is the type of "BirthDay"column?

Does it support null ?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"ad" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

>I have a datetime filed, name Birthday.
> I use aTexBox.Text= ((DateTime)dr["Birthday"]).ToShortDateString();
> but it result in an .InvalidCastException:
>
> How can I datetime field in a TextBox?
>
>
>