.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Doubt in Date/time

Posted By: Suresh     Posted Date: January 25, 2009    Points:2   Category :ASP.Net
im having sql2000 database, in that one field name is (dt), which type is datetime. In that i need extract the date and time sepertately. and how can i display the date and time seperately in gridview.could u help me out to resolve this problem.

Responses
Author: Praveen             
Posted Date: January 26, 2009     Points: 5   

Hi

To Get the value from Database and in the front end try like this

to get the Date only


string dateOnly = Convert.ToDateTime(ds.Tables[0].Rows[0]["DateTimeColumn"]).ToString("dd/MM/yyyy"); //this will give you date

To get the time only
string timeOnly = Convert.ToDateTime(ds.Tables[0].Rows[0]["DateTimeColumn"]).ToString("hh:mm:ss"); //this will give you time


Note : ds is DataSet in the above code you use other data source

Happy Coding
Praveen!!!



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend