Click here to Skip to main content
15,907,497 members
Home / Discussions / C#
   

C#

 
AnswerRe: Group Sequance patterns with Linq Pin
Gerry Schmitz9-Sep-16 13:30
mveGerry Schmitz9-Sep-16 13:30 
AnswerRe: Group Sequance patterns with Linq Pin
BillWoodruff10-Sep-16 2:34
professionalBillWoodruff10-Sep-16 2:34 
GeneralRe: Group Sequance patterns with Linq Pin
#realJSOP11-Sep-16 3:18
professional#realJSOP11-Sep-16 3:18 
GeneralRe: Group Sequance patterns with Linq Pin
BillWoodruff11-Sep-16 19:21
professionalBillWoodruff11-Sep-16 19:21 
Questionunable to bind json data in label Pin
Member 127294328-Sep-16 22:36
Member 127294328-Sep-16 22:36 
QuestionRe: unable to bind json data in label Pin
Richard MacCutchan8-Sep-16 22:40
mveRichard MacCutchan8-Sep-16 22:40 
AnswerRe: unable to bind json data in label Pin
Member 127294328-Sep-16 22:46
Member 127294328-Sep-16 22:46 
GeneralRe: unable to bind json data in label Pin
Richard MacCutchan8-Sep-16 22:53
mveRichard MacCutchan8-Sep-16 22:53 
AnswerRe: unable to bind json data in label Pin
Simon_Whale8-Sep-16 22:52
Simon_Whale8-Sep-16 22:52 
QuestionC# Website - PDF viewer to extract info Pin
NickyRamshaw8-Sep-16 3:12
NickyRamshaw8-Sep-16 3:12 
AnswerRe: C# Website - PDF viewer to extract info Pin
Nathan Minier8-Sep-16 5:49
professionalNathan Minier8-Sep-16 5:49 
QuestionRifidi connection Pin
Member 116390998-Sep-16 0:20
Member 116390998-Sep-16 0:20 
AnswerRe: Rifidi connection Pin
phil.o8-Sep-16 1:24
professionalphil.o8-Sep-16 1:24 
Generalhow to work on toggle button when two text fields in which we need one field require and save data and another second filed control toggle button. Pin
nadir malik7-Sep-16 21:45
nadir malik7-Sep-16 21:45 
GeneralRe: how to work on toggle button when two text fields in which we need one field require and save data and another second filed control toggle button. Pin
OriginalGriff7-Sep-16 21:58
mveOriginalGriff7-Sep-16 21:58 
Questionnoob need some help Pin
jimboo12327-Sep-16 7:31
jimboo12327-Sep-16 7:31 
AnswerRe: noob need some help Pin
OriginalGriff7-Sep-16 8:06
mveOriginalGriff7-Sep-16 8:06 
QuestionEntity Framework: How to migrate a change for specific table Pin
Tridip Bhattacharjee7-Sep-16 2:51
professionalTridip Bhattacharjee7-Sep-16 2:51 
AnswerRe: Entity Framework: How to migrate a change for specific table Pin
Dave Kreskowiak7-Sep-16 3:49
mveDave Kreskowiak7-Sep-16 3:49 
GeneralRe: Entity Framework: How to migrate a change for specific table Pin
Tridip Bhattacharjee12-Sep-16 21:39
professionalTridip Bhattacharjee12-Sep-16 21:39 
GeneralRe: Entity Framework: How to migrate a change for specific table Pin
Dave Kreskowiak13-Sep-16 2:34
mveDave Kreskowiak13-Sep-16 2:34 
QuestionC# windows forms With MS SQL DataBase Pin
Zeyad Jalil6-Sep-16 23:56
professionalZeyad Jalil6-Sep-16 23:56 
AnswerRe: C# windows forms With MS SQL DataBase Pin
Garth J Lancaster7-Sep-16 0:14
professionalGarth J Lancaster7-Sep-16 0:14 
GeneralRe: C# windows forms With MS SQL DataBase Pin
Zeyad Jalil7-Sep-16 0:17
professionalZeyad Jalil7-Sep-16 0:17 
AnswerRe: C# windows forms With MS SQL DataBase Pin
OriginalGriff7-Sep-16 0:46
mveOriginalGriff7-Sep-16 0:46 
If you want the actual server Date and Time value, then you have little choice but to use GETDATE() - that is the only way to get the server setting. You could "prefetch" it, but if the timestamp is important that's a bad idea and it could be out by seconds or more by the time you use it.
Or you could use GETUTCDATE() which returns a universal value rather than one based on the server locale settings.

If you don't want to call it directly, the other option is to add one of the two function calls as the default value for that column when you define the table - that way the system will set it for you if you don't specify it.

And please, use parameterised queries rather than passing any values as part of the SQL command string directly - you leave your application wide open to SQL Injection attacks if you don't.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

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.