Using Stored Procedures with MSSQL and ASP.NET 2.0

Visit Publisher Site
Get Using Stored Procedures with MSSQL and ASP.NET 2.0 Hosting

Sponsored by TMDHosting

If you haven't used MSSQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. In this article I will list down basic questions like the following :what is a stored procedure? How can I create a stored procedure? How can I use it from within my ASP.NET 2.0 web pages? And how can I return an output parameter value to my ASP.NET web page? A stored procedure is a script of SQL code that is stored in your database under a given name. The SQL code for the stored procedure may contain programming logic (using T-SQL IF and CASE statements for example) and SELECT, INSERT, UPDATE or DELETE statements as well. There are many benefits using stored procedures instead of writing pure SQL code. 1. Reduce Network Usage between WebServer and Database Server. 2. Code Reuse. 3. Faster in performance . 4. Enhance Security as you can only give your user execute permission on your stored procedure.

Visit publisher site: Using Stored Procedures with MSSQL and ASP.NET 2.0

Listing Details

Version:
2.0 
Filed in:
Scripts / ASP.NET / Tutorials & Tips
Submitted on:
 
Last Updated:
Nov 14, 2007 
Publisher:
Other listings by this publisher

License & Pricing Information

LICENSE #1
License Type:
Other
Price:
$0.00 USD
Additional Info:

Featured Marketplace Listings

User Reviews 

Be the first to review this listing!
Average Member Rating: 5.00/5