View Single Post
  #1 (permalink)  
Old April 28th, 2007, 01:10 AM
nittin14 nittin14 is offline
Authorized User
 
Join Date: Apr 2007
Location: delhi, delhi, India.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to show text in datalist while value in NULL

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