Now it gets a lot more complicated. You have to create a property (not a field) and then you can check if that property exists with something like this:

        public bool PemStatus(object o, string name, string PEM)
        {
            switch (PEM.ToUpper())
            {
                case "P":
                    System.Reflection.PropertyInfo pi = o.GetType().GetProperty(name);
                    if (pi == null)
                        return false;
                    else
                        return true;
                case "E":
                    System.Reflection.EventInfo ei = o.GetType().GetEvent(name);
                    if (ei == null)
                        return false;
                    else
                        return true;
                case "M":
                    System.Reflection.MethodInfo mi = o.GetType().GetMethod(name);
                    if (mi == null)
                        return false;
                    else
                        return true;
                default:
                    return false;
            }
        }

So this is like Naomi said, you're using reflection.


>This function does look great if you know your variable in advance. But, that's why EVALUATE() is so powerful, because you don't have to know the variable in advance, you can pass a string "name" to it and it will evaluate it. For example:
>
>x = "company.name"
>y = EVALUATE(x)
>
>So the $64 question is, is there anything like that in C#?
>
>bob
>
>
>>You can use the StringBuilder class:
>>

>>StringBuilder sb = new StringBuilder();
>>sb.Append("SELECT *");
>>sb.AppendFormat(" FROM {0}",YourTableName);
>>sb.AppendFormat(" WHERE cName LIKE '{0}%'", WorkGroup);
>>sb.AppendFormat(" AND dIntervalStart >= '{0}' AND dIntervalStart < '{1}'", StartDate, EndDate);
>>sb.Append(" GROUP BY cName");
>>string sql = sb.ToString();
>>
>>SqlConnection cn = new SqlConnection(SqlDataSource);
>>SqlCommand cm = new SqlCommand(sql, cn);
>>