Visual Basic 2005 Database Programming RRS feed

  • Question

  • how do I prevent duplicate records from being entered in sql server 2005 database using visual basic 2005 code?
    • Moved by Cindy Meister MVP Tuesday, May 18, 2010 10:13 AM not VSTO-related (From:Visual Studio Tools for Office)
    Tuesday, May 18, 2010 9:10 AM


  • Hi Emmanuel,

    Depends on the database schema you can tackle it by adding Primary Key to the table in the database, or you can perform query to the data (from the VB code) before inserting to the database.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Ferry Meidianto | My Blog
    Wednesday, May 19, 2010 10:51 AM