Click here to Skip to main content
15,749,279 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Exe File encoding - http via vb.net Pin
jschell4-Apr-23 6:19
jschell4-Apr-23 6:19 
AnswerRe: Exe File encoding - http via vb.net Pin
jschell3-Apr-23 6:09
jschell3-Apr-23 6:09 
QuestionBad Programming??... Pin
FreakNeck71631-Mar-23 4:09
FreakNeck71631-Mar-23 4:09 
AnswerRe: Bad Programming??... Pin
Richard Deeming31-Mar-23 4:59
mveRichard Deeming31-Mar-23 4:59 
AnswerRe: Bad Programming??... Pin
Gerry Schmitz31-Mar-23 6:49
mveGerry Schmitz31-Mar-23 6:49 
AnswerRe: Bad Programming??... Pin
Dave Kreskowiak31-Mar-23 12:08
mveDave Kreskowiak31-Mar-23 12:08 
AnswerRe: Bad Programming??... Pin
jschell3-Apr-23 6:42
jschell3-Apr-23 6:42 
AnswerRe: Bad Programming??... Pin
Valley Kid31-Aug-23 19:37
Valley Kid31-Aug-23 19:37 
QuestionUpdate Settings in Winows Forms project Pin
Ron Mittelman27-Mar-23 8:06
Ron Mittelman27-Mar-23 8:06 
AnswerRe: Update Settings in Winows Forms project Pin
Gerry Schmitz27-Mar-23 11:48
mveGerry Schmitz27-Mar-23 11:48 
GeneralRe: Update Settings in Winows Forms project Pin
Ron Mittelman27-Mar-23 12:34
Ron Mittelman27-Mar-23 12:34 
GeneralRe: Update Settings in Winows Forms project Pin
Gerry Schmitz28-Mar-23 7:06
mveGerry Schmitz28-Mar-23 7:06 
GeneralRe: Update Settings in Winows Forms project Pin
Ron Mittelman28-Mar-23 11:57
Ron Mittelman28-Mar-23 11:57 
AnswerRe: Update Settings in Winows Forms project Pin
Ron Mittelman28-Mar-23 11:47
Ron Mittelman28-Mar-23 11:47 
GeneralRe: Update Settings in Winows Forms project Pin
Gerry Schmitz28-Mar-23 13:04
mveGerry Schmitz28-Mar-23 13:04 
QuestionASP.NET Core on Linux Web Space Pin
temuco24-Mar-23 3:05
professionaltemuco24-Mar-23 3:05 
AnswerRe: ASP.NET Core on Linux Web Space Pin
jschell27-Mar-23 6:43
jschell27-Mar-23 6:43 
AnswerRe: ASP.NET Core on Linux Web Space Pin
BillWoodruff30-May-23 18:56
professionalBillWoodruff30-May-23 18:56 
GeneralRe: ASP.NET Core on Linux Web Space Pin
temuco30-May-23 23:06
professionaltemuco30-May-23 23:06 
QuestionMy code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie12-Mar-23 19:53
Ihechi Alozie12-Mar-23 19:53 
AnswerRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Pete O'Hanlon13-Mar-23 0:38
subeditorPete O'Hanlon13-Mar-23 0:38 
Out of interest, I took a look at your code. Honestly, that's going to be almost impossible for someone else to solve in its current form. Some of the things you should look at, to make it more readable.

  1. Actually use SQL Parameters properly. Right now, you're creating sql parameters, but you are injecting the values directly into your SQL statements - this means you are open for SQL Injection attacks
  2. Break the logic up into smaller chunks - that code is far too long to understand
  3. Close your connections when you're finished with them. You are going to hit issues very quickly if you don't.
  4. You're issuing insert statements that are using a value of -1 inserted records to determine whether or not a record is a duplicate. Rather than doing this, you should actually use real duplicate checks. You should use something like IF NOT EXISTS (SELECT ....) INSERT INTO ...., but be aware that it is technically possible to still get duplicates if you encounter race conditions.



modified 13-Mar-23 7:27am.

GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie13-Mar-23 3:58
Ihechi Alozie13-Mar-23 3:58 
AnswerRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Gerry Schmitz13-Mar-23 7:24
mveGerry Schmitz13-Mar-23 7:24 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie13-Mar-23 7:37
Ihechi Alozie13-Mar-23 7:37 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Gerry Schmitz13-Mar-23 9:24
mveGerry Schmitz13-Mar-23 9:24 

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.