Member Avatar for Joy_3

Hi Guys,
I am trying to make a webpage using asp.net and SQL server 2008.
Just a simple page through which data will be inserted to the database. But I noticed it is taking duplicate records as wel. So I used "Unique" constraint while the respective table and it is working fine.
But I wanted to show an error message which says "DATA already exists" after I am clicking the Insert button on the page.
Is it possible to check for duplicate entries and show the result while we are inserting data to a database?

Please help with a code snippet.

Thanks in advance.

Regards.

  • 2 Contributors
  • 2 Replies
  • 290 Views
  • 51 Minutes Discussion Span
  • Latest Post Latest Post by Joy_3
Member Avatar for jacks009

Great post and good post.

Member Avatar for Joy_3

Thank you . But any help regarding how can I validate duplicate records while inserting data?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.