My requirement is to get the images from the database and display in front end.In my case i am using asp.net MVC . Database ir oracle and the data type of the image is blob .The follwing is my code
**Model**
This is the Model for the class and it has two properties ImageDisplay and ImageStream.
public class SelectionModel
{
public byte[] ImageDsiplay
{
get;
set;
}
public MemoryStream ImageStream
{
get;
set;
}
}
**Controller Code**
In the controller i am trying the get the image from he database and assign to the Model.
public ActionResult Index()
{
SelectionModel sel = new SelectionModel();
List<SelectionModel> lissel = new List<SelectionModel>();
byte[] imagedata;
string sql = "select filecontent from filestore";
OracleConnection con = new OracleConnection(ConStr);
OracleCommand com = new OracleCommand(sql, con);
try
{
con.Open();
OracleDataReader dr;
dr = com.ExecuteReader();
while (dr.Read())
{
imagedata = (byte[])dr[0];
sel.ImageDsiplay = imagedata;
var stream = new MemoryStream(sel.ImageDsiplay);
sel.ImageStream = stream;
lissel.Add(sel);
}
}
catch (Exception ex)
{
}
Here i am trying to return the list .
return View(lissel);
}
**View Code**
The Following is the view code and it should display the image .
@model IEnumerable<goldforgold.models.selectionmodel>
<table>
<tr>
<td>
@foreach (var item in Model)
{
<img src="@Url.Action("Index", "Selection")" alt="myimage" />
// <img src="@(item.ImageStream).png" alt="Alternate Text" />
}
</td>
</tr>
</table>
My requirement is to get the images from the database and display in front end.In my case i am using asp.net MVC . Database ir oracle and the data type of the image is blob .The follwing is my code
**ISSUE**
The issue is i am not able to display the images from the database.