Click here to Skip to main content
15,884,960 members
Home / Discussions / C#
   

C#

 
AnswerRe: C# Pin
OriginalGriff28-Dec-17 21:37
mveOriginalGriff28-Dec-17 21:37 
AnswerRe: C# Pin
Dave Kreskowiak29-Dec-17 2:33
mveDave Kreskowiak29-Dec-17 2:33 
GeneralRe: C# Pin
OriginalGriff29-Dec-17 4:03
mveOriginalGriff29-Dec-17 4:03 
GeneralRe: C# Pin
Dave Kreskowiak29-Dec-17 4:13
mveDave Kreskowiak29-Dec-17 4:13 
Questionappend message in sql server Pin
Member 1320094428-Dec-17 6:43
Member 1320094428-Dec-17 6:43 
AnswerRe: append message in sql server Pin
Dave Kreskowiak28-Dec-17 7:22
mveDave Kreskowiak28-Dec-17 7:22 
GeneralRe: append message in sql server Pin
Member 1320094431-Dec-17 18:16
Member 1320094431-Dec-17 18:16 
GeneralRe: append message in sql server Pin
Dave Kreskowiak1-Jan-18 6:04
mveDave Kreskowiak1-Jan-18 6:04 
This is a really bad habit to get into.

SQL servers are normally terrible at string handling. Having the SQL server do this doesn't scale well and can lead to memory allocation inefficiencies and other problems on the server.

Also, not every client is going to want this error message coming back and may, instead, just want an error number. This is because of localization and globalization. You can't change the language the message is generated in if it's generated on the SQL server side.

It would be better if you had the client just INSERT one record at a time and have the client side build up it's own error message strings in the local language based on the returned error code from your procedure.

It also reduces the amount of traffic coming back from the SQL server, which is better for mobile applications.

System.ItDidntWorkException: Something didn't work as expected.
-- said no compiler, ever.

C# - How to debug code[^].
Seriously, go read this article.

Dave Kreskowiak

QuestionC# Ado.net Pin
komal patil28-Dec-17 5:49
komal patil28-Dec-17 5:49 
AnswerRe: C# Ado.net Pin
OriginalGriff28-Dec-17 5:53
mveOriginalGriff28-Dec-17 5:53 
AnswerRe: C# Ado.net Pin
PIEBALDconsult28-Dec-17 11:43
mvePIEBALDconsult28-Dec-17 11:43 
QuestionMessageBoxManager .dll using Pin
ormonds27-Dec-17 20:59
ormonds27-Dec-17 20:59 
AnswerRe: MessageBoxManager .dll using Pin
Pete O'Hanlon27-Dec-17 22:02
mvePete O'Hanlon27-Dec-17 22:02 
AnswerRe: MessageBoxManager .dll using Pin
ormonds28-Dec-17 9:56
ormonds28-Dec-17 9:56 
GeneralRe: MessageBoxManager .dll using Pin
BillWoodruff29-Dec-17 14:51
professionalBillWoodruff29-Dec-17 14:51 
AnswerRe: MessageBoxManager .dll using Pin
BillWoodruff29-Dec-17 14:56
professionalBillWoodruff29-Dec-17 14:56 
QuestionIssue while parsing HTML string in C# Pin
Mateen1127-Dec-17 18:59
Mateen1127-Dec-17 18:59 
AnswerRe: Issue while parsing HTML string in C# Pin
OriginalGriff27-Dec-17 20:05
mveOriginalGriff27-Dec-17 20:05 
QuestionExtracting a node from Json File in C# Pin
Sandeep Vemulapalli27-Dec-17 11:10
Sandeep Vemulapalli27-Dec-17 11:10 
AnswerRe: Extracting a node from Json File in C# Pin
Nathan Minier28-Dec-17 1:52
professionalNathan Minier28-Dec-17 1:52 
QuestionC # + Regex help (for a newbie) Pin
Damian Bz27-Dec-17 4:16
Damian Bz27-Dec-17 4:16 
AnswerRe: C # + Regex help (for a newbie) Pin
OriginalGriff27-Dec-17 5:00
mveOriginalGriff27-Dec-17 5:00 
GeneralRe: C # + Regex help (for a newbie) Pin
Nathan Minier27-Dec-17 6:10
professionalNathan Minier27-Dec-17 6:10 
GeneralRe: C # + Regex help (for a newbie) Pin
OriginalGriff27-Dec-17 6:23
mveOriginalGriff27-Dec-17 6:23 
GeneralRe: C # + Regex help (for a newbie) Pin
Nathan Minier27-Dec-17 6:34
professionalNathan Minier27-Dec-17 6:34 

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.