Enumerate Argument List

[tricky one]

Anyone know of a way to enumerate the argument list of a function in
VB.NET.

For example I have a Function add_user (u_id AS INT, u_first_name AS
VARCHAR(50), u_last_name AS VARCHAR(50)).

I want to be able to do something like this:

For each argument in add_user.argumentlist
Select Case argument.name
Case u_id
'Do This
Case u_first_name
'Do this
ETC.
Next argument

 

[Bruce Barker]

use reflection to get a MethodInfo, then GetParameters to get an Array of
ParameterInfo. you can then determine the name and type. getting parameters
into an array is more interesting (short of adding them to an array
yourself.). here you have to use the debugging api's.

not sure why you'd want to do this though, it would be pretty slow.

-- bruce (sqlwork.com)

 

[tricky one]

Worked perfectly, thanks Bruce.