各位高手,帮我看看这三个小问题!!!
lsh22 2003-12-12 11:06:29 1。treeview里面怎么没有找到一个隐藏某个Node的属性呢???而且我在他的selectedindexchanged里面写:label1.text="ss",这样的语句好象没有被执行?
2。关于存储过程的:
------------------------------------------------
-- GetAddressByCustomerId
------------------------------------------------
CREATE PROCEDURE GetAddressByCustomerId
@CustomerId INT,
@PKId INT = NULL OUTPUT,
@Address NVARCHAR(255) = NULL OUTPUT,
@Country NVARCHAR(40) = NULL OUTPUT,
@PhoneNumber NVARCHAR(30) = NULL OUTPUT,
@Fax NVARCHAR(30) = NULL OUTPUT
AS
SET NOCOUNT ON
SELECT @PKId = PKId,
@Address = Address,
@Country = Country,
@PhoneNumber = PhoneNumber,
@Fax = Fax
FROM Addresses
WHERE CustomerId = @CustomerId
RETURN 0
------------------------------------------------
-- duplicate index on Addresses (CustomerId)
------------------------------------------------
GO
这个存储过程根据@CustomerId,返回几个输出参数,请看下面的这个存储过程:
--------------------------------------------------
-- GetCustomerById
--------------------------------------------------
CREATE PROCEDURE GetCustomerById
@PKId INT = NULL
AS
SET NOCOUNT ON
SELECT c.PKId,
c.Email,
c.Password,
c.Name,
a.Address,
a.Country,
a.PhoneNumber,
a.Fax
FROM Customers c,
Addresses a
WHERE c.PKId = @PKId
AND a.CustomerId = @PKId
RETURN 0
--------------------------------------------------
-- unique index on Customers (PKId)
-- duplicate index on Addresses (CustomerId)
--------------------------------------------------
GO
这个存储过程没有输出参数,那我的程序里面怎么得到他查询得到的值,如果,我的返回是多条记录,又怎么办呢?
3。下面这个存储过程:
------------------------------------------------
-- InsertAddress
------------------------------------------------
CREATE PROCEDURE InsertAddress
@Address NVARCHAR(255) = NULL,
@Country NVARCHAR(40) = NULL,
@PhoneNumber NVARCHAR(30) = NULL,
@Fax NVARCHAR(30) = NULL,
@CustomerId NVARCHAR(255) = NULL,
@PKId INT = NULL OUTPUT
AS
SET NOCOUNT ON
-- Insert the new address and then return the
-- new identifier (PKId)
INSERT Addresses (Address,
Country,
PhoneNumber,
Fax,
CustomerId)
SELECT @Address,
@Country,
@PhoneNumber,
@Fax,
@CustomerId
-- return ID for new Address record
SELECT @PKId = @@IDENTITY
RETURN 0
------------------------------------------------
GO
我在书上看到INSERT Addresses (Address,
Country,
PhoneNumber,
Fax,
CustomerId)
在这里,应该是values(@Adress,....)这样的,形式,这个和上面的插入,有什么区别,上面是什么意思呀??