PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Problem: Master / Detail + DataRelation + DataView

Reply

Problem: Master / Detail + DataRelation + DataView

 
Thread Tools Rate Thread
Old 16-09-2006, 10:52 AM   #1
=?Utf-8?B?QXJpZg==?=
Guest
 
Posts: n/a
Default Problem: Master / Detail + DataRelation + DataView


Hi all,

Testing with
Database : Nortwind
Master Table : Customers
Detail Table : Orders

DataRelation : relCustomersOrders

On Form_Load, DataAdapter fills the dataset with above two table and creates
a DataRelation. Everything is OK. When I click on a row of
MasterGrid(Customers) then DetailGrid(Orders) automatically shows the related
records.

For filtering on MasterGrid I use a DataView on Customers table. On
TextChange event of a textbox the MasterGrid shows only records matches
CustomerID with the textbox.

PROBLEM:
Now I click on any row of MasterGrid the DeatilGrid doesn’t show the related
detailed records automatically. Before using DataView on MasterGrid it was
OK. But when MasterGrid is associated with DataView for filtering, the
DeatailGrid doesn’t show related record.

I also tried with DataViewManager but I observe that DataViewManager filters
records only once after DataTable fill. After DataTable fill I try to filter
on other conditions but there is no filtering.

Please notify where I m doing mistake. A kind help required,
Arif.



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off