Is the following question possible to do in .Net

  • Thread starter Thread starter Vinay Bhushan
  • Start date Start date
V

Vinay Bhushan

Child Dataset
{
i int;
j string;

}

Master Dataset
{
i int;
j String;
k float;

}

childDataset. rows = 10,
masterDataset.rows = 20;

i want to look that the child dataset is contained in the master
dataset or not.

Note that the schema of the master set is not the same as schema of
child but child schema is contained in the master schema.

the intersection of these two would lead in 8 rows which match

right of would give me a 2 rows.
left of would give me a 12 rows.

is there any class already available which does this for me in C# or
should i be looking for writing my own crap logic to do this.

If its available i would like to use the best code.

Appriciate your help in regard to this.

Vinay
 
ADO.NET does not have a query engine (at least not yet). It does not know
how to do a JOIN as you have described.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
If you are using .NET 2.0, you may want to look at loading
your data directly into a generic List<T>. Having intellisense
when querying against the list with the .Find and .FindAll
is nice and makes for much cleaner code.

--
Robbe Morris - 2004-2006 Microsoft MVP C#
I've mapped the database to .NET class properties and methods to
implement an multi-layered object oriented environment for your
data access layer. Thus, you should rarely ever have to type the words
SqlCommand, SqlDataAdapter, or SqlConnection again.
http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp
 
Back
Top