Using complex filter expressions while filtering data tables

[GarethKruse]

Hello JohnEfford and everybody,

I ask myself, whether it's also possible to use complex filter expressions in dataTable.dataView.RowFilter and dataTable.Select. For example, how could I apply expressions such as the two expressions below?

select TerritoryDescription, r.RegionId, RegionDescription
from territories t, region r
where t.RegionID=r.RegionId and r.RegionId=1


select * from dataTable1
where id not in (select id from dataTable2)


Any comments are welcomed.

Best regards,

Gareth

 

[JohnEfford]

Mistake in last post

da.SelectCommand = new SqlCommand(SqlText,);

should have been

da.SelectCommand = new SqlCommand(SqlText,cn);

 

[GarethKruse]

Hello JohnEfford,

I think you sent your mail to the wrong thread, because there was no statement like
da.SelectCommand = new SqlCommand(SqlText,);
in your last post you sent to this thread.

Gareth

 

[JohnEfford]

My original post which the last post corrected a line of seems to of disappeared into the ether.

You cannot join tables in memory or do correlated sub queries using data tables. If you needed to do this, for you in memory datatables, you would have write code to do it, the CLR does not provide methods to do it for you.

 

[GarethKruse]

Thank you for your reply JohnEfford.

Gareth