Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-01-05 : 20:45:49
|
| I guess I'll get to trying this tonight, but I'm gonna ask anyway...ASP required *all* SP parameters to be specified in an ADO call.Did .NET loosen the requirement?Sam |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-01-05 : 20:59:54
|
| ASP (or more correctly, ADO) didn't require *all* parameters. It just required them in the correct order as it didn't understand the parameter name. So you put optional parameters at the end of your proc definition and not pass them in via ADOADO.NET does loosen this as it passes the parameter names through, so if your parameter has a default (making it optional) then yes, you don't need to pass it in.Damian |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-05 : 21:01:49
|
| Thanks. I'll give it a try without coding all the parms.Sam |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2004-01-06 : 14:07:46
|
| Maybe a little late to be of any help but the Microsoft Data Access Application Block makes using stored procedures a breeze. Shouldn't take more than an hour to get familiar with it and you will more than make up the time. Definately give it a shot.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.aspJustin"I want to thank you. You could've given us help, but you've given us so much more." |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-01-07 : 14:00:08
|
| I'm with you Justin, I think the application blocks are great and hope MS continues to expand on these. We use several of them at my work and they demonstrate great design patterns for the .NET developer.http://www.microsoft.com/resources/practices/audiences.asp#dev |
|
|
|
|
|
|
.NET