variable parameters

[=?Utf-8?B?cm9kY2hhcg==?=]

hey all,
if i have a function that i'm passing the name of a stored procedure to and
i don't know if the stored procedure is going to have parameters or not
what's the perferred way to handle this or pass this?

thanks,
rodchar

[Mark Rae [MVP]]

"rodchar" <ro*****@discussions.microsoft.comwrote in message
news:33**********************************@microsof t.com...

if i have a function that i'm passing the name of a stored procedure to
and
i don't know if the stored procedure is going to have parameters or not
what's the perferred way to handle this or pass this?

List<SqlParameterlstSqlParameters = new List<SqlParameter>();

Inside the function, implement foreach on the lstSqlParameters variable. If
it contains any, they'll be processed - if not, the rest of the function
will just continue...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?cm9kY2hhcg==?=]

thank you Mark for your help, i appreciate it.
rod.

"rodchar" wrote:

hey all,
if i have a function that i'm passing the name of a stored procedure to and
i don't know if the stored procedure is going to have parameters or not
what's the perferred way to handle this or pass this?

thanks,
rodchar