Hi,

I was working on my ASP.NET application in this I need to Fetch the Image link from Database and show the Image and if the Image is not there in Database than i need to display the NoImage…

Simple..

Now, I ask my friends how to achieve this and they suggest me this..

if isdbnull(objSqlcmd.ExecuteScalar) then
Image= “Noimage.gif”
else
Image=objSqlcmd.ExecuteScalar
End if

hmm.. IF image is there .. Show that one other wish show NoImage.gif good one..

But Not for me I found that it actually run the Query twice and for one thing running a query twice is not a good idea..

so,

I do this…

Try
Image=objSqlcmd.ExecuteScalar
Catch
Image=”NoImage.gif”
End Try

and this what I said.. IF I TRY this..

Sumit Gupta