Date format

[Barel Yoav]

When I bing data from SQL Servert DB to textbox it's display the date filed
with strange format.
How can I format the dates field when I bind dataset to a control ?

[Eliyahu Goldin]

Use data-binding expression with format string like this:

<asp:TextBox id=textBoxForDate runat="server" Text='<%#
DataBinder.Eval(myDataSet, "Tables[myTable].DefaultView.[0].BeginDate",
"{0:yyyy-MMMM-dd}") %>'></asp:TextBox>

Eliyahu

"Barel Yoav" <yo**@barel.co.il> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

When I bing data from SQL Servert DB to textbox it's display the date filed with strange format.
How can I format the dates field when I bind dataset to a control ?

[Natty Gur]

Hi,

You can use SQL server Convert function [1] to format the date as you
want.

[1] -
http://msdn.microsoft.com/library/de.../en-us/tsqlref
/ts_ca-co_2f3o.asp

Natty Gur[MVP]
Phone Numbers:
Office: [phone]
Fax: [phone]
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!