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;