Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error calling Stored Procedure
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01221719
Message ID:
01223209
Views:
27
Larry,

>CREATE PROCEDURE dbo.GetOrderDetailByOrderID
>(
> @OrderID int
>)
>
>AS
> SELECT Discount,
> OrderID,
> ProductID,
> Quantity,
> UnitPrice
> FROM [Order Details]
> WHERE OrderID = @OrderID
> RETURN

This is correct...the code specified in the Jump Start should work just fine. What was the error you were getting in SQL Server when using the code specified in the Dev Guide? Did you remember to set the DefaultCommandType property to CommandType.StoredProcedure in ABusinessObject? Has it been inadvertently overridden in the constructor of your OrderDetail business object?

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform