Click here to Skip to main content
15,913,669 members
Home / Discussions / C#
   

C#

 
GeneralRe: Close when made inactive Pin
will kirkby12-Jan-10 8:44
will kirkby12-Jan-10 8:44 
AnswerRe: Close when made inactive Pin
#realJSOP13-Jan-10 0:26
professional#realJSOP13-Jan-10 0:26 
QuestionCreate mail acount in exchange server Pin
zeeShan anSari12-Jan-10 4:53
zeeShan anSari12-Jan-10 4:53 
QuestionBring Custom Control Ahead of form Pin
amitsol12-Jan-10 3:34
amitsol12-Jan-10 3:34 
AnswerRe: Bring Custom Control Ahead of form Pin
Saksida Bojan12-Jan-10 6:32
Saksida Bojan12-Jan-10 6:32 
AnswerRe: Bring Custom Control Ahead of form Pin
Eddy Vluggen12-Jan-10 8:16
professionalEddy Vluggen12-Jan-10 8:16 
QuestionDateTime Problem Pin
Thaer Hamael12-Jan-10 2:24
Thaer Hamael12-Jan-10 2:24 
AnswerRe: DateTime Problem Pin
OriginalGriff12-Jan-10 2:33
mveOriginalGriff12-Jan-10 2:33 
Without seeing your code, it is difficult to tell.

Best guess is that you are storing the date as a string, the format of which is local to your region and / or culture. SQL databases use an internal format of "YYYY-MM-DD" and are culture invariant.

Do not keep your date as a string - store it in a DateTime and pass that to the SQL directly. Convert it to a display string as late as possible, and convert from a string as soon as possible. Not only is it more efficient in terms of space, but you can easitly perform operations such as comparisons, additions, etc. which you cannot with a string.

All those who believe in psycho kinesis, raise my hand.

AnswerRe: DateTime Problem Pin
Luc Pattyn12-Jan-10 5:35
sitebuilderLuc Pattyn12-Jan-10 5:35 
AnswerRe: DateTime Problem Pin
Dan Mos12-Jan-10 7:46
Dan Mos12-Jan-10 7:46 
QuestionSerialization questions. Pin
David Muir12-Jan-10 1:50
David Muir12-Jan-10 1:50 
AnswerRe: Serialization questions. Pin
dojohansen12-Jan-10 7:01
dojohansen12-Jan-10 7:01 
QuestionHow can I subscribe to "DataGridView.CellDisplayRectangleUpdatedAfterDataGridViewScroll"-events? Pin
arnold_w12-Jan-10 1:44
arnold_w12-Jan-10 1:44 
AnswerRe: How can I subscribe to "DataGridView.CellDisplayRectangleUpdatedAfterDataGridViewScroll"-events? Pin
Saksida Bojan12-Jan-10 6:59
Saksida Bojan12-Jan-10 6:59 
GeneralRe: How can I subscribe to "DataGridView.CellDisplayRectangleUpdatedAfterDataGridViewScroll"-events? Pin
arnold_w12-Jan-10 21:40
arnold_w12-Jan-10 21:40 
Questionstring resizing Pin
Emmet_Brown12-Jan-10 1:31
Emmet_Brown12-Jan-10 1:31 
AnswerRe: string resizing Pin
harold aptroot12-Jan-10 1:34
harold aptroot12-Jan-10 1:34 
GeneralRe: string resizing Pin
Emmet_Brown12-Jan-10 1:38
Emmet_Brown12-Jan-10 1:38 
GeneralRe: string resizing Pin
Luc Pattyn12-Jan-10 1:53
sitebuilderLuc Pattyn12-Jan-10 1:53 
AnswerRe: string resizing Pin
Rick Shaub12-Jan-10 8:03
Rick Shaub12-Jan-10 8:03 
AnswerRe: string resizing Pin
carlecomm12-Jan-10 16:45
carlecomm12-Jan-10 16:45 
QuestionDeployment Project Pin
CT0013812-Jan-10 1:20
CT0013812-Jan-10 1:20 
Questiondelay in process Pin
sachees12312-Jan-10 1:11
sachees12312-Jan-10 1:11 
AnswerRe: delay in process Pin
Luc Pattyn12-Jan-10 1:56
sitebuilderLuc Pattyn12-Jan-10 1:56 
Questionwhich one will be faster? Pin
Joe Rozario12-Jan-10 0:29
Joe Rozario12-Jan-10 0:29 

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.