ListBox Showing Nulls

[chezealot9]

Hey Guys, I have a listbox running off of a query that basically has two fields, a key field and a "combined" field with several fields concatenated, so I can show multiple things in the listbox. Im getting blank rows in my list box, in between rows of data and Ive isolated it to a problem with the concatenated field when one of the individual elements is null or blank etc., How can I get around these nulls so they either show up blank or something else etc.

Thankyou greatly for any help you can lend!!

 

[LV]

I would probably try something like this:

if(Convert.IsDBNull(datareader["myField"])){
// concatenate with empty string
}
else{
// concatenate with value
}

 

[checkai]

If you grab everything in your query then just do something like this

select isnull(name,'') && isnull(sex,'')

can't remember joining operators right now...

dlc