Query datatable to get the count

Question

0.00/5 (No votes)

See more:

I want to know the count of specific strings present in the datatable

C#

var Contact = (from DataRow dr in dtRec.Rows
                                         where dr["Recommendations"] == strContactVibration
                                         select dr).ToList();

but i am getting count as 0 where i am doing wrong?

Posted 21-Oct-14 1:46am

chandra sekhar

Updated 21-Oct-14 1:48am

v3

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mukesh Ghosh · Accepted Answer · 2014-10-21T01:57:00

Solution 1

Use Tostring ,it should work like

SQL

var Contact = (from DataRow dr in table.Rows
                       where dr[Recommendations].ToString() == "m"
                       select dr).ToList();

Posted 21-Oct-14 1:57am

Mukesh Ghosh

Comments

chandra sekhar 21-Oct-14 8:54am

Thanks that worked.

Mukesh Ghosh 22-Oct-14 0:13am

Hi 5 :)

Query datatable to get the count

1 solution

Solution 1

Add your solution here

Preview 0

Query datatable to get the count

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us