Dataset with multiple tables

Andrea

I have a data structure composed with a dataset with multiple tables
connected through relationship. I'm using different table adapters of the
dataset for load table, but when i use the select method on master table
,data store in the other table are not filter.
I think that when there are relation with table a filter apply on table have
effect on the relate table drive by relation.
Any suggestions?
Regards
Andrea

Oct 18 '08 #1

Subscribe Post Reply

1376

John Saunders

"Andrea" <an***************@xws.itwrote in message
news:eD**************@TK2MSFTNGP02.phx.gbl...

I have a data structure composed with a dataset with multiple tables
connected through relationship. I'm using different table adapters of the
dataset for load table, but when i use the select method on master table
,data store in the other table are not filter.
I think that when there are relation with table a filter apply on table
have effect on the relate table drive by relation.

Andrea, DataTable.Select doesn't even filter the master table. It returns an
array of rows.

I don't know if there is any way to filter so that master rows are selected
and then only the detail rows that are children of the master rows, etc.

--
John Saunders | MVP - Connected System Developer

Oct 18 '08 #2

Similar topics

Question about a dataset

by: Simon Harvey | last post by:

Hi everyone, I was wondering if it is possible, to use SQL to return more than one table at a time into a dataset. I only know the basics of SQL and so I'm not sure if I'm just asking a stupid...

.NET Framework

Dataset and table names.....

by: Jim | last post by:

I have a stored procedure that queries a sql server database and returns the multiple data tables ( 7 to be precise) these tables are the results of many joins. When I use the...

C# / C Sharp

Dataset with multiple Datatables

by: | last post by:

Hi, I have an app that uses a typed dataset to persist user data. The dataset has a multiple tables with multiple table relations. The problem I am running into is that the user data is...

C# / C Sharp

Dataset with Multiple Datatables

by: John Bailey | last post by:

I have a dataset with multiple data tables. I need to bind this to a wizard interface, where each portion of the wizard udates the information in one of the datatables. I am using formviews in...

ASP.NET

how to update dataset w/ multiple table?

by: jaYPee | last post by:

I have search a lot of thread in google newsgroup and read a lot of articles but still i don't know how to update the dataset that has 3 tables. my 3 tables looks like the 3 tables from...

Visual Basic .NET

fill dataset/grid with multiple queries from multiple servers

by: Dave Edwards | last post by:

I understand that I can fill a datagrid with multiple queries, but I cannot figure out how to fill a dataset with the same query but run against multiple SQL servers, the query , table structure...

Visual Basic .NET

retrieve single value from dataset

by: Peter | last post by:

Gday, I have a dataset with multiple tables, from which I want to access a single value in one of those tables. I know I can do something like: Decimal myVar =...

C# / C Sharp

Multiple Table DataSet

by: samoore33 | last post by:

I want to list all of the items in a dataset in a textbox. The dataset has multiple tables. When I try to use the code below, even though I dim myState as the DataTable("state"). It still looks for...

Visual Basic .NET

Looking for a simple explanation of how to walk through a dataset in .net 2.0

by: SmartbizAustralia | last post by:

Hi, This seems to be a neglected bit of info as everyone gets carried away with data binding examples instead. Can simply use the datareader as below: Private Sub PopulateControls1() Dim...

Visual Basic .NET

Working with Complex DataSet - Creating and Pass thru Transformati

by: =?Utf-8?B?c2lwcHl1Y29ubg==?= | last post by:

Have a complex process where I need to Import a large amount of data then run some transformations on this data then import into DataBase. The transformation involves multiple fields and multiple...

C# / C Sharp

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++