ASP.NET 2.0 & SQL

[Scott L.]

I am trying to design a web form that will insert collected data into a sql database when the submit button is clicked. At the moment I have the results being e-mailed to someone who than manually enters the data into a database. I'm using Visual Web Developer 2008, SQL 2005, and ASP.Net 2.0 VB coding.:D

[Scott L.]

I am trying to design a web form that will insert collected data into a sql database when the submit button is clicked. At the moment I have the results being e-mailed to someone who than manually enters the data into a database. I'm using Visual Web Developer 2008, SQL 2005, and ASP.Net 2.0 VB coding.:D

Got that part working now. Have a new problem/ question.

How do I design a custom validator to check if a value typed in a particular field already exists in the database. Currently an error is returned about the PK already existing.:D