how to upload image to sql database

Hi everyone, i am developing a web api i want to upload image to sql database.

so far i know first i have to convert image in to byte array
i have created a coloum of type varbinary
model with data type byte[];
but when i pass the image from postman app IN object its showing null

Here i have attached my code

public class User_details

{

[Key]

public Guid user_id { get; set; }

public string First_name { get; set; }

public string Middle_name { get; set; }

public string Last_name { get; set; }

public string Email { get; set; }

public string Password { get; set; }

public DateTime Dob { get; set; }

public string Role { get; set; }

public DateTime Created_on { get; set; }

public Boolean Verification { get; set; }

public string Password_reset_OTP { get; set; }

public byte Profile_pic { get; set; }

}

controller

Contextclass contextclass = new Contextclass();

[System.Web.Http.HttpPost]

public HttpResponseMessage signup([FromBody] User_details userdetails)------>to here im not getting the image

{

try

{

using(Contextclass contextclass=new Contextclass())

{

var mailverification = emailexits(userdetails.Email);

if(mailverification)

{

return Request.CreateResponse(HttpStatusCode.NotFound, "email_already_exits");

}

userdetails.user_id = Guid.NewGuid();

userdetails.Verification = false;

userdetails.Created_on = DateTime.Now.Date;

user_registration user_Registration = new user_registration();

user_Registration.userregistration(userdetails);

senduserverificationmail(userdetails.Email, userdetails.user_id);

var message = Request.CreateResponse(HttpStatusCode.Created);

return message;

}

catch(Exception ex)

{

return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);

}

if anybody help it will be really appreciated

Thanks in advance.

Thank you

Preetham hd

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
If you are using profile_pic byte to save then change data type to byte[] byte array.

public byte[] Profile_pic { get; set; }

Check this article
https://www.c-sharpcorner.com/article/asp-net-mvc5-upload-imagefile-into-database/
Salman Beg5y ago
Check this link, https://stackoverflow.com/questions/32184360/post-byte-array-to-web-api-server-using-httpclient
Nikunj Satasiya5y ago
Hi Preetham,

Please go through these articles to upload images or files to the database.

https://www.codingvila.com/2019/10/upload-save-file-into-database-as-varbinary-data-in-asp-net-csharp-and-vb-net.html

https://www.codingvila.com/2018/11/angular-js-file-upload-in-asp-dot-net-using-csharp-and-vb-dot-net.html