>Hi,
>
>Before I do the IF/ELSE, or SWITCH, I am wondering if I could macro expand in C#. Here is an example. I am passing a value of ParameterDirection as a string (e.g. 'Input', 'InputOutput', 'Output') I need to set ParameterDirection based on the passed value.
>
>Here is the pseudo code:
>
>

>string cDirection = 'Input';
>param.Direction = ParameterDirection. + 'cDirection';
>

>
>I am pretty sure that the above syntax will not work. But is there way to make it work? TIA.

Why not just pass it as parameter?

.....
Test(ParameterDirection.Input);

public void Test(ParameterDirection TestMe)
        {
...
            SqlCommand sql = new SqlCommand();
            sql.Parameters.Add("asd", SqlDbType.Int, 4);
            sql.Parameters[0].Direction = TestMe;
   ...     
        }