Visual Basic

6-Feb-07 0:27

Hello,

I have a typed dataset which I want to display in an ultragrid (infragistics) and display the parent and the children.

I can display this ok when I want to display all of the parents and children. But the user will need to select one parent from a list and display that parent with its children in the grid.

I have created the dataset schema dsAssembliedEquipment.xsd and my 2 tables assembly and AssembiledEquipment.

I have a stored procedure (getDataByCustomerID) that will find the customerID of the assembly (parent) table.
This is my code for setting the ultragrid.

<br />
'Table Adapter to get the customer ID record<br />
 Me.TA_Assembly1.GetDataCustomerID(customerID)<br />
'Fill the assembly (parent) table and assembliedEquipment table(child)<br />
            Me.TA_Assembly1.Fill(Me.DsAssemblyEquipment1.Assembly)<br />
            Me.TA_AssembliedEquipment1.Fill(Me.DsAssemblyEquipment1.AssembliedEquipment)<br />
<br />
            Me.grdCustomersAssembly.DataMember = "Assembly"<br />
            Me.grdCustomersAssembly.DataSource = Me.DsAssemblyEquipment1<br />

However, this displays all of them of the parents and children.

I think this is something wrong and the dataset not getting filled correctly.

Many thanks for any direction on this,

Steve

Andi Fandrich6-Feb-07 2:50

6-Feb-07 2:50

Hi Steve,

you will need to add a DataRelation between the parent and child DataTable in the DataSet.
DsAssemblyEquipment1.Relations.Add(...)
See MSDN for details.

Andi

steve_rm6-Feb-07 4:30

6-Feb-07 4:30

Hello Andi,

I will give that a try.

However, I have created in the relationship in the DsAssemblyEquipment.xsd designer.

Another thing the parent and child works when you want to display all of them in the datagrid, but if you want to display just one parent and the children that belong to that parent, that is where the trouble is. It keeps displaying all of them.

The code I gave above displayed all of them either though i have created the relationship in the xsd designer.

Any ideas,

Thanks very much.

Steve

Andi Fandrich6-Feb-07 5:20

6-Feb-07 5:20

Hi Steve,

sorry but I don't know, what all those designers inside VS do, because I'm not using them. I always prefer to write the code on my own so I (hopefully) know what's going on.

However, what do you mean by "displays all of them"? All parent records? Your code seems to select only one. If you mean all child records this begs the question why you select them if you only need those of one specific parent.

It's been a while since I last worked with the infragistics grid, but IIRC this kind of scenario just worked for me. Did you check for the correct setting of the grid's DataMember property? Is there a table with that name in your dataset?

Andi

steve_rm6-Feb-07 7:36

6-Feb-07 7:36

Hello Andi,

Thanks for your reply - I did try and make the relationship in code, just to see if it made any difference

<br />
 Dim parentColumn As DataColumn = Me.DsCustomerEquipment1._Assembly.Columns("AssemblyID")<br />
            Dim childColumn As DataColumn = Me.DsCustomerEquipment1.AssembliedEquipment.Columns("AssemblyID")<br />
<br />
            Me.DsCustomerEquipment1.Relations.Clear()<br />
            Dim drAssemblies As New DataRelation("AssemblyDetails", parentColumn, childColumn)<br />
            Me.DsCustomerEquipment1.Relations.Add(drAssemblies)<br />
<br />
            Me.UltraGrid2.DataSource = Me.DsCustomerEquipment1<br />
<br />
            Me.UltraGrid1.DataMember = "Assembly"<br />
            Me.UltraGrid1.DataSource = Me.DsCustomerEquipment1<br />

Displays all of the parents and children. Which is not what I want. Let me explain I have Assembly Table fields AssemblyID | customerID | AssemblyName

I have child table called AssemblyEquipment fields SerialNo | make | Model | AssemblyID (Foreign Key)

The user will selects a customer and then the grid should display the customer's assembly and the assembly will show all the equipment that is contained in that assembly.

I have just tried this but it didn't work

<br />
'Select the parents with customerID number 2 and fill the dataset<br />
 Me.AssemblyTableAdapter1.GetDataByCustomerID(2)<br />
            Me.AssemblyTableAdapter1.Fill(Me.DsCustomerEquipment1._Assembly)<br />
'Set the databinding for the grid<br />
            Me.UltraGrid1.SetDataBinding(Me.DsCustomerEquipment1, "Assembly")<br />

Hope you can help,

Many thanks and most grateful,

Steve

Andi Fandrich6-Feb-07 21:06

6-Feb-07 21:06

Hi Steve,

I see that you are working with two grids, one for the parent data and one for the children. I just used one grid to display them both. A thing which the UltraGrid does quite well.
I just dug out my old project, where I used the Infragistics grid (Version 3).
The code that works (.NET 1.1) creates a New DataSet in which two DataTables are created and filled via DataAdapter.Fill and following DataSet.Tables.Add(). The DataRelation is added just like in your code and the DataSet is bound to the grid's DataSource property. All other properties of the grid with their default values.

In the code you posted it seems that you are setting UltraGrid1's datasource twice:

Me.UltraGrid1.DataMember = "Assembly"<br />
Me.UltraGrid1.DataSource = Me.DsCustomerEquipment1

and
Me.UltraGrid1.SetDataBinding(Me.DsCustomerEquipment1, "Assembly")

Could this be the problem? Otherwise I don't have any more ideas Confused | :confused:

Andi

steve_rm7-Feb-07 5:50

7-Feb-07 5:50

Hello Andi,

Thanks for your reply and patience.

I am only using 1 ultragrid to display the parent and children relationship.

I have set the relationship in the designer and tested to see if it would display the parents and children and it did. I also tested this doing it the code way. Also worked.

I wasn't setting the datasource twice, i tried both methods individually to see if they would work.

However, the problem is that I only want to display the parents and children that belong to a certain customer, rather they displaying all of them.

Thats the real problem, and still can't find the answer.

I think there could be a problem with the sql query or the way i am filling the dataset.

If you have any more ideas on this, please let me know. I just want to solve this problem before i pull my hair out.

Many thanks,

Steve

Andi Fandrich7-Feb-07 7:09