ASP.NET - how to remove time part from date column in sql 2008

I have date column in sql 2008. When I retrive data from table it display datetime both. I need to remove time from this column in dd/MM/yyyy formate
column type is date.

Like:-- txtDate.TExt=25/09/2012.

DATEPART or do it in your .NET code as dateTime.ToString("MM/dd/yyyy");

Use DateTime.ToShortDateString() method it will give only date.

Pls  take a look at his
http://msdn.microsoft.com/en-us/library/ms187928.aspx