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

 

[Natty Gur]

Hi,

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

[1] -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref
/ts_ca-co_2f3o.asp

Natty Gur[MVP]
Phone Numbers:
Office: +972-(0)9-7740261
Fax: +972-(0)9-7740261
Mobile: +972-(0)58-888377