<_a s p :Label runat="server" ID="Label6" Text='< % # IIF(Typeof( Eval("ShippedDate")) IS DbNull,"No Date",Eval("ShippedDate")) % >' />or
<_%# ((Convert.IsDBNull ...
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.
<_%# ((Convert.IsDBNull(DataBinder.Eval(Container.DataI tem, "height"))) ? "" : "height = " + DataBinder.Eval(Container.DataItem, "height")) %>Or maybe this for NULLs?:
<_%# Eval("First", "{0}, ") %_>
Or check for NULL in T-SQL:
ISNULL(check_expression, replacement_value)
If 1st is NULL, return 2cnd.
No comments:
Post a Comment