Thursday, October 27, 2005

If I TRY this..

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

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home