DataTable SELECT = Null

M

maflatoun

Hi,

I have a datatable that I like to do a select on where col1='something'
and col2=empty but the following doesn't return anything even though I
know col2 is empty (length of data = 0). What am I doing wrong? Any
idea?

DataRow[] rows = ds.Tables["CurrentSessions"].Select("SessionID='" +
sessionID + "' AND SupportEmail = NULL");

Also tried SupportEmail = '', SupportEmail IS NULL. It works if I
remove SupportEmail condition.

Thanks
Maz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.Select function in a dataset question 4
SqlCommandBuilder Bug with SQL Server 2005? 2
A DataTable-bound DataGridView throws a low-level Exception whencolumns are sorted, removed and re-a 1
AllowDBNull property 1
DataTable -> DataView -> Sort -> DataGrid : need related DataTable index 4
Select into new Datatable from Datatables 1
Null value Check in DataTable? 4
inserting a row to dataset 9

Top