Click here to Skip to main content
15,908,674 members
Home / Discussions / C#
   

C#

 
GeneralRe: error in query with 2 tables in c# visual studio 2010 Pin
Ravi Bhavnani4-Apr-13 11:50
professionalRavi Bhavnani4-Apr-13 11:50 
SuggestionRe: error in query with 2 tables in c# visual studio 2010 Pin
ROHIT SRIVASTAVA3-Apr-13 2:58
ROHIT SRIVASTAVA3-Apr-13 2:58 
Question1500x1500 image at 30fps on wpf Pin
Andreoli Carlo2-Apr-13 4:58
professionalAndreoli Carlo2-Apr-13 4:58 
AnswerRe: 1500x1500 image at 30fps on wpf Pin
Pete O'Hanlon2-Apr-13 5:24
mvePete O'Hanlon2-Apr-13 5:24 
GeneralRe: 1500x1500 image at 30fps on wpf Pin
Andreoli Carlo2-Apr-13 23:06
professionalAndreoli Carlo2-Apr-13 23:06 
GeneralRe: 1500x1500 image at 30fps on wpf Pin
Pete O'Hanlon2-Apr-13 23:39
mvePete O'Hanlon2-Apr-13 23:39 
QuestionSilent installation - Invalid Re-install mode character error Pin
sonia$cool2-Apr-13 3:57
sonia$cool2-Apr-13 3:57 
AnswerRe: Silent installation - Invalid Re-install mode character error Pin
Pete O'Hanlon2-Apr-13 6:07
mvePete O'Hanlon2-Apr-13 6:07 
GeneralRe: Silent installation - Invalid Re-install mode character error Pin
sonia$cool3-Apr-13 4:01
sonia$cool3-Apr-13 4:01 
GeneralRe: Silent installation - Invalid Re-install mode character error Pin
Pete O'Hanlon3-Apr-13 4:04
mvePete O'Hanlon3-Apr-13 4:04 
GeneralRe: Silent installation - Invalid Re-install mode character error Pin
sonia$cool3-Apr-13 4:24
sonia$cool3-Apr-13 4:24 
GeneralRe: Silent installation - Invalid Re-install mode character error Pin
Pete O'Hanlon3-Apr-13 4:32
mvePete O'Hanlon3-Apr-13 4:32 
GeneralRe: Silent installation - Invalid Re-install mode character error Pin
sonia$cool3-Apr-13 4:36
sonia$cool3-Apr-13 4:36 
Questionget datetime values from database in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format Pin
NarVish2-Apr-13 3:24
NarVish2-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 Pin
Hemant Singh Rautela2-Apr-13 3:41
professionalHemant Singh Rautela2-Apr-13 3:41 
GeneralRe: get datetime values from database in dd/MM/yyyy HH:mm:ss format irrespective of system date/time format Pin
NarVish2-Apr-13 19:55
NarVish2-Apr-13 19:55 
QuestionLeft click works right does not Pin
electriac2-Apr-13 0:29
electriac2-Apr-13 0:29 
QuestionRe: Left click works right does not Pin
Eddy Vluggen2-Apr-13 0:33
professionalEddy Vluggen2-Apr-13 0:33 
AnswerRe: Left click works right does not Pin
electriac2-Apr-13 0:39
electriac2-Apr-13 0:39 
AnswerRe: Left click works right does not Pin
electriac2-Apr-13 0:50
electriac2-Apr-13 0:50 
AnswerRe: Left click works right does not Pin
Richard MacCutchan2-Apr-13 2:14
mveRichard MacCutchan2-Apr-13 2:14 
GeneralRe: Left click works right does not Pin
electriac2-Apr-13 2:41
electriac2-Apr-13 2:41 
GeneralRe: Left click works right does not Pin
electriac2-Apr-13 2:45
electriac2-Apr-13 2:45 
GeneralRe: Left click works right does not Pin
Richard MacCutchan2-Apr-13 2:50
mveRichard MacCutchan2-Apr-13 2:50 
AnswerRe: Left click works right does not Pin
Bernhard Hiller2-Apr-13 21:26
Bernhard Hiller2-Apr-13 21:26 

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

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