ASP.NET Calling SQL Stored Procedure

Last Post 23 Feb 2009 05:53 AM by GoodFella3993. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

23 Feb 2009 05:53 AM
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.



Acceptable Use Policy