Guest User

Untitled

a guest
Jul 18th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. byte[] img = null;
  2. FileStream fs = new FileStream(imgLoc, FileMode.Open, FileAccess.Read);
  3. BinaryReader br = new BinaryReader(fs);
  4. img = br.ReadBytes((int)fs.Length);
  5. string cmd = string.Format("insert into estudiantes_fotos values ('{0}','{1}')",
  6. codigo_estudiante.Text.Trim(), img);
  7.  
  8. string cmd = "select * from estudiantes_fotos where codigo_estudiante= '" + codigo_estudiante.Text.Trim() + "' ";
  9.  
  10. if (conn.State != ConnectionState.Open)
  11. conn.Open();
  12.  
  13. command = new NpgsqlCommand(cmd, conn);
  14. NpgsqlDataReader reader = command.ExecuteReader();
  15. reader.Read();
  16. if (reader.HasRows)
  17. {
  18. byte[] img = (byte[])(reader[1]);
  19. MemoryStream ms = new MemoryStream(img);
  20. foto_estudiante.Image = Image.FromStream(ms);
  21.  
  22. }
Add Comment
Please, Sign In to add comment