bind dates in datagrid in mm/dd/yyyy format..........,

[Member 3879881]

Hi in my datagrid i am binding the dates in one bound column..., Its display like mm/dd/yyyy 12:00:00 AM........,(7/1/2007 12:00:00 AM) But i like to show only mm/dd/yyyy only...,(7/1/2007) How to display like that...,

Regards, Magi

[gauthee]

assuming your are using sql server 2000 as database, in your select query write: convert(varchar, date_column_name, 101) this is one way!

Gautham

[Imran Khan Pathan]

Use <%# Eval("dateField","mm/dd/yyyy")%> In ItemTemplate Best regard Pathan

GOD HELP THOSE WHO HELP THEMSELVES

[Member 3879881]

Ya but what's that after column name y should want to give "101" ??????

Regards, Magi

[gauthee]

These are predefined formats to handle datetime values, for more info you can to your books online and in the index search press convert

Gautham

[Muhammad Waqas Butt]

How to change Datagrid Header Text through programming in C#.net. and how to set colunm width and height. How to format date in datagrid column. I'm using MS Access 2003 and i database date save in this format(7/11/2007) and I want to highlight row where cell fee value = 0;

|Muhamad Waqas Butt| waqasb4all@yahoo.com www.sktech.freewebspace.com