Master Detail filter problem...

[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

 

[yonggangwang]

After you binding dataset to datagrid,
you need to use dataadapter to fill dataset,
dataadapter.fill(dataset)

 

[Jan Nielsen]

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

 

[yonggangwang]

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.

 

[GK]

RemarksGrid.DataSource = DataSet.Tables("Person")
RemarksGrid.DataMember = "PersonRemarks"

 

[GK]

RemarksGrid.DataSource = DataSet.Tables("Person").DefaultView
RemarksGrid.DataMember = "PersonRemarks"

 

[Jan Nielsen]

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

 

[Jan Nielsen]

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

Jan