Master Detail filter problem...

  • Thread starter Thread starter Jan Nielsen
  • Start date Start date
J

Jan Nielsen

Hi all
I have a problem with a master detail form that I can't find any solution to
(and I have already searched both the help files and the Internet)

I use Visual Studio 2002 and VB.Net

I have created a typed dataset with two tables (Person and Remarks) and a
master-detail relationship (PersonRemarks)
I have a form with textboxes showing the master row(s).
I have a datagrid showing the detail rows.

I bind the master textboxes like this:
Me.txtFirstname.DataBindings.Add(New System.Windows.Forms.Binding("Text",
Dataset.Persons.DefaultView, "ChristianName"))

(I use the .Defaultview because it makes sorting and filtering much easier.)

Now how do I bind the datagrid so it only shows the detail records?
I tried something like this
RemarksGrid.DataSource = DataSet
RemarksGrid.DataMember = "PersonRemarks"

But it wont work

Tia

Jan Nielsen
 
After you binding dataset to datagrid,
you need to use dataadapter to fill dataset,
dataadapter.fill(dataset)
 
Hi,
Thanks for answering.

I have done that. The records are there.
But the details records are not in sync with the master record.

The problem is how to bind the datagrid to a datarelation, when I bind the
master records to the defaultview in stead of the table

Jan
 
I didn't use datarelation, I just create a dataset for detail table and a
select command for master table. After user change the value then wanted,you
can use the value as select condition,then select record from master and
detail . It must be woking.
 
RemarksGrid.DataSource = DataSet.Tables("Person").DefaultView
RemarksGrid.DataMember = "PersonRemarks"
 
He He.
Thank you sooo much.
It is so simple when someone else tell you
That really made my day (and it is only 9:30 am in Denmark)

Best regards

Jan
 
Hi again
See GKs last answer. That is the correct solution
But thanks for your time

Jan
 
Back
Top