Advertisement
Guest User

Untitled

a guest
Apr 21st, 2014
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. string imagePath = @"C:UsersMePicturesrubic.png";
  2. byte[] imageBytes = File.ReadAllBytes(imagePath);
  3.  
  4. using (var conn = new OleDbConnection(
  5. @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Dataaccess.mdb"))
  6. {
  7. using (var cmd = new OleDbCommand(
  8. "INSERT INTO tblImages ([image], [name]) VALUES (@1, @2)", conn))
  9. {
  10. conn.Open();
  11. cmd.Parameters.AddWithValue("@1", imageBytes);
  12. cmd.Parameters.AddWithValue("@2", "Rubic's cube");
  13. cmd.ExecuteNonQuery();
  14. }
  15. }
  16.  
  17. string imageSavePath = @"C:UsersMeDesktoptest.png";
  18. byte[] imageBytes;
  19.  
  20. using (var conn = new OleDbConnection(
  21. @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Dataaccess.mdb"))
  22. {
  23. using (var cmd = new OleDbCommand(
  24. "SELECT [image] FROM tblImages WHERE id = 1", conn))
  25. {
  26. conn.Open();
  27. imageBytes = (byte[])cmd.ExecuteScalar();
  28. }
  29. }
  30. File.WriteAllBytes(imageSavePath, imageBytes);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement