Intersoft Community - WebGrid Enterprise - WEBGRID Retrieve values child rows server side

WEBGRID Retrieve values child rows server side

lucisit — Mon, 26 Oct 2009 04:39:46 GMT

Hi Glenn, I have apreciate your effort to find a workaroud for something that isn't supported by WG. Considering that WG returns the entire composite key for the child selected row I prefer to retrieve it by querying the data adapter.
I must say that I'm very disappoited because I am waiting since WG release 3.5 for a real composite key management.
In any way, I must tank you for helping me.
My best regards.

Luciano

WEBGRID Retrieve values child rows server side

lucisit — Mon, 26 Oct 2009 04:38:26 GMT

Hi Glenn, I have apreciate your effort to find a workaroud for something that isn't supported by WG. Considering that WG returns the entire composite key for the child selected row I prefer to retrieve it by querying the data adapter.

I must say that I'm very disappoited because I am waiting since WG release 3.5 for a real composite key management.

In any way, I must tank you for helping me.

My best regards.

Luciano

WEBGRID Retrieve values child rows server side

Glayaar — Mon, 26 Oct 2009 04:00:39 GMT

Per you request, I modified my first sample for composite key scenario. In this sample, I buffer the parent composite key in a data column and bound the value in the WebGrid button column.

WEBGRID Retrieve values child rows server side

lucisit — Fri, 23 Oct 2009 06:51:51 GMT

Hi Glenn, I could retrieve child row's values with the code below and using only one field as key but I couldn't when the key is composite by more fields. How shoud I declare a coposite key in WG?

Thank you, regards.

Luciano

Dim Protocollo As Integer = CInt(WebGrid1.RetrieveClientLastSelectedObject().KeyValue)
Session("PROTOCOLLO") = Protocollo
Session("CODICE_RICHIEDENTE") = WebGrid1.GetTableByName("Pratiche").Rows.GetRowByKeyValue(Protocollo).Cells.GetNamedItem("CODICE_RICHIEDENTE").Value

WEBGRID Retrieve values child rows server side

lucisit — Fri, 23 Oct 2009 03:41:03 GMT

Hi Glenn, I followed your advice but it still doesn't work, see the attachment. Is this feature supported in WG 6.0 2008 SP2? Because at this point I don't know what to think. If you can, please send me a database containing two tables parent and child, both having a composite key, plus the page when you retrieve the selected child row row by RetrieveClientLastSelectedObject KeyValues property.

Thank you, regards.

Luciano

WEBGRID Retrieve values child rows server side

Glayaar — Fri, 23 Oct 2009 00:46:20 GMT

The snippet is for the WebGrid1_ButtonClick in the 4_Glenn.jpg attachment. In this case the ChildKey variable will be RetrieveClientLastSelectedObject KeyValues property.

For the snippet to work, you will also need to use the RestoreExpandedChildRows="true" property in the LayoutSetting

WEBGRID Retrieve values child rows server side

lucisit — Thu, 22 Oct 2009 05:20:11 GMT

Hi Glenn, my composite keys have the following fields:

Composite ParentKey = FirstKeyField is String - SecondKeyField is numeric

Composite ChidKey = FirstKeyField is Numeric - SecondKF Is string - ThirdKF is String

What format shuld have ChildKey to pass it as parameter in the following code (String, or what else)?

WebGrid1.GetTableByName("childTableName").Rows.GetRowByKeyValue(ChildKey)

If you don't mind please send me a sample about how to retrieve a row parent or child using a composite Key

Thank you, regards.

Luciano

WEBGRID Retrieve values child rows server side

Glayaar — Thu, 22 Oct 2009 04:05:08 GMT

Based on the error message in the screenshot, the error is returned because the GetRowByKeyValue return null. My hunch is because the data type in the ArrayList and the KeyValues of the parent row does not match. Have you tried using the object of the ChildKey item without casting the item to String?

Or you could use the RestoreExpandedChildRows="true" property in the LayoutSetting so the child row will be expanded and you could retrieve the child row info using the ChildKey variable:

//Acquire the selected child row
WebGrid1.GetTableByName("childTableName").Rows.GetRowByKeyValue(ChildKey)
//Acquire the selected child parent row
WebGrid1.GetTableByName("childTableName").Rows.GetRowByKeyValue(ChildKey).Parent

WEBGRID Retrieve values child rows server side

lucisit — Thu, 22 Oct 2009 02:55:11 GMT

Hi Glenn, I have attached the code from my test page and it doesn't work. I can retrieve correctly the child and the parent composite key but, how you can see it doesn't work. Would you be so kind to tell me what is wrong. Thank you, regards. Luciano

WEBGRID Retrieve values child rows server side

Glayaar — Wed, 21 Oct 2009 23:30:41 GMT

The snippet to retrieve the data in the childrow for a non composite parent row during button click is

WebGrid1.RootTable.Rows.GetRowByKeyValue(e.CellValue).ExpandChildRow();
string selectedKey = WebGrid1.RetrieveClientLastSelectedObject().KeyValue;

The idea here is we need to expand the parent row first in order to retrieve the child data. The e.CellValue is the value of the button column which in the attached sample is referring to the parentKey column. In other words, in your compsoite key situation, you will need to buffer the composite key parent in a column to be able to reference it if you wanted to expand the row.

Or you could use a simpler solution, by adding the property RestoreExpandedChildRows="true" in the WebGrid LayoutSettings property to ensure the child row will be expanded. Without this property, you will need to use the above technique to ensure the child row table is loaded.

WEBGRID Retrieve values child rows server side

lucisit — Fri, 16 Oct 2009 06:55:11 GMT

Hello, I have a hierarchical structure and each child row has a button that raises a postback event when I try to retrieve values in WebGrd1_ButtonClick with the code below I get an error because it can't retieve the object. Would be so kind to send me a sample to solve this problem. Thank you, luciano.

Dim SelObj As SelectedObject = WebGrid1.RetrieveClientLastSelectedObject()
Dim SelInd As Integer

SelInd = SelObj.RowIndex

Dim TempVar = WebGrid1.RootTable.ChildTables(0).Rows(SelInd).Cells.GetNamedItem("NUMERO_PROTOCOLLO").Value