filling a table with multiple adaptes

Naison Garvasis

New member
Joined
Feb 24, 2005
Messages
2
Programming Experience
1-3
hi,
I have a dataset with 2 tables(Header and Detail)
I am using 10 adapters to fill the dataset(5 for Header and 5 for
detail).
All the adapters are having same columns(schema) as the tables in the
dataset.


While filling the dataset using the adapters one by one, i am not
getting the expected data. First adapter is filling the table with all
the data, second adapter is filling the table with two row(expected is
11 row) and so on..


but if i am filling the dataset table with only one adapter at a time
then i am getting the expected result.


i am adding the code wich i am using to fill the dataset.


thank you
Naison


dsDayBook.Clear();


daGVHeader.Fill (dsDayBook.Header);
daGVDetail.Fill (dsDayBook.Detail);


daPVHeader.Fill (dsDayBook.Header);
daPVDetail.Fill (dsDayBook.Detail);


daRVHeader.Fill (dsDayBook.Header);
daRVDetail.Fill (dsDayBook.Detail);


daPIHeader.Fill (dsDayBook.Header);
daPIDetail.Fill (dsDayBook.Detail);


daRIHeader.Fill (dsDayBook.Header);
daRIDetail.Fill (dsDayBook.Detail);
grid.DataSource = dsDayBook;
grid.DataBind() ;
 
Hi,

i myself could clear the issue.
Different adapters were having data with same primay key. So while filling the dataset
such row were ignored. I tried to fill the dataset by reading through a datareader and could fix the issue.

Naison
 
Back
Top