How can i set dynamic picture in Picture Control of Crystal Report Viewer from database in Visual Studio?

Question

0.00/5 (No votes)

See more:

Hi all experts,
I have designed crystal report on vb.net already and i want to display the picture on my item to that report. i dropped Picture Control on CR and i try to find the property of this control to set the picture path from database but i don't see it. Does anybody know about this?
Note:
- I use Visual Studio 2008
- CR Version 2008

Thanks

TONY

Posted 25-Mar-13 15:21pm

soeun tony

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raimis9 · Answer 1 · 2013-03-26T02:52:00

Solution 1

Hi,

you need to add image column (byte[]) to the table, add the column to report, (not Picture control, but field) :

VB

data.Tables(0).Columns.Add("img", System.Type.GetType("System.Byte[]"))

' fill the table with pictures from database or file system
'...
'...

' create a report
Dim cr As New CrystalReport1()

' pass a dataset  to a report 
cr.SetDataSource(data.Tables(0))

' pass a reportdocument to the viewer
CrystalReportViewer1.ReportSource = cr

Where "data" is your dataset.

Posted 26-Mar-13 2:52am

Raimis9

Comments

soeun tony 26-Mar-13 23:25pm

Hi Raimis9,
Thanks for ur reply. The path of image already store in database ( I have other application and that application store path of image only). So it means that i don't build application by myself but i can create CR and insert to that application.

TONY

Raimis9 27-Mar-13 3:56am

CR can't load and show image by file path only.