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

.NET (Core and Framework)

 
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
mvePete O'Hanlon13-Mar-23 0:38 
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 
Thank you very much for the pointers Pete, much appreciated.

For the first point you raised about sql injection attack, yes I forgot to explain that I did those intentionally so I could see what values are being passed to them when I try debugging the old fashioned way - using response.write().

I intent to use the sql parameters once I am able to work out all my issues with the code.

There are three questions at play here and I believe this is where I am having my issues.

1), Does this application already exist on our DB? If yes, is it to be returned (rejected).
2), Is this application we received to be returned and is the install address same as mailing address?
3), Is this application to be returned and is install address and mailing address different from each other.

If the answer to #1 is yes and no, then the user just updates the records
If the answer to #1 is yes and yes, then the user updates the records and also process it for return by inserting it into Returns table.
If the answer to #1 is no (record does not exist for this application). So, it is a new application but needs to be returned, then it is added to the all the tables I mentioned above as well as return table.
If the application is new and not a return, just add them to the three tables mentioned above.

We also have to process the application based on whether residential address is same as mailing address.

Unfortunately, if I was designing the DB, I won't be having this issue now because I would have two tables, one for residential address and the other for mailing address but unfortunately, here we are.

Very depressing to have to deal with this.

modified 13-Mar-23 11:08am.

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 
AnswerRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Eddy Vluggen13-Mar-23 9:37
professionalEddy Vluggen13-Mar-23 9:37 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Ihechi Alozie13-Mar-23 9:56
Ihechi Alozie13-Mar-23 9:56 
GeneralRe: My code keeps inserting duplicate records and I can't figure out why. Pin
Eddy Vluggen13-Mar-23 10:11
professionalEddy Vluggen13-Mar-23 10:11 
QuestionIs there a need for separate SignInManager<TUser> and UserManager<TUser>? Pin
hpjchobbes26-Feb-23 8:24
hpjchobbes26-Feb-23 8:24 
AnswerRe: Is there a need for separate SignInManager<TUser> and UserManager<TUser>? Pin
Dave Kreskowiak26-Feb-23 9:45
mveDave Kreskowiak26-Feb-23 9:45 
AnswerRe: Is there a need for separate SignInManager<TUser> and UserManager<TUser>? Pin
Sardar Mudassar Ali Khan SSE10-Mar-23 6:33
professionalSardar Mudassar Ali Khan SSE10-Mar-23 6:33 
QuestionVb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
sdfsdfsdfewrew3feff26-Feb-23 6:37
sdfsdfsdfewrew3feff26-Feb-23 6:37 
AnswerRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
Richard Deeming26-Feb-23 22:31
mveRichard Deeming26-Feb-23 22:31 
GeneralRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
sdfsdfsdfewrew3feff27-Feb-23 6:55
sdfsdfsdfewrew3feff27-Feb-23 6:55 
GeneralRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
Richard Deeming27-Feb-23 21:17
mveRichard Deeming27-Feb-23 21:17 
AnswerRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
Dave Kreskowiak27-Feb-23 3:14
mveDave Kreskowiak27-Feb-23 3:14 
GeneralRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
sdfsdfsdfewrew3feff27-Feb-23 8:36
sdfsdfsdfewrew3feff27-Feb-23 8:36 
AnswerRe: Vb.net FlowLayoutPanel with MS Access: System.InvalidCastException error. Pin
jschell13-Mar-23 6:30
jschell13-Mar-23 6:30 
QuestionXML view to display in grid view Pin
Member 1592502915-Feb-23 5:30
Member 1592502915-Feb-23 5:30 

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.