Hi,

In short the question is: How do I use a SQL datasource field (called UmbracoID) inside the inline-razor macro?

I have created an usercontrol in VB, and now I would like to use some inline razor macroing, but I can't seem to find any examples on how to use an external parameter (such as SQL datasource) inside the macro.

Here is my present code (If i hardcode the ID it works):

<asp:SqlDataSource ID="dsKontaktinfo" runat="server" ConnectionString="<%$ ConnectionStrings:ServiceBeregnerSQLConnectionString %>" SelectCommand="sp_Kontaktinfo_Select" SelectCommandType="StoredProcedure">
  <SelectParameters>
    <asp:Parameter Name="AfdelingID" Type="Int32" />
  </SelectParameters>
</asp:SqlDataSource>

<asp:FormView ID="fvKontaktinfo" runat="server" DataSourceID="dsKontaktinfo">
  <ItemTemplate>
    <h2>Ejner Hessel, <%#Eval("Navn")%> A/S</h2>
    <p><%#Eval("Adresse")%></p>
    <p><%#Eval("Postnr")%> <%#Eval("City")%></p>
    <umbraco:Macro runat="server" language="cshtml">
      @Library.NodeById(<%#Eval("UmbracoID")%>).serviceBeregnerAabningstider
    </umbraco:Macro>
  </ItemTemplate>
</asp:FormView>

Basically I have a database which contains a table with all my departments. In this table I have added an integer field containing the node-number for each department relative to my umbraco-pages. What I wanna do is to use this int, so that I can use the "serviceBeregnerAabningstider" field from Umbraco.

The error i am recieving is this:

Error reading usercontrols/Serviceberegner/Serviceberegner.ascx

The following list shows the Public Properties from the Control. By checking the Properties and click the "Save Properties" button at the bottom, umbraco will create the corresponding Macro Elements.

System.Web.HttpParseException (0x80004005): Code blocks are not supported in this context. --->

and it goes on :-)

Any pointers would be greatly appreciated (and yes I am a noob), so even if it is obvious please help me :-)

/Regards
Jimmy