Saving & Retrieving Images from Access DataBase

How can I save then retrieve an image from an access Database using VB.Net?

--
Dennis in Houston

Nov 21 '05 #1

2998

Dennis,

Probably is your problem that in Access Databases are OLE formated images
used.

Those have headers. The most used you get with using this in the code you
probably already have.

\\\
Dim ms As MemoryStream = New MemoryStream(ar byte, 78, arbyte.Length-78)
///

I hope this helps?

Cor

Nov 21 '05 #2

Herfried K. Wagner [MVP]

"Dennis" <De****@discuss ions.microsoft. com> schrieb:

How can I save then retrieve an image from an access Database using
VB.Net?

<URL:http://www.google.de/groups?selm=u%2 4648L9EFHA.628% 40TK2MSFTNGP15. phx.gbl>

Related:

How To Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;308042>

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and
Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;316887>

HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in
ADO.NET and Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;317034>

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;326502>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #3

Dennis

Thanks Cor and Herfried. I got it figured out using the examples where I
create a table in an Access DataBase of type Binary. I can then write and
read byte arrays and don't need to use the 78 byte offset. Thanks.

"Herfried K. Wagner [MVP]" wrote:

"Dennis" <De****@discuss ions.microsoft. com> schrieb:
How can I save then retrieve an image from an access Database using
VB.Net?

<URL:http://www.google.de/groups?selm=u%2 4648L9EFHA.628% 40TK2MSFTNGP15. phx.gbl>

Related:

How To Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;308042>

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and
Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;316887>

HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in
ADO.NET and Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;317034>

HOW TO: Read and Write BLOB Data by Using ADO.NET Through ASP.NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;326502>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #4

Similar topics

3654

mySQL & Files

by: Fan of P2P | last post by:

Hi, Does anyone know how I can store files (mostly pictures) into a mySQL table? I have tried the load_file function but it seems to not work. i just get NULL as the value. Any examples would be most appreciated. I am using RH9 and the latest version of mySQL. I know I should be storing the links on disk and the save a pointer in

MySQL Database

1990

Retrieving images from Access table PLEASE HELP

by: Roman Kagan | last post by:

Hi everyone, I am successful in retrieving the image from the table (.TIF), however, the retrieved file does not work. It looks like an image file - extension, size and all, but the image is not visible. Any ideas? I'm including the first few lines (image opened with Notepad) of the file below. Please, help. """""

Microsoft Access / VBA

1687

Saving and retrieving to/from MYSQL database. Help.

by: Krakatioison | last post by:

Hi everyone, can someone point me to download of an example for saving and retrieving to/from MYSQL database. Or did anyone of you tried this and could share your code with me. I've got some data which needs to be put to mysql database using VB.NET and I can't figure this out. Thanks a lot. K.

Visual Basic .NET

16110

Retrieving an image from SQL Server using dataset

by: Dean Slindee | last post by:

Does anybody have an actual example of retrieving an Image data type column from a SQL Server table using a dataset (not a datareader)? I would like to see the statements that would move the Image returned in the dataset to a picture box, like: For Each dr in ds.tables(0).rows Pic.Image = dr("ImageColumnName") 'not this simple! Next ...

Visual Basic .NET

6709

binary stream saving at server instead of client

by: Pedro Leite | last post by:

Good Afternoon. the code below is properly retreiving binary data from a database and saving it. but instead of saving at client machine is saving at the server machine. what is wrong with my code ?? thank you Pedro Leite From Portugal ------------------------------------

ASP / Active Server Pages

1832

Saving MS Access Dbase to CD & Verifying it Works !

by: chiefsitebuilder | last post by:

I have a question about saving an MS Access program to CD and verifyng that the program works after being saved. Here is my situation, I have a person who developed an application for me using MS Access 2003 and the person will be transferring ownership to me. The developer will be giving me a CD with Access DBase source code on it. How...

Microsoft Access / VBA

1647

Software selection help Visual & Database

by: FlyingBuckner | last post by:

All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase. I have a database set up using Access, 6 users. It is split into Tables and Applications, no more then 65MB of data in the tables right now. I have 2 college courses in Visual Basic 6 and have written VBA code in Access and...

Visual Basic 4 / 5 / 6

1838

Saving and retriving images in database through WS

by: Marco Pais | last post by:

Hi there. I'm developing a small application that uses Web Services to access database and store data. At some point, I store some images, by inserting the absolute image path into a varchar field (SQL Server 2005). Images themselves are copied to that path on the server. To read the images, I just use this path. However, some...

C# / C Sharp

7400

Saving an image to SQL Server's image datatype

by: Nathan Sokalski | last post by:

I am using ASP.NET 2.0, and need to know how to save and use an image that is stored in an SQL Server image datatype. How can I do this using ASP.NET? Thanks.

ASP.NET

7446

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7718

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7470

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7809

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6041

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5088

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3480

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1936

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

763

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General