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 .ToShortDateString() function like so:
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring() 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
..ToShortDateString() function.

any input would be appreciated. Thanks!

[Curt_C [MVP]]

Do a null check around it.

if(drMain.Item("EstimatedDeliveryDate") != null)
{
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring() ;
}
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**************@TK2MSFTNGP15.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 .ToShortDateString() function like so:
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring()
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
.ToShortDateString() 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("EstimatedDeliveryDate") == DBNull.Value then
txtETA.Text = ""
else
txtETA.Text = CType( drMain.Item("EstimatedDeliveryDate" ),
DateTime).ToShortDateString()
end if

"djc" <no***@nowhere.com> wrote in message
news:Oj**************@TK2MSFTNGP15.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 .ToShortDateString() function like so:
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring() 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
.ToShortDateString() function.

any input would be appreciated. Thanks!

[djc]

ok. Thank you.

"William F. Robertson, Jr." <theman_at_fdrsucks.com> wrote in message
news:uZ**************@TK2MSFTNGP14.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("EstimatedDeliveryDate") == DBNull.Value then
txtETA.Text = ""
else
txtETA.Text = CType( drMain.Item("EstimatedDeliveryDate" ),
DateTime).ToShortDateString()
end if

"djc" <no***@nowhere.com> wrote in message
news:Oj**************@TK2MSFTNGP15.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 .ToShortDateString() function like so:
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring()

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
.ToShortDateString() function.

any input would be appreciated. Thanks!

[djc]

ok. Thank you.

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:eP**************@TK2MSFTNGP12.phx.gbl...

Do a null check around it.

if(drMain.Item("EstimatedDeliveryDate") != null)
{
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring() ;
}
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**************@TK2MSFTNGP15.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 .ToShortDateString() function like so:
txtETA.Text = drMain.Item("EstimatedDeliveryDate").ToShortDateSt ring()
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
.ToShortDateString() function.

any input would be appreciated. Thanks!