check for duplicate data

Question

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

viviansm · Answer

Hi DotNetLover  Thank you very much for your reply. Please give me more help in the coding. I still cannot solved the problems. Many thanks and best regards Vivian

Adam Erstelle · Answer

In your table create a restraint on the column that you do not want duplicates. Catch the error you may receive when adding a record and the database rejects the changes.

akbhattacharya · Answer

Hi Vivian its really simple. Try my earlier posts.... http://216.26.160.137/Forums/AspNetForums20/ShowPost.aspx?PostID=8121 if you need more help... just let me know... Baan