Save (Insert) Binary Image to database using Image Control in ASP.Net

Last Reply 7 months ago By pandeyism

Posted 7 months ago

Dear Team,

we have Displaying image from SQL database using image but while updating how to store Image Value to database with same Value.

Image Retrive & Save Code

// ImageRetriveCode
if (ds.Tables[0].Rows[0]["Image_Data"] != DBNull.Value)
{
    string imageUrl = "data:image/jpg;base64," + Convert.ToBase64String((byte[])ds.Tables[0].Rows[0]["Image_Data"]);
    imgDoctor.ImageUrl = imageUrl;
}

//ImageSaveCode
if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".bmp" || fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
{
    Stream stream = postedFile.InputStream;
    BinaryReader binaryReader = new BinaryReader(stream);
    byte[] bytes = binaryReader.ReadBytes((int)stream.Length);
    obj_Doc.Image_Data = bytes;
}
else
{
    obj_Doc.Image_Data = null;
}

  HTML Code

<div class="col-sm-6">
    <div class="form-group">
        <div class="profile-upload">
            <div class="upload-img"> 
                <asp:Image ID="imgDoctor" runat="server" Height="40px" Width="40px" class="rounded-circle m-r-5" />
            </div>
            <div class="upload-input">
                <asp:FileUpload ID="fuImage" runat="server" class="form-control" />
            </div>
        </div>
    </div>
</div>
This question does not have replies that have been liked.