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();
