formating text in a textbox control?

[djc]

Is there a property or method of the textbox web server control that I can
use to format the text in it a certian way. For example I am displaying a
date value from a database in a text box. It displays like so: mm/dd/yyyy
mm:hh:ss. I 'was' using the .ToShortDateStr ing() function like so:
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString() which
worked great until I came across a database record with NULL for this field.
It seems the best thing to do would be to have something attatched to the
textbox control itself that would control formating of it's own contents.
That way I would not need to add a NULL check before using the
..ToShortDateSt ring() function.

any input would be appreciated. Thanks!

[Curt_C [MVP]]

Do a null check around it.

if(drMain.Item( "EstimatedDeliv eryDate") != null)
{
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString() ;
}
else
{
txtETA.Text = "";
}
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"djc" <no***@nowhere. com> wrote in message
news:Oj******** ******@TK2MSFTN GP15.phx.gbl...

Is there a property or method of the textbox web server control that I can
use to format the text in it a certian way. For example I am displaying a
date value from a database in a text box. It displays like so: mm/dd/yyyy
mm:hh:ss. I 'was' using the .ToShortDateStr ing() function like so:
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString()
which
worked great until I came across a database record with NULL for this
field.
It seems the best thing to do would be to have something attatched to the
textbox control itself that would control formating of it's own contents.
That way I would not need to add a NULL check before using the
.ToShortDateStr ing() function.

any input would be appreciated. Thanks!

[William F. Robertson, Jr.]

I would highly recommend turning Option String On.

http://weblogs.asp.net/rchartier/arc.../13/58381.aspx

This would be a compile time error, and you would already have to handle it
differently.

Just like Curt said, you will have to do it in two steps.

if drMain.Item("Es timatedDelivery Date") == DBNull.Value then
txtETA.Text = ""
else
txtETA.Text = CType( drMain.Item("Es timatedDelivery Date" ),
DateTime).ToSho rtDateString()
end if

"djc" <no***@nowhere. com> wrote in message
news:Oj******** ******@TK2MSFTN GP15.phx.gbl...

Is there a property or method of the textbox web server control that I can
use to format the text in it a certian way. For example I am displaying a
date value from a database in a text box. It displays like so: mm/dd/yyyy
mm:hh:ss. I 'was' using the .ToShortDateStr ing() function like so:
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString() which worked great until I came across a database record with NULL for this field. It seems the best thing to do would be to have something attatched to the
textbox control itself that would control formating of it's own contents.
That way I would not need to add a NULL check before using the
.ToShortDateStr ing() function.

any input would be appreciated. Thanks!

[djc]

ok. Thank you.

"William F. Robertson, Jr." <theman_at_fdrs ucks.com> wrote in message
news:uZ******** ******@TK2MSFTN GP14.phx.gbl...

I would highly recommend turning Option String On.

http://weblogs.asp.net/rchartier/arc.../13/58381.aspx

This would be a compile time error, and you would already have to handle it differently.

Just like Curt said, you will have to do it in two steps.

if drMain.Item("Es timatedDelivery Date") == DBNull.Value then
txtETA.Text = ""
else
txtETA.Text = CType( drMain.Item("Es timatedDelivery Date" ),
DateTime).ToSho rtDateString()
end if

"djc" <no***@nowhere. com> wrote in message
news:Oj******** ******@TK2MSFTN GP15.phx.gbl...

Is there a property or method of the textbox web server control that I can use to format the text in it a certian way. For example I am displaying a date value from a database in a text box. It displays like so: mm/dd/yyyy mm:hh:ss. I 'was' using the .ToShortDateStr ing() function like so:
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString()

which

worked great until I came across a database record with NULL for this

field.

It seems the best thing to do would be to have something attatched to the textbox control itself that would control formating of it's own contents. That way I would not need to add a NULL check before using the
.ToShortDateStr ing() function.

any input would be appreciated. Thanks!

[djc]

ok. Thank you.

"Curt_C [MVP]" <software_AT_da rkfalz.com> wrote in message
news:eP******** ******@TK2MSFTN GP12.phx.gbl...

Do a null check around it.

if(drMain.Item( "EstimatedDeliv eryDate") != null)
{
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString() ;
}
else
{
txtETA.Text = "";
}
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"djc" <no***@nowhere. com> wrote in message
news:Oj******** ******@TK2MSFTN GP15.phx.gbl...

Is there a property or method of the textbox web server control that I can use to format the text in it a certian way. For example I am displaying a date value from a database in a text box. It displays like so: mm/dd/yyyy mm:hh:ss. I 'was' using the .ToShortDateStr ing() function like so:
txtETA.Text = drMain.Item("Es timatedDelivery Date").ToShortD ateString()
which
worked great until I came across a database record with NULL for this
field.
It seems the best thing to do would be to have something attatched to the textbox control itself that would control formating of it's own contents. That way I would not need to add a NULL check before using the
.ToShortDateStr ing() function.

any input would be appreciated. Thanks!