Hi there,
I prepared an example that you get you on the right track:
<script runat="server">
protected void Page_Load(objec t sender, EventArgs e)
{
gridView.DataSo urce = GetData();
gridView.DataBi nd();
}
private System.Data.Dat aTable GetData()
{
System.Data.Dat aTable table =
new System.Data.Dat aTable();
table.Columns.A dd("Id", typeof(int));
table.Columns.A dd("ItemRecieve d", typeof(DateTime ));
table.Columns.A dd("Difference" , typeof(TimeSpan ));
//t.ColumnChanged += new DataColumnChang eEventHandler(t _ColumnChanged) ;
table.ColumnCha nged +=
new System.Data.Dat aColumnChangeEv entHandler(tabl e_ColumnChanged );
for (int i = 0; i < 10; i++)
{
System.Data.Dat aRow row = table.NewRow();
row[0] = i;
row[1] = DateTime.Now.Ad dDays((double)i );
table.Rows.Add( row);
}
return table;
}
private void table_ColumnCha nged(object sender,
System.Data.Dat aColumnChangeEv entArgs e)
{
if (e.Column.Colum nName == "ItemReciev ed")
{
DateTime date = (DateTime)e.Row["ItemReciev ed"];
e.Row["Difference "] = DateTime.Now - date;
}
}
</script>
<asp:GridView runat="server" ID="gridView"
AutoGenerateCol umns="false">
<Columns>
<asp:BoundFie ld DataField="Id" />
<asp:BoundFie ld DataField="Item Recieved" />
<asp:BoundFie ld DataField="Diff erence"
DataFormatStrin g="{0:-d.hh:mm:ss}" />
</Columns>
</asp:GridView>
Hope this helps
--
Milosz
"bb****@yahoo.c om" wrote:
Hi,
I have a table which has a field ItemsReceived of type datetime. I
have a grid view which has two columns.
In first column i have to show the data from field ItemsReceived and
in second column I have to show
difference between Currenttime and date from ItemReceived. How can I
do that.
e'g
ItemRecieved Difference
6/13/2007 12:38am 1d 21h 45m
6/13/2007 3:54pm 1d 06h 10m
6/15/2007 12:26pm 34m
So the second coulmn displays the difference of current time minus
ItemRecieved. the format shouild be <mintues>m,
or<hours>h, <mintues>m, or <days>d.
How can I do that.
Thanks in advance