DataGrid binding

[Franck Diastein]

Hi,

I'm binding a DataRead (obtained from a mssql SP)to a DataGrid, and one
of the values is a date...

The problem is that date is shown as dd/mm/yyyy hh:mm:ss and I would
like to format it as dd/mm/yyyy...

How can I do it ?

I have seen some code using ItemDataBound event, but I can't manage to
apply them...

TIA

[Eliyahu Goldin]

OK, keep trying to apply ItemDataBound event. What is the problem? To format
date use DateTime.ToString (formatString) method with format string
"dd/mm/yyy".

Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:u4**************@TK2MSFTNGP14.phx.gbl...

Hi,

I'm binding a DataRead (obtained from a mssql SP)to a DataGrid, and one
of the values is a date...

The problem is that date is shown as dd/mm/yyyy hh:mm:ss and I would
like to format it as dd/mm/yyyy...

How can I do it ?

I have seen some code using ItemDataBound event, but I can't manage to
apply them...

TIA

[Franck Diastein]

My problem is that I can't find a sample for to retreive cell value and
reasign to it a new value...

Eliyahu Goldin wrote:

OK, keep trying to apply ItemDataBound event. What is the problem? To format
date use DateTime.ToString (formatString) method with format string
"dd/mm/yyy".

Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:u4**************@TK2MSFTNGP14.phx.gbl...

Hi,

I'm binding a DataRead (obtained from a mssql SP)to a DataGrid, and one
of the values is a date...

The problem is that date is shown as dd/mm/yyyy hh:mm:ss and I would
like to format it as dd/mm/yyyy...

How can I do it ?

I have seen some code using ItemDataBound event, but I can't manage to
apply them...

TIA

[Eliyahu Goldin]

OK, suppose your column 0 contains the date you want to convert.

private void dgSelection_ItemDataBound(object sender,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
ListItemType itemType = e.Item.ItemType;
if ((itemType == ListItemType.Pager) ||
(itemType == ListItemType.Header) ||
(itemType == ListItemType.Footer))
{
return;
}
e.Item.Cells[0].Text =
System.Convert.ToDateTime(e.Item.Cells[0].Text ).ToString("dd/mm/yyyy");
}
Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:Oi**************@TK2MSFTNGP11.phx.gbl...

My problem is that I can't find a sample for to retreive cell value and
reasign to it a new value...

Eliyahu Goldin wrote:

OK, keep trying to apply ItemDataBound event. What is the problem? To format date use DateTime.ToString (formatString) method with format string
"dd/mm/yyy".

Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:u4**************@TK2MSFTNGP14.phx.gbl...

Hi,

I'm binding a DataRead (obtained from a mssql SP)to a DataGrid, and one
of the values is a date...

The problem is that date is shown as dd/mm/yyyy hh:mm:ss and I would
like to format it as dd/mm/yyyy...

How can I do it ?

I have seen some code using ItemDataBound event, but I can't manage to
apply them...

TIA

[Franck Diastein]

OK, that's the code I need... This code give me error with datetime
converstion, but that's another story...

Thanx

Eliyahu Goldin wrote:

OK, suppose your column 0 contains the date you want to convert.

private void dgSelection_ItemDataBound(object sender,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
ListItemType itemType = e.Item.ItemType;
if ((itemType == ListItemType.Pager) ||
(itemType == ListItemType.Header) ||
(itemType == ListItemType.Footer))
{
return;
}
e.Item.Cells[0].Text =
System.Convert.ToDateTime(e.Item.Cells[0].Text ).ToString("dd/mm/yyyy");
}
Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:Oi**************@TK2MSFTNGP11.phx.gbl...

My problem is that I can't find a sample for to retreive cell value and
reasign to it a new value...

Eliyahu Goldin wrote:

OK, keep trying to apply ItemDataBound event. What is the problem? To
format
date use DateTime.ToString (formatString) method with format string
"dd/mm/yyy".

Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:u4**************@TK2MSFTNGP14.phx.gbl...
Hi,

I'm binding a DataRead (obtained from a mssql SP)to a DataGrid, and one
of the values is a date...

The problem is that date is shown as dd/mm/yyyy hh:mm:ss and I would
like to format it as dd/mm/yyyy...

How can I do it ?

I have seen some code using ItemDataBound event, but I can't manage to
apply them...

TIA

[Saravana]

Check out "Formatting Dates, Currency, and Other Data" section in this
article,
http://msdn.microsoft.com/library/de...verControl.asp

--
-Saravana
http://dotnetjunkies.com/WebLog/saravana/
www.ExtremeExperts.com
"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

OK, that's the code I need... This code give me error with datetime
converstion, but that's another story...

Thanx

Eliyahu Goldin wrote:

OK, suppose your column 0 contains the date you want to convert.

private void dgSelection_ItemDataBound(object sender,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
ListItemType itemType = e.Item.ItemType;
if ((itemType == ListItemType.Pager) ||
(itemType == ListItemType.Header) ||
(itemType == ListItemType.Footer))
{
return;
}
e.Item.Cells[0].Text =
System.Convert.ToDateTime(e.Item.Cells[0].Text ).ToString("dd/mm/yyyy");
}
Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:Oi**************@TK2MSFTNGP11.phx.gbl...

My problem is that I can't find a sample for to retreive cell value and
reasign to it a new value...

Eliyahu Goldin wrote:
OK, keep trying to apply ItemDataBound event. What is the problem? To

format

date use DateTime.ToString (formatString) method with format string
"dd/mm/yyy".

Eliyahu

"Franck Diastein" <fd*******@euskaltel.net> wrote in message
news:u4**************@TK2MSFTNGP14.phx.gbl...
>Hi,
>
>I'm binding a DataRead (obtained from a mssql SP)to a DataGrid, and one>of the values is a date...
>
>The problem is that date is shown as dd/mm/yyyy hh:mm:ss and I would
>like to format it as dd/mm/yyyy...
>
>How can I do it ?
>
>I have seen some code using ItemDataBound event, but I can't manage to
>apply them...
>
>TIA