how to show mine text in datalist while NULL in store in databse table

[nittin14]

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

[debasisdas]

Text1.Text = IIf(Not IsNull(rs(0)), "data not found",rs(0))



rest i think u can modify


if using vb.net try ISDBNULL incase of ISNULL




Hope that works for you

[nittin14]

i m using this query for checking NULL value
<%# DataBinder.Eval(Container.DataItem,"promotiondue") == DBNull.Value.ToString() ? "Date not filled" : DataBinder.Eval(Container.DataItem,"promotiondue") %>

but it is not work they r giving error : BC30201: Expression expected


in asp.net i m not using dataset and adapter

my way to execute query is:

sql = "workstation id=IASRI-A51B8POSU;user id=sa;data source = permisnet;initial catalog=permisnet_new;database=Permisnet_new"
objConnect = New SqlConnection(sql)
objConnect.Open()
command = "Select * From personnel "
objCommand = New SqlCommand(command, objConnect)

datalist.DataSource = objCommand.ExecuteReader
datalist.DataBind()
'varReader.Close()
objConnect.Close()

now tell me the solution if u knw

Text1.Text = IIf(Not IsNull(rs(0)), "data not found",rs(0))



rest i think u can modify


if using vb.net try ISDBNULL incase of ISNULL




Hope that works for you