I have project where I am building an ASP.NET Internal Website that will run Updates, Selects, and Inserts on a SQL Server 2005 Database. There will be a series of forms that will call stored procedures rather than have embedded SQL.
I have limited knowledge of ASP.NET. What is the best way to create the stored procedure and call it through ASP.NET?
I would like to design the SP in such a way that I can do validation like, if the record already exists, do not INSERT and return an error code to the web page.