C#

damianrda wrote:

Hey, just wondering what the best method would be for storing simple objects in an mysql table.

<br />
		public string Serialize()<br />
		{<br />
			MemoryStream MemStream = new MemoryStream();<br />
			BinaryFormatter Serializer = new BinaryFormatter();<br />
<br />
			Serializer.Serialize(MemStream, this);<br />
<br />
			return Encoding.ASCII.GetString(MemStream.ToArray()).ToBase64();<br />
		}<br />

<br />
		public static Address Deserialize(string SerializedData)<br />
		{<br />
			Address Address;<br />
			MemoryStream MemStream = new MemoryStream();<br />
			BinaryFormatter Serializer = new BinaryFormatter();<br />
<br />
			string Decoded = SerializedData.FromBase64();<br />
			byte[] Buffer = Encoding.ASCII.GetBytes(Decoded);<br />
			MemStream.Write(Buffer, 0, Buffer.Length);<br />
<br />
			Address = (Address)Serializer.Deserialize(MemStream); <-- fails right here...<br />
<br />
			return Address;<br />
		}<br />

public string Serialize()
{
    MemoryStream MemStream = new MemoryStream();
    BinaryFormatter Serializer = new BinaryFormatter();
    Serializer.Serialize(MemStream, this);
    return Convert.ToBase64String(MemStream.ToArray());
}



public static Address Deserialize(string SerializedData)
{
    byte[] Buffer = Convert.FromBase64String(SerializedData);
    MemoryStream MemStream = new MemoryStream(Buffer);
    BinaryFormatter Serializer = new BinaryFormatter();
    return (Address)Serializer.Deserialize(MemStream);
}

Mark Salsbery
Microsoft MVP - Visual C++

...
Dept d = new Dept();                
while (datareader.Read())                
{
...

...
Dept d;
while (datareader.Read())                
{
   d = new Dept();
...

Dept d;
while (datareader.Read())                
{
   d = new Dept()

class Dept
{
    public static string Deptno;
    public static string Dname;
    public static string Loc;
    public string DNAME
    {
        get { return  Dname; }
        set { Dname = value; }
    }
    public string DEPTNO
    {
        get { return  Deptno; }
        set { Deptno = value; }
    }
    public string LOC
    {
        get { return  Loc; }
        set { Loc = value; }
    }
}

class Dept { 
      private static string Deptno;
      private static string Dname;
      private static string Loc; 
      public string DNAME { 
         get { return Dname; } 
         set { Dname = value; } 
      } 
      public string DEPTNO { 
         get { return Deptno; } 
         set { Deptno = value; } 
      } 
      public string LOC { 
         get { return Loc; } 
         set { Loc = value; } 
      } 
   }

ArrayList departments= new ArrayList();
Dept department;
while(reader.Read)
{
  department = new Dept();
  department.DName = reader["DepartmentName"] //or whatever name you have given your column
  department.DEPTNO = reader["DepartmentNumber"] //or whatever
  //...
  departments.Add(department);
}

department.Name;

private void InitializeComponent()
{
	this.label1 = new System.Windows.Forms.Label();
	this.SuspendLayout();
	// 
	// label1
	// 
	this.label1.BackColor = System.Drawing.Color.White;
	this.label1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
	this.label1.CausesValidation = false;
	this.label1.Font = new System.Drawing.Font("Arial", 9.75F, 
                              ((System.Drawing.FontStyle)
                               ((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), 
                               System.Drawing.GraphicsUnit.Point, ((byte)(0)));
	this.label1.ForeColor = System.Drawing.Color.DarkRed;
	this.label1.Location = new System.Drawing.Point(47, 128);
	this.label1.Name = "label1";
	this.label1.Size = new System.Drawing.Size(198, 24);
	this.label1.TabIndex = 0;
	this.label1.Text = "Loading program. Please wait...";
	this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
	// 
	// SplashPanel2
	// 
	this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
	this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
	this.BackColor = System.Drawing.Color.Lime;
	this.CausesValidation = false;
	this.ClientSize = new System.Drawing.Size(292, 273);
	this.Controls.Add(this.label1);
	this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
	this.MaximizeBox = false;
	this.MinimizeBox = false;
	this.Name = "SplashPanel2";
	this.ShowIcon = false;
	this.ShowInTaskbar = false;
	this.SizeGripStyle = System.Windows.Forms.SizeGripStyle.Hide;
	this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
	this.TransparencyKey = System.Drawing.Color.Lime;
	this.ResumeLayout(false);
}