The author explains the benefits of stored procedures for complex systems and takes stored procedures beyond the level of demoware and provides some hands-on examples of how you can access stored procedures and start using them in your own applications.
This article will be broken down into two parts. Part one will describe in detail how to create stored procedures in Access using ADO.NET and Visual Basic.NET. Part two will demonstrate how to utilize the stored procedures created in part one by assembling a data access tier that can be modelled and used in your own applications.
The purpose of this article is to demonstrate how stored procedures are created in SQL Server 2000 and consumed by clients written in Visual Basic .NET.
This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter.
