Click here to Skip to main content
15,936,119 members
Home / Discussions / C#
   

C#

 
QuestionError : Method name expected // how do I fix this error. please Pin
Member 1074342211-Jul-14 17:47
Member 1074342211-Jul-14 17:47 
AnswerRe: Error : Method name expected // how do I fix this error. please Pin
Richard.Berry10011-Jul-14 19:19
Richard.Berry10011-Jul-14 19:19 
SuggestionRe: Error : Method name expected // how do I fix this error. please Pin
Richard MacCutchan11-Jul-14 21:36
mveRichard MacCutchan11-Jul-14 21:36 
QuestionWhy Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
arvind mepani11-Jul-14 4:42
arvind mepani11-Jul-14 4:42 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Retro61711-Jul-14 5:11
Retro61711-Jul-14 5:11 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Richard MacCutchan11-Jul-14 5:19
mveRichard MacCutchan11-Jul-14 5:19 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Richard Deeming11-Jul-14 5:21
mveRichard Deeming11-Jul-14 5:21 
AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
OriginalGriff11-Jul-14 5:55
mveOriginalGriff11-Jul-14 5:55 
The major problem is that SQL doesn't have a clue where the date is coming from: it is nearly always running on a different computer from the code that sent the date to the DB, and probably the user entered it on a third computer!
So what is is supposed to do with:
12/11/10
SQL doesn't have any access to cultural information about how the user is likely to have intended that, so it doesn't know if the year is 1912, 2012, 1911, 2011, 1910, or 2010 - or some other date system altogether, given that in the Iranian calendar (also known as Persian calendar or the Jalaali Calendar) this year is 1389, but it's year starts around 21st March in the Gregorian calender which complicates thinges even further.

Since is can't get it right - or even make an educated guess - it doesn't try. It expects you to do teh work for it, and either present it with a date in DateTime format already from your external code, or in ISO format: yyyy-MM-dd HH:mm:ss
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

AnswerRe: Why Sql server don't convert dateformat (dd-mm-yyyy) or (yyyy-dd-mm) ? Pin
Bernhard Hiller13-Jul-14 21:45
Bernhard Hiller13-Jul-14 21:45 
QuestionILnumerics illustrate 3D coordinates Pin
gzax11-Jul-14 3:47
gzax11-Jul-14 3:47 
AnswerRe: ILnumerics illustrate 3D coordinates Pin
OriginalGriff11-Jul-14 3:56
mveOriginalGriff11-Jul-14 3:56 
QuestionCrystal Report Runtime command line Pin
Amr Muhammed11-Jul-14 3:33
Amr Muhammed11-Jul-14 3:33 
AnswerRe: Crystal Report Runtime command line Pin
Eddy Vluggen11-Jul-14 7:16
professionalEddy Vluggen11-Jul-14 7:16 
QuestionPass byte.TryParse() or int.tryParse() as argument Pin
Mc_Topaz11-Jul-14 1:03
Mc_Topaz11-Jul-14 1:03 
AnswerRe: Pass byte.TryParse() or int.tryParse() as argument Pin
Richard Deeming11-Jul-14 1:29
mveRichard Deeming11-Jul-14 1:29 
GeneralRe: Pass byte.TryParse() or int.tryParse() as argument Pin
Mc_Topaz11-Jul-14 1:45
Mc_Topaz11-Jul-14 1:45 
Questionwhat exactly below code do Pin
anil42010-Jul-14 21:24
anil42010-Jul-14 21:24 
SuggestionRe: what exactly below code do Pin
Hemant Singh Rautela10-Jul-14 21:33
professionalHemant Singh Rautela10-Jul-14 21:33 
AnswerRe: what exactly below code do Pin
OriginalGriff10-Jul-14 21:39
mveOriginalGriff10-Jul-14 21:39 
SuggestionRe: what exactly below code do Pin
ZurdoDev11-Jul-14 1:47
professionalZurdoDev11-Jul-14 1:47 
QuestionC# insert command error Pin
PJeffrey10-Jul-14 16:11
PJeffrey10-Jul-14 16:11 
AnswerRe: C# insert command error Pin
Dave Kreskowiak10-Jul-14 18:20
mveDave Kreskowiak10-Jul-14 18:20 
AnswerRe: C# insert command error Pin
jldavis515-Jul-14 8:13
jldavis515-Jul-14 8:13 
QuestionPrivate chat Pin
Member 1076298010-Jul-14 11:15
Member 1076298010-Jul-14 11:15 
AnswerRe: Private chat Pin
Dave Kreskowiak10-Jul-14 12:11
mveDave Kreskowiak10-Jul-14 12:11 

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.