Click here to Skip to main content
       

C#

 
GeneralRe: error in query with 2 tables in c# visual studio 2010 PinmemberRavi Bhavnani4-Apr-13 11:50 
SuggestionRe: error in query with 2 tables in c# visual studio 2010 PinmemberROHIT SRIVASTAVA3-Apr-13 2:58 
Question1500x1500 image at 30fps on wpf Pinmemberbarbetto802-Apr-13 4:58 
AnswerRe: 1500x1500 image at 30fps on wpf PinprotectorPete O'Hanlon2-Apr-13 5:24 
GeneralRe: 1500x1500 image at 30fps on wpf Pinmemberbarbetto802-Apr-13 23:06 
GeneralRe: 1500x1500 image at 30fps on wpf PinprotectorPete O'Hanlon2-Apr-13 23:39 
QuestionSilent installation - Invalid Re-install mode character error Pinmembersonia$cool2-Apr-13 3:57 
AnswerRe: Silent installation - Invalid Re-install mode character error PinprotectorPete O'Hanlon2-Apr-13 6:07 
GeneralRe: Silent installation - Invalid Re-install mode character error Pinmembersonia$cool3-Apr-13 4:01 
GeneralRe: Silent installation - Invalid Re-install mode character error PinprotectorPete O'Hanlon3-Apr-13 4:04 
GeneralRe: Silent installation - Invalid Re-install mode character error Pinmembersonia$cool3-Apr-13 4:24 
GeneralRe: Silent installation - Invalid Re-install mode character error PinprotectorPete O'Hanlon3-Apr-13 4:32 
GeneralRe: Silent installation - Invalid Re-install mode character error Pinmembersonia$cool3-Apr-13 4:36 
Questionget datetime values from database in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format PinmemberNarVish2-Apr-13 3:24 
I run the below query in SQL server through C#.
 
SELECT ScheduleTime FROM test
 
I'm using SqlDataAdapter to fill the results in datatable. I'm getting "ScheduleTime" values from test table ("ScheduleTime" is datetime type). But the results are in system date time format.
For example, if my system Time format is "tt hh:mm:ss" in Long Time, the results are in the below format.
27-03-2013 PM 03:51:01
if my system Time format is "HH:mm:ss" in Long Time, the results are in the below format.
27-03-2013 15:51:01
 
I need to get the results in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format.
Please guide me to this. Thanks in advance.
AnswerRe: get datetime values from database in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format Pinmemberhemantrautela2-Apr-13 3:41 
GeneralRe: get datetime values from database in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format PinmemberNarVish2-Apr-13 19:55 
QuestionLeft click works right does not Pinmemberelectriac2-Apr-13 0:29 
QuestionRe: Left click works right does not PinmvpEddy Vluggen2-Apr-13 0:33 
AnswerRe: Left click works right does not Pinmemberelectriac2-Apr-13 0:39 
AnswerRe: Left click works right does not Pinmemberelectriac2-Apr-13 0:50 
AnswerRe: Left click works right does not PinmvpRichard MacCutchan2-Apr-13 2:14 
GeneralRe: Left click works right does not Pinmemberelectriac2-Apr-13 2:41 
GeneralRe: Left click works right does not Pinmemberelectriac2-Apr-13 2:45 
GeneralRe: Left click works right does not PinmvpRichard MacCutchan2-Apr-13 2:50 
AnswerRe: Left click works right does not PinmemberBernhard Hiller2-Apr-13 21:26 
AnswerRe: Left click works right does not Pinmemberraeeschaudhary2-Apr-13 21:41 
QuestionRead PDF PinmemberKevin Marois1-Apr-13 12:53 
AnswerRe: Read PDF PinmvpEddy Vluggen1-Apr-13 13:15 
GeneralRe: Read PDF PinmemberKevin Marois1-Apr-13 13:16 
GeneralRe: Read PDF PinmvpEddy Vluggen1-Apr-13 13:21 
AnswerRe: Read PDF PinmvpAbhinav S1-Apr-13 20:47 
QuestionFavorites from HTML PinmemberMAW301-Apr-13 12:15 
AnswerRe: Favorites from HTML PinmvpEddy Vluggen1-Apr-13 13:20 
QuestionOpenOffice API for DotNet PinmemberASPnoob1-Apr-13 6:45 
AnswerRe: OpenOffice API for DotNet PinmemberThePhantomUpvoter1-Apr-13 7:13 
QuestionEach page of report viewer contain single report(.rdlc) [modified] PinmemberM. K. BASHER1-Apr-13 2:23 
QuestionHow to use IWin32Window Pinmembermhd almidani31-Mar-13 23:31 
AnswerRe: How to use IWin32Window PinmvpEddy Vluggen1-Apr-13 0:03 
GeneralRe: How to use IWin32Window Pinmembermhd almidani1-Apr-13 5:09 
GeneralRe: How to use IWin32Window PinmemberAlan N1-Apr-13 5:24 
GeneralRe: How to use IWin32Window Pinmembermhd almidani1-Apr-13 20:35 
GeneralRe: How to use IWin32Window PinmvpEddy Vluggen1-Apr-13 11:34 
AnswerRe: How to use IWin32Window PinmvpRichard MacCutchan1-Apr-13 0:03 
QuestionCustom TabControl: Designer adds TabPages in wrong order! [modified] PinmemberRevolty31-Mar-13 9:33 
AnswerRe: Custom TabControl: Designer adds TabPages in wrong order! PinmemberRevolty7-Apr-13 5:18 
Questionكيف البحث عن ملفات محرر التسجيل Pinmemberreemaziz31-Mar-13 6:13 
AnswerRe: كيف البحث عن ملفات محرر التسجيل PinmemberKenneth Haugland31-Mar-13 6:49 
AnswerRe: كيف البحث عن ملفات محرر التسجيل PinmvpRichard MacCutchan31-Mar-13 8:02 
Questioninsatling mssql server 2008r2 PinmemberAshbinsapkota31-Mar-13 5:39 
AnswerRe: insatling mssql server 2008r2 PinprotectorPete O'Hanlon31-Mar-13 5:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 26 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid