How can i find null values in a datatable

Question

I have a data table say i have a column like x which is primary key so i should get the row where this x values in empty.thanx in advance

can be primary key null in datatable?

Muhammad Akhtar
– Muhammad Akhtar

2011-03-10 12:18:46 +00:00
Commented Mar 10, 2011 at 12:18 — Muhammad Akhtar
– Muhammad Akhtar, Commented Mar 10, 2011 at 12:18
I think he means the DataTable class of System.Data

cordellcp3
– cordellcp3

2011-03-10 12:23:18 +00:00
Commented Mar 10, 2011 at 12:23 — cordellcp3
– cordellcp3, Commented Mar 10, 2011 at 12:23
ya correct its not sql table

user628347
– user628347

2011-03-10 12:31:28 +00:00
Commented Mar 10, 2011 at 12:31 — user628347
– user628347, Commented Mar 10, 2011 at 12:31

Neil Knight · Accepted Answer · 2011-03-10 12:46:22Z

1

~~SELECT x, y FROM table WHERE y IS NULL~~

Whoops, my bad:

dataTable.Select("FieldName IS NULL")

edited Mar 10, 2011 at 12:46

answered Mar 10, 2011 at 12:08

Neil Knight

48.8k26 gold badges136 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user628347 Over a year ago

Its a DataTable?.so where i should this query

user628347 Over a year ago

but where i will be getting the output

Neil Knight Over a year ago

It will filter your DataTable.

cordellcp3 · Accepted Answer · 2011-03-10 12:25:06Z

0

Another way is to use the WriteXml()- method, which writes the actual content of the DataTable-Object as XML. One is then able to parse it with LINQ to xml.

answered Mar 10, 2011 at 12:25

cordellcp3

3,6331 gold badge20 silver badges14 bronze badges

Collectives™ on Stack Overflow

How can i find null values in a datatable

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related