Ahmad,
The DataRowView object exposes a CreateChildView method. You can supply the name of the DataRelation and the method returns a DataView object set to display just the child rows using that relationship.
Your code would look something like this:
DataView vueParent = dsParent.ParentTable.DefaultView;
DataRowView rowParent = vueParent[intIndex];
DataView vueChild = rowParent.CreateChildView("RelationName");
gridChild.DataSource = vueChild;
gridChild.DataBind();
>Hi Cathi,
>
>Thank you for your reply.
>I am using a DataSet with 7 DataTables and have a DataRelation between them, if I used DataView with the table that I need to use it in the DataGrid I think I'll lose the DataRelation to that table ( correct? ).
>
>And if I replaced the DataSet with DataView, I can't make a DataRelation in DataView, if I am not misstaken.
>
>Do you agree with me Cathi?
>
>
>
>>Hi Ahmad,
>>
>>You need to bind the DataGrid to a DataView and then set the AllowNew property of the DataView to false. This will remove the row with the "*" from the DataGrid.
>>
>>>Hi all
>>>
>>>Is there a way to avoid the DataGrid from adding new line in it.
>>>
>>>I managed to do it by doing the following:
>>>dg1.ReadOnly = True, but the problem in this the user will not be able to change any existing data in it.
>>>
>>>Thank for the help.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi