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.