Click here to Skip to main content
15,909,039 members
Home / Discussions / C#
   

C#

 
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...

AnswerRe: C# windows forms With MS SQL DataBase Pin
Pete O'Hanlon7-Sep-16 1:16
mvePete O'Hanlon7-Sep-16 1:16 
QuestionCreate a static class to return properties Pin
Mycroft Holmes6-Sep-16 22:02
professionalMycroft Holmes6-Sep-16 22:02 
AnswerRe: Create a static class to return properties Pin
#realJSOP7-Sep-16 1:19
professional#realJSOP7-Sep-16 1:19 
AnswerRe: Create a static class to return properties Pin
Pete O'Hanlon7-Sep-16 2:10
mvePete O'Hanlon7-Sep-16 2:10 
GeneralRe: Create a static class to return properties Pin
Mycroft Holmes7-Sep-16 2:48
professionalMycroft Holmes7-Sep-16 2:48 
AnswerRe: Create a static class to return properties Pin
Richard Deeming7-Sep-16 2:17
mveRichard Deeming7-Sep-16 2:17 
GeneralRe: Create a static class to return properties Pin
BillWoodruff7-Sep-16 5:08
professionalBillWoodruff7-Sep-16 5:08 
GeneralRe: Create a static class to return properties Pin
Richard Deeming7-Sep-16 6:59
mveRichard Deeming7-Sep-16 6:59 
Questionhow to add localdb in console apps using vs2013 Pin
Tridip Bhattacharjee5-Sep-16 23:18
professionalTridip Bhattacharjee5-Sep-16 23:18 

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.