

connString = "data source=dev;uid=Mary;pwd=Builder;initial catalog=Northwind"
strSQL = "InsertSupplier"
Dim sp(10) As SqlParameter
sp(0) = New SqlParameter("@companyName", "CNET")
sp(1) = New SqlParameter("@contactName", "Angela Lawson")
sp(2) = New SqlParameter("@contactTitle", "Editor")
sp(3) = New SqlParameter("@address", "1 Main St")
sp(4) = New SqlParameter("@city", "Louisville")
sp(5) = New SqlParameter("@region", "South")
sp(6) = New SqlParameter("@postalCode", "40004")
sp(7) = New SqlParameter("@country", "USA")
sp(8) = New SqlParameter("@phone", "502-555-5555")
sp(9) = New SqlParameter("@fax", "502-111-1111")
sp(10) = New SqlParameter("@homePage", "builder.com.com")
SqlHelper.ExecuteReader(connString, CommandType.StoredProcedure, strSQL)
代码传递多个参数值到以下的存储程序:
CREATE PROCEDURE dbo.InsertSupplier
@companyNamevarchar(30),@contactNamevarchar(30),@contactTitlevarchar(30),
@address varchar(30),@city varchar(30),@region varchar(30),
@postalCodevarchar(30),@country varchar(30),@phone varchar(30),
@fax varchar(30),@homePagevarchar(30)
AS
INSERT INTO Suppliers
(CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode,
Country, Phone, Fax, HomePage)
VALUES
(@companyName, @contactName, @contactTitle,@address, @city, @region,
@postalCode, @country, @phone, @fax, @homePage)
简单而直接数据访问应用程序模块是.NET开发人员工具箱的一个出色的工具。它提供了在.NET程序中访问数据的一个简单而又明了的方法。除此之外,它集中了数据库连接的管理,从而提高了程序的性能。