C#

Ista wrote:

You can use Relection to populate the class also

Get the name of the field. Get the Name of the Property into a PropertyInfo object then call set value.

Then you wont have and hunky stored proc code for getting and saving.

Use CommandBuilder.DeriveParameters to get all the parameters dynamically

use the reader to step through

<br />
string oldWord = "Hello Welcome";<br />
string newWord = "";<br />
for (int c = 0; c < 26; c++)<br />
{<br />
  int newchar = (int)'a'+c;<br />
  newWord += oldWord.Replace(' ', (char)newchar );<br />
}<br />
System.Diagnostics.Debug.WriteLine(newWord);<br />

<br />
"HelloaWelcomeHellobWelcomeHellocWelcomeHellodWelcomeHelloeWelcomeHellofWelcomeHellogWelcomeHellohWelcomeHelloiWelcomeHellojWelcomeHellokWelcomeHellolWelcomeHellomWelcomeHellonWelcomeHellooWelcomeHellopWelcomeHelloqWelcomeHellorWelcomeHellosWelcomeHellotWelcomeHellouWelcomeHellovWelcomeHellowWelcomeHelloxWelcomeHelloyWelcomeHellozWelcome"<br />

public class Singleton
{
    // private constructor to prevent instantiation
    private Singleton() {}


    private static volatile Singleton _singleton;
    private static object _lock = new object();

    public static Singleton Value
    {
        get
        {
            if (_singleton == null)
            {
                lock(_lock);
                {
                    if (_singleton == null) _singleton = new Singleton();
                }
            }
            return _singleton;
         }
     }
}