Formatting a date in a gridview with auto-generated fields

[BillE]

I am populating a gridview using auto-generated fields, because I need to
enable sorting.

I would like to format a column containing dates in the gridview.

How is this done?

Thanks
Bill

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Hi there Billie,

you have to handle RowDataBound event
-- aspx page --

<asp:GridView runat="server" ID="gridView"
AutoGenerateColumns="true"
OnRowDataBound="gridView_RowDataBound">

-- end aspx page --
-- code beside --

protected void gridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRow row = ((DataRowView)e.Row.DataItem).Row;

int index = GetDateColumnIndex(row);

e.Row.Cells[index].Text = ((DateTime)
row[index]).ToString("dd/MM/yyyyyyyy-MM-dd");
}
}

private int dateColumnIndex = -1;
private int GetDateColumnIndex(DataRow row)
{
if (this.dateColumnIndex == -1)
{
this.dateColumnIndex =
row.Table.Columns.IndexOf("ItemRecieved");

if (dateColumnIndex < 0)
{
throw new Exception(
"datasource does not contain the MyDateColumn column");
}
}
return this.dateColumnIndex;
}

-- end code beside --
Hope this helps

--
Milosz
"BillE" wrote:

I am populating a gridview using auto-generated fields, because I need to
enable sorting.

I would like to format a column containing dates in the gridview.

How is this done?

Thanks
Bill

[BillE]

Thank you kindly.

"Milosz Skalecki [MCAD]" <mi*****@DONTLIKESPAMwp.plwrote in message
news:A4**********************************@microsof t.com...

Hi there Billie,

you have to handle RowDataBound event
-- aspx page --

<asp:GridView runat="server" ID="gridView"
AutoGenerateColumns="true"
OnRowDataBound="gridView_RowDataBound">

-- end aspx page --
-- code beside --

protected void gridView_RowDataBound(object sender, GridViewRowEventArgs
e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRow row = ((DataRowView)e.Row.DataItem).Row;

int index = GetDateColumnIndex(row);

e.Row.Cells[index].Text = ((DateTime)
row[index]).ToString("dd/MM/yyyyyyyy-MM-dd");
}
}

private int dateColumnIndex = -1;
private int GetDateColumnIndex(DataRow row)
{
if (this.dateColumnIndex == -1)
{
this.dateColumnIndex =
row.Table.Columns.IndexOf("ItemRecieved");

if (dateColumnIndex < 0)
{
throw new Exception(
"datasource does not contain the MyDateColumn column");
}
}
return this.dateColumnIndex;
}

-- end code beside --
Hope this helps

--
Milosz
"BillE" wrote:

>I am populating a gridview using auto-generated fields, because I need to
enable sorting.

I would like to format a column containing dates in the gridview.

How is this done?

Thanks
Bill