G
Guest
Hi guys
I have an asp:ListBox on my form, which I'm populating with a DataReader,
using DataSource/DataBind.
The problem is that the main field I want to use for DataTextField,
"Company" in this case, is often blank. How can I get the DataBinding to
go...
"if Company is blank, use ContactName, else use Company"
...is that even possible? Or is there a way I can do this in the SQL somehow?
Hope that makes sense!
Cheers
Dan
I have an asp:ListBox on my form, which I'm populating with a DataReader,
using DataSource/DataBind.
The problem is that the main field I want to use for DataTextField,
"Company" in this case, is often blank. How can I get the DataBinding to
go...
"if Company is blank, use ContactName, else use Company"
...is that even possible? Or is there a way I can do this in the SQL somehow?
Hope that makes sense!
Cheers
Dan