melegant Posted April 28, 2003 Posted April 28, 2003 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 SP's 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 :D Quote
Leaders quwiltw Posted April 28, 2003 Leaders Posted April 28, 2003 Take a look at the Data Access Block for .NET. It'll help out with some of this. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp Quote --tim
me_again Posted April 29, 2003 Posted April 29, 2003 Take a look at the SqlCommandBuilder class' DeriveParameters method. It will supposedly do what you want, but I couldn't get it to work properly. In fact, I found the SqlCommandBuilder in general to be a knee-haltered piece of crap. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.