DropDownList can't bind to DbNull

Question

I have a DropDownList trying to bind to DbNull and it's not happy about it. I've seen advice about creating a ListItem with value=" " but this isn't working.

Any help would be much appreciated.

Answer 1

if you want to add default value to dropdwon list you can do it as below

 mydropdown.DataSource = getdata();
 mydropdown.DataBind();
 mydropdown.Items.Insert(0,new ListItem("N/A","N/A"));

Edit

if you know some values of the datasouce is null than y dont you filter out those value at database level and than bind soruce with the drop down. or make use of Isnull() in query and assing default value to null values.