Data Access Application Block

王朝c#·作者佚名  2006-12-17
窄屏简体版  字體: |||超大  

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程序中访问数据的一个简单而又明了的方法。除此之外,它集中了数据库连接的管理,从而提高了程序的性能。

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航