Database

<italic>Work hard and a bit of luck is the key to success.

object obj1;<br />
object obj2;<br />
object obj3;<br />
<br />
InsertData()<br />
{<br />
  MemoryStream stream = new MemoryStream();<br />
  BinaryFormatter formatter = new BinaryFormatter();<br />
<br />
  Hashtable ht = new Hashtable();<br />
  ht.Add( "Object1", obj1 );<br />
  ht.Add( "Object2", obj2 );<br />
  ht.Add( "Object3", obj3 );<br />
<br />
  formatter.Serialize( stream, ht );<br />
<br />
  // Convert the Hashtable into bytes.<br />
  int iStreamLength = Convert.ToInt32(stream.Length);<br />
  byte[] byteBackup = new byte[iStreamLength];<br />
  stream.Read( byteBackup, 0, iStreamLength );<br />
  stream.Close();<br />
<br />
  SqlConnection conn = new SqlConnection( strConnectionString );<br />
  SqlCommand cmd = new SqlCommand( "ins_BackupData", conn );<br />
  cmd.CommandType = CommandType.StoredProcedure;<br />
  cmd.Parameters.Add( "@Name", "ObjectsBackup" );<br />
  cmd.Parameters.Add( "@Data", byteBackup );<br />
<br />
  cmd.ExecuteNonQuery();<br />
}<br />
<br />
RetrieveData()<br />
{<br />
  SqlConnection conn = new SqlConnection( strConnectionString );<br />
  SqlCommand cmd = new SqlCommand( "get_BackupData", conn );<br />
  cmd.CommandType = CommandType.StoredProcedure;<br />
  cmd.Parameters.Add( "@Name", "ObjectsBackup" );<br />
<br />
  conn.Open();<br />
<br />
  object obj = cmd.ExecuteScalar();<br />
<br />
  if( obj != null )<br />
  {<br />
    byte[] byteBackup = (byte[])obj;<br />
    MemoryStream stream = new MemoryStream(byteBackup);<br />
    BinaryFormatter formatter = new BinaryFormatter();<br />
<br />
    Hashtable ht = (Hashtable)formatter.Deserialize( stream );<br />
    obj1 = ht["Object1"];<br />
    obj2 = ht["Object2"];<br />
    obj3 = ht["Object3"];<br />
<br />
    stream.Close();<br />
  }<br />
}