Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
Creating new update function
Versions des environnements
Hi Kevin,
I have a form that should update the sql tables (using stored procedures) passing only a few fields of a table. I can create the update function in the business object, and call that (passing only the required fields) rather then the save command, but I'm assuming that defeats the design goals and it wouldn't call the error checking routines first.
Could you tell me what the proper approach would be?
Or put another way: using Northwind as an example, suppose I had a form that only displayed CustomerID, ContactName and Phone. After the user updates the data I'd call save, however this will halt stating missing parameters -- the stored procedure for update is looking for every field, not just CustomerID, ContactName and Phone. I can create the additional update stored procedure with just the required parameters, but I'm missing the correct approach to calling it (or rather to have save call it).
Suggestions?
thanks,
Larry
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement