How Do I Save Image In Access

Question

0.00/5 (No votes)

See more:

<asp:FileUpload ID=FileUploadControl1; runat=server;>
i want to save image in ms access database. image is stored as oleobject.
how to write update statement to insert image using where clause

C#

<string sql="insert" into="" values="" where="" username="?;&lt;br" mode="hold" />
using (OleDbCommand command = new OleDbCommand(SqlString, conn))
{
  command.CommandType = CommandType.Text;
  command.Parameters.AddWithValue("PhotoImage", Nattxt.Text);
  command.Parameters.AddWithValue("SignIamge", apldposttxt.Text);
  command.Parameters.AddWithValue("UserName", usertxt.Text);
  command.ExecuteNonQuery();
}

Posted 31-May-14 4:47am

Ashwini Thakare

Updated 31-May-14 5:02am

PIEBALDconsult

v2

Add a Solution

Comments

[no name] 31-May-14 10:54am

http://www.w3schools.com/sql/sql_update.asp

DamithSL 31-May-14 11:07am

you need update or insert!

Ashwini Thakare 31-May-14 12:20pm

insert two images in a particular row by using where username = textbox value
the table already have username filled in it

DamithSL 31-May-14 12:33pm

then you need update SQL statement, like below
update MyTable set image1=@image1, image2=@image2 where username=@username

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

DamithSL · Answer 1 · 2014-05-31T05:13:00

if you need to insert new record; use insert SQL statement[^]
if you need to update existing record; use update SQL statement[^]
below is sample code which insert image data to access database using OleDbConnection

C#

protected void btnSaveImage_Click(object sender, EventArgs e)
{
    if (FileUpload1.HasFile)
    {
        string name = FileUpload1.PostedFile.FileName;
        int length = FileUpload1.PostedFile.ContentLength;
 
        byte[] imageBytes = new byte[length];
        Stream imageStream = FileUpload1.PostedFile.InputStream;
        imageStream.Read(imageBytes, 0, length);
 
        string connString = ConfigurationManager.ConnectionStrings["ImagesDB"].ConnectionString;
       OleDbConnection connection = new OleDbConnection(connString);
 
       string insertQuery = "INSERT INTO Images(ImageName, ImageSize, ImageData) VALUES(@ImageName, @ImageSize, @ImageData)";
        OleDbCommand command = new OleDbCommand();
        command.Connection = connection;
        command.CommandText = insertQuery;
        command.CommandType = CommandType.Text;
        command.Parameters.AddWithValue("@ImageName", name);
        command.Parameters.AddWithValue("@ImageSize", length);
       command.Parameters.AddWithValue("@ImageData", imageBytes);
 
        try
        {
            connection.Open();
            command.ExecuteNonQuery();
            lblMessage.Text = "Image data saved successfully";
        }
        catch (Exception ex)
        {
            lblMessage.Text = "Unable to save image data";
        }
        finally
        {
            connection.Close();
        }
    }
}

Refer this article [^]