hello guys,
pls solve my problem
my problem is that
i m retreive data from table but in some column the value is store NULL. i want that insist of NULL it wl display some text in datalist while data retreive from databse

Eg.
employee //table name

Date //column name

14/6/82
NULL
15/6/82

i want display it in this format

employee //table name

Date //column name

14/6/82
Date Not Filled
15/6/82

is it possible if yes then send me solution of this problem with the help of example.
thanks

Depends how you are filling your datalist, one way could be checking for null from database itself using the ISNULL function, another way could be checking for null while binding, something like below:

<asp:Label Runat="server" ID="lblTest" text='<%#DataBinder.Eval(Container.DataItem,"no")= = DBNull.Value.ToString() ? "Date not filled" : DataBinder.Eval(Container.DataItem,"no")%>'>

There could be lot other ways too....

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

helo sir,
 this is not working
it is giving error:

 BC30201: Expression expected

i m using ur solution in datalist like this:

<%# DataBinder.Eval(Container.DataItem,"promotiondue") == DBNull.Value.ToString() ? "Date not filled" : DataBinder.Eval(Container.DataItem,"promotiondue") %>

but they r not executing
can u send the sloution

Personally, I do this in my SQL statements so I do not have to deal with NULL values in code.

SELECT ISNULL([column], 'No Data') as [column] FROM [table]

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

hey dparsons: great, great great aproach... you've just solved my misery... ;)

==============================================

...no such things as a day at the beach..