How to filter DataTable

Question

0.00/5 (No votes)

See more:

Hello sir/madam

I would like to filter a datatable.
For that I am using LINQ in this way its not working its give an error

"The source contains no DataRows."

First i get a value in a datatable dt.
now i am using LINQ

C#

var query = from r in dt.AsEnumerable()
               where r.Field<string>("AI_No_Of_Conception") == ""
                     select r;
       DataTable   dtLink=new DataTable();
               dtLink = query.CopyToDataTable();

If any another option how to apply a query on datatable and bind it another Datatable then please suggest my.

Posted 29-Nov-12 1:10am

Rohit Sharma706

Updated 29-Nov-12 1:12am

André Kraak

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

codeninja-C# · Answer 1 · 2012-11-29T02:33:00

Solution 2

Hi
Try this out,

C#

var query = from r in dt.AsEnumerable() where 
String.Equals(r.Field<string>("AI_No_Of_Conception"),"")                             
select r;
// any one please suggest an idea to optimize the following two lines
if(result.Count() >0)// to avoid exception "The source contains no DataRows"
            dtLink = result.CopyToDataTable();

--SJ

Posted 29-Nov-12 2:33am

codeninja-C#

Updated 29-Nov-12 18:08pm

v3

Comments

Rohit Sharma706 29-Nov-12 23:55pm

thnx for rply.
its work to get the value on select query but when bind this value to datatable (dtLink = query.CopyToDataTable();) then i get an error "The source contains no DataRows."
so if you have any idea how to bind it into datatable then plz suggest me.

codeninja-C# 30-Nov-12 0:10am

Hi,
I updated my result and it will be working fine, but find the better way to avoid that exception. Once you find let me know
--SJ

sinhasourabh · Answer 2 · 2012-11-29T01:13:00

Solution 1

I faced the same issue some time back and figured out that the rootcause is very silly you need to use linq query like this

C#

var query = from r in dt.AsEnumerable()
where r.Field("AI_No_Of_Conception").ToString() == ""
select r;

just use Tostring()

Posted 29-Nov-12 1:13am

sinhasourabh

Comments

Rohit Sharma706 29-Nov-12 7:39am

thx for rply.
but sorry to say that your suggestion is not working because its argument exception over Field<t>