how to display blank image first in asp.net

Question

0.00/5 (No votes)

See more:

ASP.NET

hi,

plaese help me friend,

any product image are blank image those product image are display first in my webpage.

Posted 28-Jul-14 19:30pm

parmarnd

Updated 28-Jul-14 19:52pm

v2

Add a Solution

Comments

_Amy 29-Jul-14 1:38am

What have you tried? Where you stuck?

Thanks7872 29-Jul-14 1:44am

Glad to see you after a long time. :-)

_Amy 29-Jul-14 1:49am

:) Back to home.

Gihan Liyanage 29-Jul-14 1:39am

Please tell some more about your requirement. Cant Understand What you want.

parmarnd 29-Jul-14 1:53am

hi sir,

any product image are blank image those product image are display first in my webpage.

Gihan Liyanage 29-Jul-14 2:01am

ok, Are you using any list views, grid views or any other tables to display products ?

parmarnd 29-Jul-14 2:19am

yes

parmarnd 29-Jul-14 3:08am

thanks for that but,

i have search image in folder and those product image are blank and this image name are display in my web page

Gihan Liyanage 29-Jul-14 3:18am

I want to Clarify following

1. Do you have binary field in SQL to Store the image ?
or
2. Do you save the file path of the image ?

If you are using file path in the SQL table, that will be easy, because you can check the file path and perform Order By.

select * From ProductTable
ORDER BY CASE WHEN ImagePath='D:\Images\searchImage.jpeg' THEN 0 ELSE 1 END, Name

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)

Gihan Liyanage · Answer 1 · 2014-07-28T20:48:00

please see the Example below

http://www.aspsnippets.com/Articles/Display-images-from-SQL-Server-Database-in-ASP.Net-GridView-control.aspx[^]

In your problem, you can change the SQL query to get blank images first.

SQL

select * From [YourTable]
ORDER BY CASE WHEN [ImagePathField] IS NULL THEN 0 ELSE 1 END, [ImagePathField]

Example for Small table.

SQL

select * From Emp1
ORDER BY CASE WHEN Name IS NULL THEN 0 ELSE 1 END, Name

Use This and first see the SQL result is correct. You need to come null values first in the output.

Please Marked as Answered, if you got a help.