Insert only unique value in table through vb.net application

Question

Hi,

I am using vb.net code and sql server 2005.

I have textbox in my application which is linked to a sql column. Now I want to check that it should not insert any duplicate record in table. I mean everytime it insert in table the value should be unique. data is inserted in table on button click.

I am using objectdatasource for sql connectivity and FormView for dataentry.

Please suggest! with some example code!

Thanks.

Best Regards, MS

Answer 1

The simplest solution is probably to add a unique constraint to your table. If you then try to insert a duplicate item, you will get an exception that you can catch and handle.

The cleaner solution is to add the unique constraint and query the database for the item you want to insert. If it is already there, do nothing, else perform the insert.

Answer 2

If the column you are talking about is of type Integer then you can set it to primary key and then use the property of that column , set the identity to true and set identity seed and Identity increment to 1 1 , you don't need to insert that value hope this will help.