Do not display Columns which are not null

Question

I have 10 columns in my table among those three columns are date fields. I am using SQL DATASOURCE in ASP.NET. 

I want to display all the records which are null and also display records any one column is also null. But not the records which are not null.

 

SELECT COLUMN1, COLUMN2, COLUMN3, COLUMN4,column5,column6, column7, column8, column9, column10 FROM TABLE

WHERE column8 is null or column9 is null or column10 is null

 

How can I Achieve this in SQL Datasource, with editible option.