I ususally do a 

var xml=XDocument.Load(s.GetProperty("companyFactsheet").Value.ToString()) and use xpath to iterate the xml.

var descendants = xml.Descendants("values") should get you each row and

foreach(var descendent in descendants) { var values = descendant.Descendants("value"); } should get you each col for a specific row.

Cheers,

/Dirk

Am gettiing error Error loading MacroEngine script.

var xml=XDocument.Load(Model.GetProperty("com").Value.ToString());
                                                            
var descendants = xml.Descendants("values");
foreach(var descendent in descendants) { var values = descendant.Descendants("value"); }

Added namespace
@using System.Xml
@using System.Linq
@using System.Xml.Linq
@using System.Collections;

Pretty odd, i'm sure it *must* work using my approach. Bit clueless why your version wouldn't.

/Dirk

Am i missing something here ?

Here is the full code

@using umbraco.MacroEngines
@using umbraco
@using umbraco.cms.businesslogic.datatype
@using uComponents.DataTypes.TextstringArray
@inherits umbraco.MacroEngines.DynamicNodeContext
@using System.Xml
@using System.Linq
@using System.Xml.Linq
@using System.Collections;



@{
    var m = @Model;
    DynamicNode s = new DynamicNode(CurrentModel);   
    
    if(m.Where("displayFacts == true")){
        <div class="box col1 cnFactsheet">
              <div class="cnInner">
                <div class="cnTop"> <span class="helTh"><strong>facts</strong></span> </div>
                <div class="cnContenu">
                 

                            @if (s.HasProperty("com") && s.GetProperty("com").Value.ToString() != String.Empty){
                                
                                var xml=XDocument.Load(s.GetProperty("com").Value.ToString());
                                                            
                                    var descendants = xml.Descendants("values");
                                
                                foreach(var descendent in descendants) { var values = descendant.Descendants("value"); } 
                                
                            }
            
                </div>
              </div>
            </div>
    }
    
    }

Hi Fuji, quick question... Which version of Umbraco and uComponents?  (it will help me answer faster)

Thanks, Lee

Hi Lee, working with v 4.11.8  and uComponents 5.5.0

Instead of using 

 var xml=XDocument.Load(s.GetProperty("com").Value.ToString()); 

i used 

var items = XDocument.Parse(new DynamicNode(Model.Id).GetProperty("com").Value.ToString());

Thanks Fuji.

In your Web.config do you have an appSettings key called "ucomponents:RazorModelBinding"? If so what's the value of it?

I'm hoping that you'll be able to use the model-binding, as it's much easier than messing around with XML in Razor.

Cheers, Lee

It is set to true .

Hi Lee,

Thanks for the help. I tried this in the meantime but got stuck again one extra Column here. 

Anyways yours work like a charm !!

  var items = XDocument.Parse(new DynamicNode(Model.Id).GetProperty("comp").Value.ToString());
    var rows = items.Descendants("values");
    var columns = items.Descendants("value");      

   <table>
        <tbody>    
        @if(rows.Count() > 0){
            foreach(var r in rows){
                <tr>
                    @foreach(var cell in rows)
                    {
                        <td></td>
                    }
                </tr>

            }
        }       </tbody>
       </table> 

  Thanks 

Lee what will be the appropriate way of getting the value of a column in a specific row ? 

I will have to make a total sum of some of the entries in those cell.

You would need to use a for loop to have the index of the current position.

e.g.

@for (var i = 0; i < rows.Count(); i++){
    <tr>
        @for(var j = 0; j < rows[i].Count(); j++)
        {
            <td>@rows[i][j]</td>
        }
    </tr>
}

Cheers, Lee.

Not exactly what am trying to achieve here.

What i need to do is to get the value of each cell so at the end i will be able to make a total sum. 

My Html would end up something like 

<table>
<tr>
<td>Some Static Txt</td>
<td>@cell.value[1] </td>
</tr> 

<tr>
<td>Some Static Txt</td>
<td>@cell.value[2] </td>
</tr> 
 etc
</table>

Do you mean something like this?

<table>
    @foreach(var row in rows)
    {
        <tr>
            <td>First value</td>
            <td>@row[0]</td>
        </tr>
        <tr>
            <td>Second value</td>
            <td>@row[1]</td>
        </tr>
    }
</table>

Silly question where did you get rows here ?

foreach(var row in rows){}

using @row[1] gives me an error

The reason i need to get the cell values seperately is because i will need those values to make some calculations in percentage to make a chart.

Sorry - I missed that out of my code snippet.

The rows would be assigned from Model.com (replacing with whatever your property alias is).

using row[1] will only return the first character from the value here

 foreach(var rows in Model.propAlias){
                           foreach(var row in rows){
                               
                               <tr>
                                        <td>@row[1]</td>
                                 </tr>
                                   
                           }
                       }

May be i would be best counting the rows since i only have 1 column.

You're so close... it doesn't need the inner-foreach loop. Try this:

foreach(var row in Model.propAlias)
{
    <tr>
        <td>@row[1]</td>
    </tr>
}

This is actually the first thing i tried!!

Not working though! :)

I am having a similar problem - the razor example does not return anything except the table tags.

Perhaps razor binding is broken for my install?

what should the Web.Config line for appsettings be? everytime I try to enable in the activate section of dev tab, it says its disabled -

so ive manually added in appsettings :

<add key="ucomponents:RazorModelBinding" value="true" />

(umbraco 6.1.4, uComponents_5.5.0, IIS 7.0, .NET VersionASP.Net 4.0/4.5)

thanks in advance for help.

Marc

is working on a reply...