How to use datasets like tables with complex where condition?

Hot Topic

date problem
DataSet Parent/Child relation filtering problem??
SEHException from External Component Error
Return a Datatable using .NET2.0 Webservice
Porting C++ pointer code to C#
How to know if client loses connection, etc
How can I call .NET 2.0 components from .NET 1.1?
changing the way the SQL command read date
Release version of CLR Profiler for .Net 2.0
WINDOWS service

.NET Development

File of All .NET 2.0 classes
Datatable through Web Service using .Net Framework 2.0
how to use \r,\n in the xml
insertion problem
Typed DataSet custom code...
Advice on Parameter problem with Odbc call returning multiple result sets
COM .NET Interop - How to return a DataTable from NET to COM VB6
Microsoft .Net FrameWork 1.1 is installing spyware on my pc!!!!!!!!
Unmanaged host App catching events from managed
representing XmlElement

How to use datasets like tables with complex where condition?

I have a dataset with two related tables in it. What I want to do is create a collection of rows (either table or dataview) to match the following in sql

select a.w, a.x, b.z
from a
inner join b on a.w = b.w
where a.x = 'xxx'
and b.y = 'yyy'

I can create a dataview using rowfilters on one table, and I know I can just use the sql to create the data, but how to do it on two related tables




Answer this question

How to use datasets like tables with complex where condition?

  • r2d2

    rvghst,

    Add a column to your "a" table and name it "bz".

    Set the "bz" expression to: parent('ab').z .

    Use the select statement x = 'xxx' and bz = 'yyy' on your altered table.



  • kstephan

    The dataset doesn't support this. You would have to write the code to query each table seperately.
  • How to use datasets like tables with complex where condition?
Answer this question