How to pass an Enum to a FunctonI have several Enums defined and I would like to know if anyone knows how to pass an Enum to a function.<br/><br/><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff"><font size=2 color="#0000ff"><font size=2 color="#0000ff"> <p>Enum</p> </font></font></span><font size=2 color="#0000ff"> <p> </p> </font></span> <p><span style="font-size:x-small"> eOne <p>eName</p> <p>eAddress</p> <p>eCity</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Enum</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Enum</span></span><span style="font-size:x-small"> eTwo <p>eDate</p> <p>eEmailAddress</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Enum</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' Routine that passes enum,</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;/summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;EnumGoesHere&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;remarks&gt;&lt;/remarks&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Public</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Sub</span></span><span style="font-size:x-small"> PassEnum(</span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> EnumGoesHere)<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> sqlString </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small"> = </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Nothing</span></span></p> <span style="font-size:x-small"><font size=2> <p>sqlString =</p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Me</span></span><span style="font-size:x-small">.LoadHdrEnum()<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Sub</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' Routine that accepts enum.</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;/summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;mode&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;sqlString&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;EnumGoesHere&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;returns&gt;&lt;/returns&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;remarks&gt;&lt;/remarks&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Public</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Shared</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Function</span></span><span style="font-size:x-small"> LoadHdrEnum(</span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> mode </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small">, </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> sqlString </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small">, </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> EnumGoesHere) </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> i </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> Int16 = 0<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> holdString </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small"> = </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Nothing</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">' Replace the Enum names with the numbers.</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">For</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Each</span></span><span style="font-size:x-small"> enumType </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">In</span></span><span style="font-size:x-small"> [Enum].GetValues(</span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">GetType</span></span><span style="font-size:x-small">(EnumGoesHere))<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> strMsgType </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small"> = enumType.ToString()<font size=2> <p>sqlString = Replace(sqlString,</p> </font></span></p> <p><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;hdr.&quot;</span></span><span style="font-size:x-small"> &amp; strMsgType, i) <p>i += 1</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Next</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Return</span></span><span style="font-size:x-small"> sqlString<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Function</span></span></p>© 2009 Microsoft Corporation. All rights reserved.Wed, 21 Oct 2009 01:53:51 Zd608de49-1722-46ba-a83d-95af30ce58c3http://social.msdn.microsoft.com/Forums/en-US/MEFramework/thread/d608de49-1722-46ba-a83d-95af30ce58c3#d608de49-1722-46ba-a83d-95af30ce58c3http://social.msdn.microsoft.com/Forums/en-US/MEFramework/thread/d608de49-1722-46ba-a83d-95af30ce58c3#d608de49-1722-46ba-a83d-95af30ce58c3KevinHBeltwayhttp://social.msdn.microsoft.com/Profile/en-US/?user=KevinHBeltwayHow to pass an Enum to a FunctonI have several Enums defined and I would like to know if anyone knows how to pass an Enum to a function.<br/><br/><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff"><font size=2 color="#0000ff"><font size=2 color="#0000ff"> <p>Enum</p> </font></font></span><font size=2 color="#0000ff"> <p> </p> </font></span> <p><span style="font-size:x-small"> eOne <p>eName</p> <p>eAddress</p> <p>eCity</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Enum</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Enum</span></span><span style="font-size:x-small"> eTwo <p>eDate</p> <p>eEmailAddress</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Enum</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' Routine that passes enum,</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;/summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;EnumGoesHere&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;remarks&gt;&lt;/remarks&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Public</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Sub</span></span><span style="font-size:x-small"> PassEnum(</span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> EnumGoesHere)<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> sqlString </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small"> = </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Nothing</span></span></p> <span style="font-size:x-small"><font size=2> <p>sqlString =</p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Me</span></span><span style="font-size:x-small">.LoadHdrEnum()<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Sub</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' Routine that accepts enum.</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;/summary&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;mode&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;sqlString&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;param name=&quot;EnumGoesHere&quot;&gt;&lt;/param&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;returns&gt;&lt;/returns&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">''' </span></span><span style="font-size:x-small;color:#808080"><span style="font-size:x-small;color:#808080">&lt;remarks&gt;&lt;/remarks&gt;</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Public</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Shared</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Function</span></span><span style="font-size:x-small"> LoadHdrEnum(</span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> mode </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small">, </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> sqlString </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small">, </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">ByVal</span></span><span style="font-size:x-small"> EnumGoesHere) </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> i </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> Int16 = 0<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> holdString </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small"> = </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Nothing</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">' Replace the Enum names with the numbers.</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">For</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Each</span></span><span style="font-size:x-small"> enumType </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">In</span></span><span style="font-size:x-small"> [Enum].GetValues(</span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">GetType</span></span><span style="font-size:x-small">(EnumGoesHere))<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> strMsgType </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">String</span></span><span style="font-size:x-small"> = enumType.ToString()<font size=2> <p>sqlString = Replace(sqlString,</p> </font></span></p> <p><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;hdr.&quot;</span></span><span style="font-size:x-small"> &amp; strMsgType, i) <p>i += 1</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Next</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Return</span></span><span style="font-size:x-small"> sqlString<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Function</span></span></p>Fri, 12 Jun 2009 23:38:48 Z2009-06-12T23:38:48Zhttp://social.msdn.microsoft.com/Forums/en-US/MEFramework/thread/d608de49-1722-46ba-a83d-95af30ce58c3#612ed8a4-7d6e-4b38-8496-bcd997734529http://social.msdn.microsoft.com/Forums/en-US/MEFramework/thread/d608de49-1722-46ba-a83d-95af30ce58c3#612ed8a4-7d6e-4b38-8496-bcd997734529Jiyuanhttp://social.msdn.microsoft.com/Profile/en-US/?user=JiyuanHow to pass an Enum to a Functon<p>Pls. see:<br/><br/>Public Enum eOne</p> <p>    eOne</p> <p>    eName</p> <p>    eAddress</p> <p>    eCity</p> <p> </p> <p><br/>End Enum</p> <p>Enum eTwo</p> <p>    eDate</p> <p>    eEmailAddress</p> <p><br/>End Enum<br/><br/>Public Class Form1<br/><br/>    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br/>        PassEnum()<br/>    End Sub<br/><br/>    Public Sub PassEnum()</p> <p><br/>        <strong><span style="text-decoration:underline">Dim enumGoesHere1 As eOne = eOne.eAddress</span></strong></p> <p>        Dim sqlString As String = Nothing</p> <p>        sqlString = Me.LoadHdrEnum(&quot;&quot;, &quot;&quot;, <strong><span style="text-decoration:underline">enumGoesHere1</span></strong>)</p> <p> </p> <p> </p> <p><br/>    End Sub</p> <p>    Public Function LoadHdrEnum(ByVal mode As String, ByVal sqlString As String, <span style="text-decoration:underline"><strong>ByVal EnumGoesHere As eOne</strong></span>) As String</p> <p> </p> <p>        Dim i As Int16 = 0</p> <p> </p> <p><br/>        Dim holdString As String = Nothing</p> <p> </p> <p>        ' Replace the Enum names with the numbers.</p> <p> </p> <p>        For Each enumType In [Enum].GetValues(GetType(eOne))</p> <p><br/>            <strong><span style="text-decoration:underline">If enumType = EnumGoesHere Then<br/>                Dim ii As Int32 = 0<br/>            End If</span></strong></p> <p>            Dim strMsgType As String = enumType.ToString()</p> <p><br/>            sqlString = Replace(sqlString, &quot;hdr.&quot; &amp; strMsgType, i)</p> <p>            i += 1</p> <p> </p> <p><br/>        Next</p> <p> </p> <p>        Return sqlString</p> <p> </p> <p>    End Function</p> <p><br/>End Class</p>Sat, 05 Sep 2009 15:02:18 Z2009-09-05T15:02:18Z