Use varbinary to retrieve image to database using FileUpload

Question

Okay so I'm using adding it to the database by using

  HttpPostedFile postedFile = eventImage.PostedFile;
        string fileExtension = Path.GetExtension(postedFile.FileName);

        if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".png")
        {
            Stream stream = postedFile.InputStream;
            BinaryReader reader = new BinaryReader(stream);
            byte[] imgByte = reader.ReadBytes((int)stream.Length);
            con = new SqlConnection(@"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-StudentMoneySaver-20160203040444.mdf;Initial Catalog=aspnet-StudentMoneySaver-20160203040444;Integrated Security=True");
            SqlCommand cmd = new SqlCommand("insert into Events (AspNetUsersId,EvtName,EvtType,EvtDescription,EvtDate,EvtVote, EvtImage) values (@AspNetUsersId, @EvtName, @EvtType, @EvtDescription, @EvtDate, @EvtVote, @EvtImage)", con);

            cmd.Parameters.AddWithValue("@AspNetUsersId", userId);
            cmd.Parameters.AddWithValue("@EvtName", eventName.Text);
            cmd.Parameters.AddWithValue("@EvtType", eventType.Text);
            cmd.Parameters.AddWithValue("@EvtDescription", eventDescription.Text);
            cmd.Parameters.AddWithValue("@EvtDate", datetimepicker.Value);
            cmd.Parameters.AddWithValue("@EvtVote", 0);
            cmd.Parameters.Add("@EvtImage", SqlDbType.VarBinary).Value = imgByte;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }

and trying to call just the image by using

  byte[] imgByte = null;
        con = new SqlConnection(@"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-StudentMoneySaver-20160203040444.mdf;Initial Catalog=aspnet-StudentMoneySaver-20160203040444;Integrated Security=True");
        SqlCommand cmd = new SqlCommand("SELECT * FROM Events", con);
        con.Open();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(ds);
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            string str = Convert.ToBase64String(imgByte);
            imageTest.Src = "data:Image/png;base64," + str;
        }

with the front end code being

<img runat="server" id="imageTest" src="imageIDtagName" />

I'm getting the error message "Value cannot be null. Parameter name: inArray

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentNullException: Value cannot be null. Parameter name: inArray" I think I'm close!

Could you check in the database, is Image column properly set. For example with SQL Server Managment Studio — Antonio Bakula
– Antonio Bakula, Commented Apr 14, 2016 at 0:47
You are not clearly stating what is not working and what is happening with what you are doing. Is the Save operation working, if so what is the filename property? What happens when you try to load it? Please post what is happening when you run your code. — Adam Heeg
– Adam Heeg, Commented Apr 14, 2016 at 1:12
Your save appears to only save the file name, not the actual file data. Your load appears to set the binary representation of the file name as the src property of an image which is actually supposed to be a url. I could be wrong, but based on memory those are a couple issues i see. — Adam Heeg
– Adam Heeg, Commented Apr 14, 2016 at 1:17

JC Borlagdan · Accepted Answer · 2016-04-14 03:09:10Z

4

If you want to load Image from SQL you do it like this:

byte[] imgByte = null;

SqlCommand cmd = new SqlCommand("SELECT Image FROM tableName",yourConnectionStringHere);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.fill(ds);
foreach(DataRow dr in ds.Tables[0].Rows)
{
  imgByte = (byte[])(dr["ImageColumnNameHere"].ToString());
  string str = Convert.ToBase64String(imgByte);
  imageIDtagName.Src = "data:Image/png;base64," + str;
}

Saving Image using the File Upload is done like this:

HttpPostedFile postedFile = imgFile.PostedFile;
string fileExtension = Path.GetExtension(postedFile.FileName);

 if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".png")
 {
            Stream stream = postedFile.InputStream;
            BinaryReader reader = new BinaryReader(stream);
            byte[] imgByte = reader.ReadBytes((int)stream.Length);
     SqlCommand cmd = new Sqlcommand("INSERT INTO tableName(Image) VALUES(@img)",yourConnectionStringHere);
cmd.Parameters.Add("@img",SqlDbType.VarBinary).Value = imgByte;
     cmd.ExecuteNonQuery();
 }

P.S. Surround your sqlconnection with using statement like

using(SqlConnection con = new SqlConnection(""))
{
   //your code here
}

to save you from doing the con.Open() and con.Close()

Edited: To access src property of your html tags, just add runat="server" in your html tag.

edited Apr 14, 2016 at 3:09

answered Apr 14, 2016 at 1:30

JC Borlagdan

3,6535 gold badges30 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Stuart Over a year ago

thank you so much for this. I'm having a slight error and I've edited my code. I appreciate your help!

JC Borlagdan Over a year ago

aaah so you have a column that is named as inArray?

Stuart Over a year ago

No? The only column names are the ones that I've added. (EventID, EvtType, EvtName, EvtDescription, EvtVote, EvtDate and EvtImage)

JC Borlagdan Over a year ago

no i mean do you have a column named inArray in your Events table

Stuart Over a year ago

I don't. I've edited the code to show a picture of my events table

|

Collectives™ on Stack Overflow

Use varbinary to retrieve image to database using FileUpload

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related