Click here to Skip to main content
14,484,721 members

.NET Framework

 
QuestionBest practice connecting to database Pin
A_Griffin5-Aug-17 23:58
MemberA_Griffin5-Aug-17 23:58 
AnswerRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 0:44
professionalEddy Vluggen6-Aug-17 0:44 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 0:55
MemberA_Griffin6-Aug-17 0:55 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 1:06
professionalEddy Vluggen6-Aug-17 1:06 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 4:41
MemberA_Griffin6-Aug-17 4:41 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 4:49
professionalEddy Vluggen6-Aug-17 4:49 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:10
MemberA_Griffin6-Aug-17 5:10 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:19
professionalEddy Vluggen6-Aug-17 5:19 
A_Griffin wrote:
Yes, thanks - it says nothing there about how (or even if one can) combine multiple such statements into one.
It does, even comes with an example - and a note it might be unsafe.

A_Griffin wrote:
And why, out of interest, would you never use it?
Because I could not longer guarantee the integrity of the database, which is rather important to me.

What is your key? Let's take a VARCHAR(10) as an example key. There's already an entry "test" in your DB, and the same key occurs in your import-set 15 times. Which of those would you reckon to be the correct one? Which one do you think will be inserted? That may lead to some inconsistencies in a replication-scenario.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

AnswerRe: Best practice connecting to database Pin
Gerry Schmitz6-Aug-17 4:16
mveGerry Schmitz6-Aug-17 4:16 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 4:44
professionalEddy Vluggen6-Aug-17 4:44 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 4:48
MemberA_Griffin6-Aug-17 4:48 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:08
professionalEddy Vluggen6-Aug-17 5:08 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:18
MemberA_Griffin6-Aug-17 5:18 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:36
professionalEddy Vluggen6-Aug-17 5:36 
GeneralRe: Best practice connecting to database Pin
Gerry Schmitz9-Aug-17 7:31
mveGerry Schmitz9-Aug-17 7:31 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen9-Aug-17 8:25
professionalEddy Vluggen9-Aug-17 8:25 
QuestionHow to get each items "valuemember" value of checkedlistbox using for loop and show it in messagebox in winform Pin
bhagyashri from kolhapur19-Jul-17 2:33
Memberbhagyashri from kolhapur19-Jul-17 2:33 
AnswerRe: How to get each items "valuemember" value of checkedlistbox using for loop and show it in messagebox in winform Pin
Richard MacCutchan19-Jul-17 4:56
mveRichard MacCutchan19-Jul-17 4:56 
QuestionOne Wier library for VB.NET Pin
Member 1218072911-Jul-17 23:47
MemberMember 1218072911-Jul-17 23:47 
AnswerRe: One Wier library for VB.NET Pin
Afzaal Ahmad Zeeshan12-Jul-17 0:30
mvaAfzaal Ahmad Zeeshan12-Jul-17 0:30 
GeneralRe: One Wier library for VB.NET Pin
Member 1218072920-Jul-17 6:01
MemberMember 1218072920-Jul-17 6:01 
QuestionMVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi5-Jul-17 23:55
MemberAzza ALbelushi5-Jul-17 23:55 
AnswerRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 1:22
mveRichard Deeming6-Jul-17 1:22 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 2:49
MemberAzza ALbelushi6-Jul-17 2:49 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 2:52
mveRichard Deeming6-Jul-17 2:52 

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.