Static array in C# ASP .Net
<p>I am getting a strange problem.</p>

<p>I have a static method which is in common DLL and returns a static array of countries from the database.</p>

<p>And using this common method, I am trying to fill a Drop down of Country.</p>

<p>So code will be as below.</p>

<p>In Common - Helper Class DLL code</p>

<pre><code>public static string[] Countries()
    {

            string qry = "select * from Countries";

            Dataset result=SqlHelper.ExecDS(qry);
            countryArray = new string[100];
            //Filing country array
            return countryArray;
    }
</code></pre>

<p>In the current project</p>

<pre><code>countryOptions = new string[100];
countryOptions = Common.Helper.Countries();
</code></pre>

<p>I know Drop Down should be bind with DS only but as his is in common DLL i cannot change this.</p>

<p>But now only problem I am facing is even if delete a row from Countries table it is effect is not coming in Countries array.  </p>

<p>Common.Helper.Countries() is still returns that row. I have double checked that the row has been deleted but its effect is not coming. Can someone please help me with this?? </p>
