Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error calling Stored Procedure
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01221719
Message ID:
01223209
Vues:
26
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform