Display (Show) Image from Folder (Directory) in RDLC Report in ASP.Net MVC

onvar119...

SOLVED CLOSED ACTIVE ANSWERED
User: onvar1196
Posted: on Mar 29, 2024 10:18 PM
Forum: ASP.Net MVC
Answer: 1
Views: 5313
Sample Code: Download

I have a product table, here is my id, the key is one to one related to the field named urunid in this image table, again here the path of the image is written in the field named buyukyol, I keep all the images in the images folder, I can bring the images according to the product id in MVC forms, there is no problem with this, but the same process is microsoft.reportviwer.webforms.

I want to display the images related to this from the image table according to the product id, from the image table according to the product id, from the images folder, according to the product id, whether the extension is jpeg or not.

I created a file called mydataset. In the same way, I created a structure called datatable3, and I just called it bigpath. This means that on the SQL side, it has the same name as the field in the image table. In the dataset section, I created a tab named Onurun, the id and name appeared in it, I also created a tab Onurimim, and Büyükyol appeared on its own, briefly, I added the datasets and then I took a table from a toolbox and put it in the design section, put the id and name variables in it, then added the second table from the toolbox, made a one-column table and added an image element to the first column.

I want the images of the id to appear here, but are they embedded in the datasource section of the image element, database or external? I will use it, I couldn't figure it out, I tried the database, I found the official dataset of Onur from the dataset option in the use this field and selected it on the FX floor, but also I left tooltip blank, my report works fine if I don't have a picture, but I couldn't do image, I couldn't figure out how to access this image, in short, I couldn't list non-binary jpg files from the pictures folder or not, I couldn't send dataset and rdlc files because you don't have a graphical interface.

Best regards

<td><a href="/baski.aspx?bulid=@urunler.id" class="btn btn-danger">LİSTELE URUNU </a></td>

baski.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="baski.aspx.cs" Inherits="onibrticari.WebForm1" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
 <title></title>
</head>
<body>
 <form id="form1" runat="server">
 <div>
 <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
 <rsweb:ReportViewer ID="ReportViewer1" runat="server"></rsweb:ReportViewer>
 </div>
 </form>
</body>
</html>

protected void Page_Load(object sender, EventArgs e)
{
    deger = Request.QueryString["bulid"];
    if (Page.IsPostBack == false)
    {
        SqlConnection baglan = new SqlConnection(@"Data Source=DESKTOP-1B3OQRL;Initial Catalog=ibroz;Integrated Security=True");
        SqlDataAdapter da = new SqlDataAdapter("select urun.* ,resim .* from urun inner join resim on urun.id =resim.urunid where urun.id='" + deger + "' ", baglan);
 
        DataTable dt = new DataTable("urun");
        da.Fill(dt);
        ReportViewer1.ProcessingMode = ProcessingMode.Local;
        ReportViewer1.LocalReport.ReportPath = Server.MapPath("report1.rdlc");
        ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("onururun", dt));
        ReportViewer1.LocalReport.Refresh();
        baglan.Close();

dharmend...

0 6

Reply
ANSWER
User: dharmendr
Replied: on Mar 30, 2024 12:40 PM
Modified: on Mar 30, 2024 12:56 PM
Report

Hi onvar119,

Refering the following article i have created a sample. Take reference of the code and modify accordingly.

Implementing RDLC Reports in ASP.Net MVC

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        NorthwindEntities entities = new NorthwindEntities();
        return View(from customer in entities.Customers.Take(5)
                    select customer);
    }
}

View

@model IEnumerable<Customer>
@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    <h4>Customers</h4>
    <hr />
    <table cellpadding="0" cellspacing="0">
        <tr>
            <th>Customer ID</th>
            <th>Contact Name</th>
            <th>City</th>
            <th>Country</th>
            <th></th>
        </tr>
        @foreach (Customer customer in Model)
        {
            <tr>
                <td>@customer.CustomerID</td>
                <td>@customer.ContactName</td>
                <td>@customer.City</td>
                <td>@customer.Country</td>
                <td><a href="~/Report.aspx?Id=@customer.CustomerID">View Report</a></td>
            </tr>
        }
    </table>
</body>
</html>

For displaying image from Folder, i refered the following article and configured the image in RDLC report.

Display (Show) Image from folder in RDLC Report in ASP.Net using C# and VB.Net

After configuring the report designer with the report parameter will look as shown below.

Report

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Report.aspx.cs" Inherits="RDLC_Report_MVC.Report" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" 
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager runat="server"></asp:ScriptManager>
        <rsweb:ReportViewer ID="ReportViewer1" runat="server"></rsweb:ReportViewer>
    </form>
</body>
</html>

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string id = Request.QueryString["Id"];
        ReportViewer1.ProcessingMode = ProcessingMode.Local;
        ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report.rdlc");
        NorthwindEntities entities = new NorthwindEntities();
        ReportDataSource datasource = new ReportDataSource("Customers", (from customer in entities.Customers.Take(10)
                                                                            where customer.CustomerID.Equals(id)
                                                                            select customer));
        ReportViewer1.LocalReport.EnableExternalImages = true;
        string imagePath = new Uri(string.Format(Server.MapPath("~/Images/{0}.jpg"), id)).AbsoluteUri;
        ReportParameter parameter = new ReportParameter("ImagePath", imagePath);
        ReportViewer1.LocalReport.SetParameters(parameter);
        ReportViewer1.LocalReport.DataSources.Clear();
        ReportViewer1.LocalReport.DataSources.Add(datasource);
    }
}

Screenshot

Display (Show) Image from Folder (Directory) in RDLC Report in ASP.Net MVC

Company

Explore

Follow us

Contact Us