ASP.NET
  Home arrow ASP.NET arrow Working with Stored Procedures using ASP.N...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ASP.NET

Working with Stored Procedures using ASP.NET 2.0 with Microsoft Data Access Application Block
By: Jagadish Chaterjee
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 9
    2006-10-23

    Table of Contents:
  • Working with Stored Procedures using ASP.NET 2.0 with Microsoft Data Access Application Block
  • Executing a stored procedure from ASP.NET 2.0 using the Data Access Application Block
  • Executing a stored procedure with parameters from ASP.NET 2.0 using the Data Access Application Block
  • Executing a stored procedure with parameters from ASP.NET 2.0 using the
  • Executing a stored procedure with parameters from ASP.NET 2.0 using the Data Access Application Block: the recommended approach
  • Executing a stored procedure which returns a set of rows using ASP.NET 2.0 and the Data Access Application Block

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Working with Stored Procedures using ASP.NET 2.0 with Microsoft Data Access Application Block


    (Page 1 of 6 )

    This is the fourth article in a series focusing on developing applications using ASP.NET 2.0 and the Data Access Application Block available in “Microsoft Enterprise Application Block Library for .NET 2.0.” In this article, I shall go through the routines most used (with simple examples) for working with stored procedures in a Microsoft SQL Server database.

    If you are new to Microsoft application blocks, I strongly suggest you refer to my first article in this series titled “Developing ASP.NET 2.0 Applications with the Microsoft Data Access Application Block.” It gives a solid foundation for beginners. 

    If you do not know how to select and use the proper “database” class, I suggest you go through my second article in this series titled “Connecting to Different Databases using ASP.NET 2.0 with the Microsoft Data Access Application Block.” In this article, I focus on working with Microsoft SQL Server.

    Setting up the environment for this contribution

    Before we begin, modify your web.config in such a way that it looks something like the following:

    <configuration>
          <appSettings/>
          <connectionStrings>
                <add name="AdventureWorks" connectionString="Database=
    AdventureWorks;Server=(local)SQL2k5;Integrated Security=SSPI;
    " providerName="System.Data.SqlClient"/>

          </connectionStrings>

    As I wanted to demonstrate stored procedures which don’t have data in AdventureWorks, I created a table named “emp” with the following columns and data types:

    • Empno (int)
    • Ename (nvarchar(50))
    • Sal (float)
    • Deptno (int)

    I pushed the following sample rows into that table:

    More ASP.NET Articles
    More By Jagadish Chaterjee


       · Hello guys! This article shows you how to work with stored procedures using data...
       · You have explained everything except for one. You have explained how to retrieve the...
     

    ASP.NET ARTICLES

    - Disadvantages of the ASP.NET MVC Framework
    - Advantages of the ASP.NET MVC Approach
    - ASP.NET Web Forms Weaknesses
    - ASP.NET Web Forms Meets ASP.NET MVC
    - Source Code for Saving and Retrieving Data w...
    - Using GridView to Save and Retrieve Data wit...
    - Handling Dynamic Images in ASP.NET 3.5 AJAX ...
    - Retrieving Data with AJAX and the GridView C...
    - Playing with Images in ASP.NET 3.5 AJAX Appl...
    - Saving and Retrieving Data with AJAX
    - Enhancing PHP Via the ASP.NET AJAX Framework...
    - Enhancing PHP Programming with the ASP.NET A...
    - Classes and ASP.NET AJAX
    - Using ASP.NET AJAX
    - Building a Simple Storefront with LINQ

     
    Application Delivery: Everything You Wanted to Know, but Didn`t Know You Needed to Ask
    A comprehensive guide to examining the topics of Wide-area Data Services and app....

     
    Best Practices: Safe and Secure Hardware Asset Recovery
    Companies increasingly must meet EPA and local requirements for the disposal of ....

     
    Managing SSL Security in Multi-Server Environments
    Read this white paper to learn how to simplify management of your organization's....

     
    Open Source Security Myths
    Open Source Software (OSS) is computer software whose source code is available t....

     
    Power and Cooling Capacity Management for Data Centers
    This paper describes the principles for achieving power and cooling capacity man....

     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
    Stay green...Green IT