How to make function update image to access 2007

Question

1.00/5 (1 vote)

See more:

.NET4.5

I work in windows form c# working with access 2007

i need to make function to update image in access where = UserID

BUT I need to know how to do function and how to call it

public string updateimg(string UserID,string path)
       {
           string valuereturn = null;
           var oleDbConnection = new OleDbConnection(connection);
           var oleDbCommand = oleDbConnection.CreateCommand();
           oleDbCommand.CommandText = "Update AllPrinting set  qrimg=@qrimg where UserID=@UserID)";
           oleDbCommand.Parameters.AddWithValue("@UserID", "UserID");
           byte[] yourPhoto = path;
           oleDbCommand.Parameters.AddWithValue("@photo", yourPhoto);
           using (oleDbConnection)
           {
               oleDbConnection.Open();
               valuereturn= oleDbCommand.ExecuteNonQuery().ToString();
           }
           return valuereturn;
       }

problem how to assign value for byte in function
and how to call this function
i assign data type for field qrimg to OLEOBJECT
please help me

What I have tried:

How to make function update image to access 2007

Posted 7-Mar-17 22:06pm

ahmed_sa

Updated 7-Mar-17 22:35pm

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2017-03-07T22:35:00

Solution 1

It depends if you want to store a path to an image file or the image itself.

The path is stored as any other string.

The image must be stored as BLOB (Binary Large OBject). Read the image file into a byte buffer and store that:

C#

byte[] buffer = File.ReadAllBytes(filename);
// ...
oleDbCommand.Parameters.AddWithValue("@photo", buffer);

[EDIT]
There is also an error in your UPDATE statement. It must be

SQL

"Update AllPrinting set  qrimg=@qrimg where UserID=@UserID;"

instead of

SQL

"Update AllPrinting set  qrimg=@qrimg where UserID=@UserID)"

[/EDIT]

Posted 7-Mar-17 22:35pm

Jochen Arndt

Updated 8-Mar-17 2:44am

v2

Comments

ahmed_sa 8-Mar-17 8:03am

i do as below but update not happen
please help me
byte[] buffer = File.ReadAllBytes(path);

OleDbConnection oleDbConnection = new OleDbConnection(connection);
string str = "Update AllPrinting set qrimg=@qrimg where UserID=@UserID";
OleDbCommand oleDbCommand = new OleDbCommand();
oleDbConnection.Open();
oleDbCommand.Connection = oleDbConnection;
oleDbCommand.CommandText = str;
oleDbCommand.Parameters.AddWithValue("@UserID", label4.Text);
byte[] yourPhoto = buffer;
oleDbCommand.Parameters.AddWithValue("@qrimg", yourPhoto);
using (oleDbConnection)
{

oleDbCommand.ExecuteNonQuery();

}
oleDbConnection.Close();

Jochen Arndt 8-Mar-17 8:07am

Any error message?

Catch exceptions to detect errors and get error messages (see https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbexception(v=vs.110).aspx).

You are making an UPDATE. Does your table has a column 'qrimg' of type BLOB?

ahmed_sa 8-Mar-17 8:18am

what type Blob i dont have type blob i set qrimg column to datatype oleobject
also these two columns exist in table AllPrinting

Jochen Arndt 8-Mar-17 8:20am

BLOB is an object type. I just asked to be sure.

What about the error message?

ahmed_sa 8-Mar-17 8:24am

i make catch it not give me any error
please help me

Jochen Arndt 8-Mar-17 8:29am

I'm sorry but I don't have your code or database or can view your screen.

How do you know that nothing is stored?
How do you check that nothing is updated?

ahmed_sa 8-Mar-17 8:32am

yes i check it empty

Jochen Arndt 8-Mar-17 8:37am

When there is no error the only reason that I can think of is that buffer is empty (File.ReadAllBytes() fails; e.g. because the file has not been found).

You may also wrap all your code into a try block and catch any exceptions to be sure that all is OK. Or use the debugger to step through your code and check the data.

ahmed_sa 8-Mar-17 8:35am

http://www.mediafire.com/view/pwy2ccgc9lvg736/aaa.jpg

ahmed_sa 8-Mar-17 8:36am

above link to my table in access database

ahmed_sa 8-Mar-17 8:36am

it is screen shoot

ahmed_sa 8-Mar-17 8:41am

I check buffer is null in debugger but path have value of image bath
what i do now

ahmed_sa 8-Mar-17 8:41am

buffer is null

Jochen Arndt 8-Mar-17 8:47am

Then there should be an exception or the file is empty.

ahmed_sa 8-Mar-17 8:52am

image not empty i check
image have data because i show on report after add data

ahmed_sa 8-Mar-17 9:00am

check debugger screen shoot

http://www.mediafire.com/view/ld88cr18xlz5cwq/imgenotnull.jpg

Jochen Arndt 8-Mar-17 9:07am

You must check it after the line has been processed.
That means that you have to set the breakpoint on the next line (or perform a single step when reaching the break point).

BTW:
Why you are copying the buffer to yourPhoto?
Just use
oleDbCommand.Parameters.AddWithValue("@qrimg", buffer);
or rename buffer to yourPhoto.

ahmed_sa 8-Mar-17 9:10am

not working

ahmed_sa 8-Mar-17 9:11am

i use buffer in place of yourphoto not working

Jochen Arndt 8-Mar-17 9:25am

Last try:
What are the properties of the qrimg field?
It must be a effectively a LONGBINARY.

ahmed_sa 8-Mar-17 9:44am

how i do that i check from database nothing property with this name

Jochen Arndt 8-Mar-17 9:45am

The first image you have posted:
Select the qrimg field and check the settings on the General tab below.

ahmed_sa 8-Mar-17 10:11am

I CHANGE code to
try
{
//byte[] buffer = File.ReadAllBytes(path);
byte[] buffer= ImageToBytes(pictureBox1.Image, ImageFormat.Jpeg);

OleDbConnection oleDbConnection = new OleDbConnection(connection);
string str = "Update AllPrinting set qrimg=@qrimg where UserID=@UserID";
OleDbCommand oleDbCommand = new OleDbCommand();
oleDbConnection.Open();
oleDbCommand.Connection = oleDbConnection;
oleDbCommand.CommandText = str;
OleDbParameter param = new OleDbParameter();
param.OleDbType = OleDbType.Binary;
param.ParameterName = "qrimg";
param.Value = buffer;
oleDbCommand.Parameters.Add(param);
OleDbParameter param2 = new OleDbParameter();
param2.OleDbType = OleDbType.VarChar;
param2.ParameterName = "UserID";
param2.Value = label4.Text;
oleDbCommand.Parameters.Add(param2);
// oleDbCommand.Parameters.AddWithValue("@UserID", label4.Text);

// oleDbCommand.Parameters.AddWithValue("@qrimg", buffer);
using (oleDbConnection)
{

oleDbCommand.ExecuteNonQuery();

}
oleDbConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
it update qrimg field but it display as
below screen shoot
http://www.mediafire.com/view/6yqinw5uchnk3ln/longbinary.jpg

ahmed_sa 8-Mar-17 10:13am

it show on filed qrimg long binary data
so that what this are this correct added or wrong
it not open when click

Jochen Arndt 8-Mar-17 10:44am

So there are data (I actually can not open the images)?

"it not open when click"
Where do you click (in Access)?
That is OK because Access does not know how to interpret the data. It is up to the application that uses the data to know what it is (e.g. by checking if it is a valid image format).

ahmed_sa 8-Mar-17 10:24am

can you help me please

ahmed_sa 8-Mar-17 10:53am

yes i click in access

ahmed_sa 8-Mar-17 10:54am

this meaning correct or not only one answer

Jochen Arndt 8-Mar-17 11:02am

I did not understand you here.

If there are data now in the field all is OK. You can then read them from your application and display the image.

ahmed_sa 8-Mar-17 11:19am

OK thank you for reply
thank you very much for help

How to make function update image to access 2007

1 solution

Solution 1

Add your solution here

Preview 0

How to make function update image to access 2007

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us