it's urgent

deb_kareng · #1 (**permalink**) August 7th, 2007, 04:17 AM

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?
:)

gaurav_jain2403 · #2 (**permalink**) August 7th, 2007, 04:57 AM

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!

deb_kareng · #3 (**permalink**) August 7th, 2007, 05:12 AM

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

gaurav_jain2403 · #4 (**permalink**) August 7th, 2007, 07:40 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
urgent	deb_kareng	ASP.NET 2.0 Professional	1	August 13th, 2007 07:29 AM
urgent help	yash_coolbuddy_forindia	BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5	1	May 7th, 2007 08:40 AM
urgent help	wilsonxue	C#	1	July 12th, 2006 06:05 PM
urgent????????????	nsr35	Beginning VB 6	1	October 3rd, 2005 10:57 AM
urgent ???????????????	nsr35	Pro VB Databases	0	October 3rd, 2005 04:53 AM