formatting date in gridview [modified]

[kubben]

If you are using the Eval method of binding it looks like this: <%# Eval("Date", "{0:d}")%>, If you are using a boundfield it looks like this: Finally if you use a DataBinderEval (that is what I suggest) You have this: <%# DataBinder.Eval(Container.DataItem,"Date").ToString("dd/MMM/yyyy") %> The other two options you really can't give it the dd/MMM/yyyy format. Hope that helps. Ben

[Kunal P]

kubben wrote:

Finally if you use a DataBinderEval (that is what I suggest) You have this: <%# DataBinder.Eval(Container.DataItem,"Date").ToString("dd/MMM/yyyy") %>

hey i tried wat you said on the page load event i wrote this DataBinder.Eval(GridView1.Columns[10], "Date").ToString("dd/MMM/yy"); i couldnt get wat COntainer.dataitem meant.. there wasnt any optio for the same.. i used columns[10], since the date column was the 10th including 0.. but i get an error.. tostring only takes 1 argument.. please help

Kunal Piyush

[kubben]

In the gridview. You need to convert the column you want the date in to be an ItemTemplate. In the ItemTemplate you need a Label control. In the Text property of the Label control you need to put the this: <%# DataBinder.Eval(Container.DataItem,"Date").ToString("dd/MMM/yyyy") %> The page load event is not the correct place to put this code. So if you look at your gridview in the HTML mode you will find the <Columns> node YOu need code like this: <Columns> asp:TemplateField <ItemTemplate> <asp:Label ID="lbDate" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Date").ToString("dd/MMM/yyyy") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> NOTE the Date that comes right after the Container.DataItem is what ever your are calling your date field. Hope that helps. Ben

[Kunal P]

this is wat i did.. still that error.. Error 1 No overload for method 'ToString' takes '1' arguments C:\Documents and Settings\Kunal\My Documents\Visual Studio 2005\WebSites\diag\User\viewalldoc.aspx 25 Kunal Piyush

[kubben]

Sorry I missed on thing: '<%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem,"Dt")).ToString("dd/MMM/yyyy") %>' That should work. Thanks, Ben

[Kunal P]

hey now the program is compiling.. but again 1 problem. when the grid is displayed the "Dt" column shows the whole HTML tag, instead of the date. i am using VISUAL WEB DEVELOPER EXPRESS 2005.. is is a problem of obsolete tag.

Kunal Piyush

[kubben]

I am guessing there is an unbalanced quote or something. Include the code and I will see if I can see anything wrong with it. Ben

[Kunal P]

i am including the code.. though there shud have been an error regardin an unbalanced tag.. but still Kunal Piyush

[kubben]

Your code: Text='<%Convert.ToDateTime(DataBinder.Eval(Gridview1.DataItem,"Dt")).ToString("dd/MMM/yyyy"))%>' Needs to be: Text='<%# Convert.ToDateTime(DataBinder.Eval(Gridview1.DataItem,"Dt")).ToString("dd/MMM/yyyy"))%>' That should do it. Ben

[Kunal P]

hey ben thanks a lot.. problem solved.. thanks again..

Kunal Piyush

[kubben]

Sorry it took so long. Ben

[Kunal P]

hey.. i need to be sorry... didnt take in consideration about the brackets.. also.. why did we use "container" keyword.. we were using a gridview..

Kunal Piyush

[kubben]

In this case the Container is referring to the Dataset or dataTable or dataview that is bound to the gridview. When you use DataBinder.Eval you always have to use container.dataitem and then pass in the field you are looking for. The Bind method does the same thing it is just behind the scenes. Ben