Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string imagePath = @"C:UsersMePicturesrubic.png";
- byte[] imageBytes = File.ReadAllBytes(imagePath);
- using (var conn = new OleDbConnection(
- @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Dataaccess.mdb"))
- {
- using (var cmd = new OleDbCommand(
- "INSERT INTO tblImages ([image], [name]) VALUES (@1, @2)", conn))
- {
- conn.Open();
- cmd.Parameters.AddWithValue("@1", imageBytes);
- cmd.Parameters.AddWithValue("@2", "Rubic's cube");
- cmd.ExecuteNonQuery();
- }
- }
- string imageSavePath = @"C:UsersMeDesktoptest.png";
- byte[] imageBytes;
- using (var conn = new OleDbConnection(
- @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Dataaccess.mdb"))
- {
- using (var cmd = new OleDbCommand(
- "SELECT [image] FROM tblImages WHERE id = 1", conn))
- {
- conn.Open();
- imageBytes = (byte[])cmd.ExecuteScalar();
- }
- }
- File.WriteAllBytes(imageSavePath, imageBytes);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement