3
Answers

check for duplicate data

viviansm

viviansm

20y
1.8k
1
Greeting from Malaysia hi, i am a beginner in VB.NET. How do I check the duplicate records in the database? For example, I have a table called category in SQL server. This table contains with CategoryID and Category. In the front end I created a form that contains only 2 textbox. One is for the category ID that the ID is auto generated and the other textbox is for the user to enter the categoris(ed. adult, kids, comedy,.......) . So, how do I check if the user enters the category that already exists in the table. Please help! Have a nice day! Thanks and regards, Vivian
Answers (3)
0
Sujeet Singh
NA 129 0 7y
this is usually means one of two things:
  1. There is some very unusual code path which, when taken, always causes a crash
  2. A race condition exists between threads in your program. Thus, the crash appears unpredictably and may be difficult to reproduce

My advice to you is to start the program in the debugger, and leave it running until the exception is thrown. Then you can come back here and provide us with the relevant code, stack trace, debug output, etc.