Hello, Ankit!
AA> i had to insert date and time in application
AA> there are two ways i know
AA> one to take from c# code behind System.datetime.now()
AA> and other directly take in database in stored procedure using getdate()
AA> which one is more better,i will use one across my whole application
For application wide usage System.DateTime.Now is sufficient, and it will be much faster to get that date.
OTOH if you're saving data to db, you can use getdate from within stored proc or query and not specify it when constructing query.
--
Regards, Vadym Stetsyak
www:
http://vadmyst.blogspot.com