Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a relational database via an asp
Message
From
06/06/2003 08:00:59
 
 
To
06/06/2003 04:09:56
Philip Jones
Cornwall County Council
Truro, United Kingdom
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00795654
Message ID:
00797136
Views:
25
There's nothng wrong with sending 60 or 70 parameters to a stored procedure and letting SQL Server do the insert. It's a good idea to minimize the number of network trips.

What I'm not a fan of, is making the direct database calls from within ASP.

You might give this a quick scan:
http://msdn.microsoft.com/architecture/patterns/ArcThreeLayeredSvcsApp/default.aspx

-Mike


>Sorry to be a pain but I'm new to ASP and SQL server. What is WinDNA?
>I'm just sending data from a form with 60 or 70 fields on it to a sql database. In this case I figure I might as well just send all of the values to one stored proc which will do all of the insertions.
>
>Phil.
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform