Dear ProgramerAnyone have a solution for my issueI want to load Images on PageLoad using Parameters from my databasehere is my code that is not load images and display blank field protected void ImageLoad string RegdPhoto 3434 string RegdSign 3434 SqlConnection cnn new SqlConnection cnnConnectionString SystemConfigurationConfigurationManagerConnectionStrings34carecnn34ConnectionString

Hi AnkitPalI have created sample code which fulfill your requirementHTMLltform id34form134 runat34server34gtltdivgt ltaspScriptManager ID34ScriptManager134 runat34server34gt ltaspScriptManagergt ltrswebReportViewer ID34ReportViewer134 Width34700px34 runat34server34gt ltrswebReportViewergtltdivgtltformgtCstring conString ConfigurationManagerConnectionStrings34constrtest34ConnectionStringprotected void PageLoadobject sender EventArgs e if IsPostBack thisGetData private void GetData ReportViewer1ProcessingMode ProcessingModeLocal ReportViewer1LocalReportReportPath ServerMapPath34Report2rdlc34 ReportViewer1LocalReportEnableExternalImages true DataSet1 dsCustomers GetData34SELECT FROM STUDENTFILE34 string picsImagepath new UriServerMapPath34Images34 dsCustomersTables0

How to Display Images whose image name stored in Database In RDLC Report

AnkitPal

SOLVED CLOSED ACTIVE ANSWERED
User: AnkitPal
Posted: on Feb 10, 2017 05:10 AM
Forum: Crystal Reports with ASP.Net
Answer: 1
Views: 9096

Dear Programer,

Anyone have a solution for my issue,

I want to load Images on PageLoad using Parameters from my database.

here is my code that is not load images and display blank field...!!!

protected void ImageLoad()
        {
            string RegdPhoto = "";
            string RegdSign = "";
            SqlConnection cnn = new SqlConnection();
            cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["care_cnn"].ConnectionString;
            cnn.Open();
            lblsturegdno.Text = Request.QueryString["Id"];
            lblrndrpwd.Text = Request.QueryString["Pwd"];
            SqlCommand cmd = new SqlCommand("select * from kycimages where Id = '" + lblsturegdno.Text + "' and Pwd = '" + lblrndrpwd.Text + "'", cnn);
            SqlDataReader rdr = cmd.ExecuteReader();
            if (rdr.Read())
            {
                RegdPhoto = rdr["Photo"].ToString();
                RegdSign = rdr["Sign"].ToString();
            }
            ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Stu_KYC/New_Regd Print.rdlc");
            ReportViewer1.LocalReport.EnableExternalImages = true;
            string imagePath = new Uri(Server.MapPath("~/Img/ecc-logo.PNG")).AbsoluteUri;
            ReportParameter p = new ReportParameter("ImagePath", imagePath);
            ReportParameter p1 = new ReportParameter("Parameter_Photo", RegdPhoto);
            ReportParameter p2 = new ReportParameter("Parameter_Sign", RegdSign);
            ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { p, p1, p2, });
            ReportViewer1.LocalReport.Refresh();

            Warning[] warnings;
            string[] streamIds;
            string mimeType = "";
            string encoding = "";
            string extension = "";
            //ReportParameter[] param = new ReportParameter[3];
            //param[0] = new ReportParameter("ImagePath", imagePath);
            //ReportViewer1.LocalReport.SetParameters(param);
            byte[] bytes = ReportViewer1.LocalReport.Render(
                "PDF",
                null,
                out mimeType,
                out encoding,
                out extension,
                out streamIds,
                out warnings);

            Response.ClearContent();
            Response.Buffer = true;
            Response.ContentType = "application/pdf";
            Response.BinaryWrite(bytes);
            Response.Flush(); // send it to the client to download
            Response.Clear();
            Response.End();
        }

Download FREE API for Word, Excel and PDF in ASP.Net

Indresh

0 8

Reply
ANSWER
User: Indresh
Replied: on Feb 15, 2017 03:35 AM
Report

Hi AnkitPal,

I have created sample code which fulfill your requirement.

HTML

<form id="form1" runat="server">
<div>
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <rsweb:ReportViewer ID="ReportViewer1" Width="700px" runat="server">
    </rsweb:ReportViewer>
</div>
</form>

string conString = ConfigurationManager.ConnectionStrings["constrtest"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.GetData();
    }
}

private void GetData()
{
    ReportViewer1.ProcessingMode = ProcessingMode.Local;
    ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report2.rdlc");
    ReportViewer1.LocalReport.EnableExternalImages = true;
    DataSet1 dsCustomers = GetData("SELECT  * FROM STUDENTFILE");
    string picsImagepath = new Uri(Server.MapPath("~/Images/" + dsCustomers.Tables[0].Rows[0]["Pics"] + "")).AbsoluteUri;
    string SignImagepath = new Uri(Server.MapPath("~/Images/" + dsCustomers.Tables[0].Rows[0]["Sign"] + "")).AbsoluteUri;
    ReportParameter parameter = new ReportParameter("Pics", picsImagepath);
    ReportParameter parameter1 = new ReportParameter("Sign", SignImagepath);
    ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { parameter, parameter1 });
    ReportViewer1.LocalReport.DataSources.Clear();
}

private DataSet1 GetData(string query)
{
    string conString = ConfigurationManager.ConnectionStrings["constrtest"].ConnectionString;
    SqlCommand cmd = new SqlCommand(query);
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;

            sda.SelectCommand = cmd;
            using (DataSet1 dstest = new DataSet1())
            {
                sda.Fill(dstest, "DataTable1");
                return dstest;
            }
        }
    }
}

Vb.net

Private conString As String = ConfigurationManager.ConnectionStrings("constrtest").ConnectionString
Protected Sub Page_Load(sender As Object, e As EventArgs)
	If Not IsPostBack Then
		Me.GetData()
	End If
End Sub

Private Sub GetData()
	ReportViewer1.ProcessingMode = ProcessingMode.Local
	ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report2.rdlc")
	ReportViewer1.LocalReport.EnableExternalImages = True
	Dim dsCustomers As DataSet1 = GetData("SELECT  * FROM STUDENTFILE")
	Dim picsImagepath As String = New Uri(Server.MapPath("~/Images/" + dsCustomers.Tables(0).Rows(0)("Pics") + "")).AbsoluteUri
	Dim SignImagepath As String = New Uri(Server.MapPath("~/Images/" + dsCustomers.Tables(0).Rows(0)("Sign") + "")).AbsoluteUri
	Dim parameter As New ReportParameter("Pics", picsImagepath)
	Dim parameter1 As New ReportParameter("Sign", SignImagepath)
	ReportViewer1.LocalReport.SetParameters(New ReportParameter() {parameter, parameter1})
	ReportViewer1.LocalReport.DataSources.Clear()
End Sub

Private Function GetData(query As String) As DataSet1
	Dim conString As String = ConfigurationManager.ConnectionStrings("constrtest").ConnectionString
	Dim cmd As New SqlCommand(query)
	Using con As New SqlConnection(conString)
		Using sda As New SqlDataAdapter()
			cmd.Connection = con

			sda.SelectCommand = cmd
			Using dstest As New DataSet1()
				sda.Fill(dstest, "DataTable1")
				Return dstest
			End Using
		End Using
	End Using
End Function

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to Display Images whose image name stored in Database In RDLC Report

Company

Explore

Follow us

Contact Us