Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

check for DbNull

Tags: null dbnull

Check for DbNull:

<_a s p :label runat="server" text='< % # IIF(Typeof(
Eval("ShippedDate")) IS DbNull,"No Date",Eval("ShippedDate")) % >'>
or <_ ...> I am telling ASP to give the picture a height value only if the value in the database is not NULL. I could've done this in the SQL instruction, but I decided to do it inside the Datalist.
<_ tem : databinder.eval>
Or maybe this for NULLs?: <_ eval> Or check for NULL in T-SQL: ISNULL(check_expression, replacement_value) If 1st is NULL, return 2cnd.


This post first appeared on Programmabilities, please read the originial post: here

Share the post

check for DbNull

×

Subscribe to Programmabilities

Get updates delivered right to your inbox!

Thank you for your subscription

×