C#

public sealed class Serialize:IDisposable
{
    static StreamWriter output;
    //static FileStream output;

    /// <summary>
    /// Writes an opening Xml node to the stream
    /// </summary>
    /// <param name="fieldName"></param>
    public static void WriteOpen(string fieldName)
    {
        string buffer = String.Format("<{0}>", fieldName);
        //output.Write(Encoding.UTF8.GetBytes(buffer),0,buffer.Length);
        output.Write( buffer );
    }

    /// <summary>
    /// Writes a closing Xml node to the stream
    /// </summary>
    /// <param name="fieldName"></param>
    public static void WriteClose(string fieldName)
    {
        string buffer = String.Format("</{0}>", fieldName);
        //output.Write(Encoding.UTF8.GetBytes(buffer),0,buffer.Length);
        output.Write( buffer );
    }

    /// <summary>
    /// Writes a raw line of data to the stream
    /// </summary>
    /// <param name="rawData"></param>
    public static void WriteRaw(string rawData)
    {
        //output.Write(Encoding.UTF8.GetBytes(rawData), 0, rawData.Length);
        output.Write( rawData );
    }

    /// <summary>
    /// Writes a formatted Xml line of data to the stream
    /// </summary>
    /// <param name="fieldName"></param>
    /// <param name="value"></param>
    public static void WriteLine(string fieldName, string value)
    {
        if (value.Length.Equals(0))
        {
            string buffer = String.Format("<{0} />", fieldName);
            //output.Write(Encoding.UTF8.GetBytes(buffer),0,buffer.Length);
            output.Write( buffer );
        }
        else
        {
            string buffer = String.Format("<{0}>{1}</{0}>", fieldName, value);
            //output.Write(Encoding.UTF8.GetBytes(buffer),0,buffer.Length);
            // THIS IS WHERE I BROKE THE CODE AND  VERIFIED THE BUFFER DATA PASSED TO THE STREAMWRITER
            output.Write( buffer );
        }
    }

    /// <summary>
    /// Entry point for outputting an object to a FileStream in an Xml-ish format
    /// </summary>
    /// <param name="stream"></param>
    /// <param name="value"></param>
    public static void OutputXmlStream(FileStream stream, Object value)
    {
        output = stream;
        string buffer = "<?xml version=\"1.0\" encoding=\"UTF-16\" ?>";
        output.Write(Encoding.UTF8.GetBytes(buffer),0,buffer.Length);

        Type baseObjectType = value.GetType();
        WriteOpen(value.GetType().Name);
        PropertyInfo[] propertyList = baseObjectType.GetProperties();

        foreach (PropertyInfo embeddedProperty in propertyList)
        {
            if (embeddedProperty.DeclaringType.ToString().StartsWith("SourceOne"))
                ObjectWalker.Walk(embeddedProperty.GetValue(value, null));
            else if (embeddedProperty.GetValue(value, null) is ArrayList)
                IEnumerableWalker.Walk( (ArrayList)embeddedProperty.GetValue(value, null));
        }

        WriteClose(value.GetType().Name);
    }

    #region IDisposable Members

    public void Dispose()
    {
        Dispose(true);
    }
    internal void Dispose(bool disposing)
    {
        if (disposing)
        {
        }
        GC.SuppressFinalize(this);
    }

    #endregion
}

anotherPictureBox.Click += new EventHandler(ProcessClick); // ProcessClick is a function (event handler)

cheq326 wrote:

Using SQL Server is just too slow for this

Justin Perez wrote:

Seriously, anything you do won't beat SQL.

cheq326 wrote:

Using SQL Server is just too slow for this

cheq326 wrote:

or SQL Server is the only way?

cheq326 wrote:

I was told that it was too slow for the task(The team has tried it before)