Hi all,

I have a datetime field in my database.I am showing the values of the table in datagrid in asp.net2.0.now the value displayed is date with time.But i want only the date should be displayed in d grid.So can anyone give me a quick reply in half an hour?
:)

Write following code in DataGrid_ItemDataBound event:

DateTime dt = Convert.ToDateTime(e.Item.Cells[5].Text);
string smallDate = dt.ToShortDateString();
e.Item.Cells[5].Text = smallDate;

Cheers!

actually my datatype is in smalldatetime.so can u plz giv a quick reply to it?

No problem. The above code will work with smalldatetime(database type) also.