Getting the actual value of a constant whose name is read from a f

[Guest]

Is it possible to get the actual value of a constant which is defined inside
a class programatically?

Suppose I want to build a SQL query dinamically, including parameters, which
makes wonders to the SQL speed. I have a XML file which is something like

<SQL sentence="SELECT NAME WHERE ID=?">
<PARAM name="ID" type="SqlDbType.NVarChar">
</SQL>

In my code, what I want to happen is

sc.Parameters.Add("ID", SqlDbType.NVarChar)

Any suggestions?

 

[Ed Kaim]

Are you asking about how to read data from XML files or how to use
parameterized queries with SQL?

 

[Sergey Bogdanov]

Due to the fact that Enum.Parse is absent in the CF1.0 you should use
OpenNETCF EnumEx.Parse [1] to convert string value to Enum:

string stringFromXml = "NVarChar";

sc.Parameters.Add("ID",
(SqlDbType)OpenNETCF.EnumEx.Parse(typeof(SqlDbType), stringFromXml));

[1]
http://www.opennetcf.org/SourceBrow...CF/InetPub/wwwroot/Source/OpenNETCF/EnumEx.cs

Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com