I had web form in which user can upload image and I had two file upload first for product image and the second for logo image.

In the file upload for logo image user can upload also he can not upload any image. I tried to insert NULL data when the user doesn’t upload an image in logo file upload.

And I had Data list which I display the images. I created a GenericHandler to display image, but when the DataList loads with images this error appears:

Specified argument was out of the range of valid values
Parameter name: offset

I know the error occurs because I inserted a NULL image, but I couldn’t solve this error.

Note: when I saw the data in SQL, I found the NULL image was inserted with data type “Binary data”…

My C# code:

protected void BtnSubmit_Click(object sender, EventArgs e)
{
    int RowAffected = 0;

        byte[] imageSize = new byte
                      [FileUpload1.PostedFile.ContentLength];
        HttpPostedFile uploadedImage = FileUpload1.PostedFile;
        uploadedImage.InputStream.Read
           (imageSize, 0, (int)FileUpload1.PostedFile.ContentLength);

            using (SqlConnection con = Connection.GetConnection())
            {
                SqlCommand Com = new SqlCommand("Insert_IntoModel", con);
                Com.CommandType = CommandType.StoredProcedure;

                    SqlParameter UploadedImage = new SqlParameter
                              ("@Image", SqlDbType.VarBinary, imageSize.Length);
                    UploadedImage.Value = imageSize;
                    Com.Parameters.Add(UploadedImage);
                    if (FU2.PostedFile == null && FU2.PostedFile.FileName == "")
                    {

                        Com.Parameters.Add("@Logo", SqlDbType.VarBinary).Value = DBNull.Value;
                    }
                    else
                    {
                        byte[] imageSize2 = new byte
                         [FU2.PostedFile.ContentLength];
                        HttpPostedFile uploadedImage2 = FU2.PostedFile;
                        uploadedImage2.InputStream.Read
                           (imageSize2, 0, (int)FU2.PostedFile.ContentLength);

                        SqlParameter UploadedImage2 = new SqlParameter
                                 ("@Logo", SqlDbType.VarBinary, imageSize2.Length);
                        UploadedImage2.Value = imageSize2;
                        Com.Parameters.Add(UploadedImage2);
                    }
                    RowAffected = Com.ExecuteNonQuery();
                    if (RowAffected > 0)
                    {
                        LblResult.Visible = true;
                        LblResult.Text = "Successfully Proccess";
                        Tbl.Visible = false;
                    }
                }

             }
        }

Generic Handler:

public class ModelLogo : IHttpHandler
{

public void ProcessRequest(HttpContext context)
{
    using (System.Data.SqlClient.SqlConnection con = Connection.GetConnection())
    {
        string Sql = "Select Logo From Model Where Id=@Id";
        System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(Sql, con);
        com.CommandType = System.Data.CommandType.Text;
        com.Parameters.Add(Parameter.NewInt("@Id", context.Request.QueryString["Id"].ToString()));
        System.Data.SqlClient.SqlDataReader dr = com.ExecuteReader();
        if (dr.Read() && dr != null)
        {

            Byte[] bytes = (Byte[])dr["Logo"];
            context.Response.BinaryWrite(bytes);
            dr.Close();
        }
    }
}