title: How can I retrieve binary data from sql with c#?
body: <p>I retrieved the data that I saved in a filestream column as an example the
  below code, and got it into memory stream or byte array. How can I open it
  with its default?</p>
  
  <p>OS application like opening a photo with photo manager or word document with
  MS Word ? Normally I use the Process.Start command <strong>but it doesn't work with
  memorystream or byte array so how can this be done ?</strong></p>
  
  <pre><code> public DataTable RetriveFile(int Code)
          {
              mydbms d = new mydbms();
              DataTable dt;
  
  
             String com2 = "select * from Matn_Naame where Code=" + Code + ";";
             dt = d.executeselectsql(com2);
  
  
              return dt;
          }
  {
  Letter_Manager L_M = new Letter_Manager();
              Byte[] b;
              DataTable dt = new DataTable();
              dt = L_M.RetriveFile(6);
  
              b=(Byte[])dt.Rows[0]["fileContent"];
              path = dt.Rows[0]["Path"].ToString();
  
                   MemoryStream Memory = new MemoryStream(b);
                   Memory.Write(b, 0, b.Length);
  //??????????????????**?for open and show file**
  }
  </code></pre>