Re: Quering DataSet

Atul,

You might be interested in the assembly I've been working on at
http://www.queryadataset.com. Besides INNER JOINS, it lets you perform
complex SQL SELECT statements including UNION, OUTER JOINS, GROUP BY,
HAVING, ORDER BY, sub-queries, etc against the tables in a dataset.

Adrian Moore

"Atul Sureka" <atul_sureka@xxxxxxxxxxxxxxxx> wrote in message
news:%23xvnQ3t4FHA.3876@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I have a DataSet which contains two tables - Let us say table T1 and T2.
> I want to fire a query on these two tables and get the result in the 3rd
> table T3(Say).
> How to do that in C# .Net ?
>
> Regards
> Atul Sureka
> Nagpur - India
>
>


.

Relevant Pages

  • Re: Establishing Precedence In ORDERBY Condition Causing Problems.
    ... inner joins - so you should either modify the query to use inner join ... Hugo Kornelis, SQL Server MVP ... WHEN 1 THEN registerDate ... from PersonalPhotos withunion select distinct email_address ...
    (comp.databases.ms-sqlserver)
  • Re: ADO.NET performance with large tables
    ... Besides INNER JOINS, it lets you perform ... complex SQL SELECT statements including UNION, OUTER JOINS, GROUP BY, ... > You won't be able to real JOINs or SELECTs with ADO 2.0 (on local DataSet ...
    (microsoft.public.data.ado)
  • Re: query DataSet
    ... Besides INNER JOINS, it lets you perform ... complex SQL SELECT statements including UNION, OUTER JOINS, GROUP BY, ... Is there a way to query dataset, or should i go to database for that. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: .Net 2.0 DataTable have a lot of lacks?
    ... Besides INNER JOINS, it lets you perform ... complex SQL SELECT statements including UNION, OUTER JOINS, GROUP BY, ... > so i can load data from remote service and manipulate it and after i ... > have some Project that extend DataTable abilities? ...
    (microsoft.public.dotnet.framework.adonet)