asp.net how to make gridview display where an image datatype value is not null (sql)

Question

0.00/5 (No votes)

See more:

, +

i did a page where it shows data from sql database, where it is shown in a gridview. i can now then choose the id to be print or to show image in another tab.

my problem is the image data type in column. at it shows no preview icon.

the easy way is to set "nulldisplay" with a value "no image" if no image is attach

http://i1228.photobucket.com/albums/ee443/jaylisto/question%20config_zpsuytusnba.jpg[^]

else show a small picture like an icon or just show " with attachment" text if image exist.

thats my problem, where no settings is available for "notnulldisplay" = " with image"

take a look at this example.
http://i1228.photobucket.com/albums/ee443/jaylisto/question_zpsmujru6af.jpg[^]

no code is necessary to show, clicking the gridview setting and configure the connection to the sql database.

additional info:
I'm using visual studio 2010, asp.net with c#,
the image is uploaded directly in the sql database as an image file.

Posted 8-May-15 21:45pm

jaylisto

Updated 8-May-15 21:53pm

v2

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2015-05-09T05:18:00

Solution 1

This option is available with ImageField. Property is NullImageURL.

Refer - Re: how to set default image in asp.net[^]

Posted 9-May-15 5:18am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

jaylisto 9-May-15 11:25am

you did not understand my question.....

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-May-15 11:28am

Okay explain me here.

jaylisto 9-May-15 23:56pm

i did not put any imagefield with in the form. the blank image as you see in the picture is with in the gridview from sql database. the configuration is with in the gridview. if im the one who did not understand the answer please reply here, how ever i did look for an imagefield property in the grid view but theres nothing. thanks.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 10-May-15 6:50am

Hey the process you are following is called Smart Tag. But after you did so, it generates the markup for you on aspx page.

There is a ImageField. See the first image link you have given. Check the "Available Fields" section. The ImageField is there.

If you want to know more, then read - ImageField Class.