Question about Filling Parameters

[melegant]

Dang nab it..is there a way to auto fill the parameter collection with the parameters from a stored procedure?

I could eliminate so many lines of code...

I have a program that uses about 300 SPs and it would be so much easier if i could auto fill those values..I am writing a class that bascially has a method for each sp that fills the collection..tedious though...

thanks

 

[quwiltw]

Take a look at the Data Access Block for .NET. Itll help out with some of this.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp

 

[me_again]

Take a look at the SqlCommandBuilder class DeriveParameters method. It will supposedly do what you want, but I couldnt get it to work properly. In fact, I found the SqlCommandBuilder in general to be a knee-haltered piece of crap.