Anj
Posts: 13
|
Posted: 01/15/2018, 4:26 AM |
|
I am trying to implement a dynamic organisation chart as part of my project and not sure what needs to go where using this example and how to implement it into codecharge.
https://www.aspsnippets.com/Articles/Create-Organizatio...-in-ASPNet.aspx
The inmotion datasource is for a grid generated with the required data:
<mt:MTDataSource ID="qryOrgChartDataSource" ConnectionString="InMotion:Connection1" SelectCommandType="Table" CountCommandType="Table" runat="server">
<SelectCommand>
SELECT TOP {SqlParam_endRecord} *
FROM qryOrgChart {SQL_Where} {SQL_OrderBy}
</SelectCommand>
<CountCommand>
SELECT COUNT(*)
FROM qryOrgChart
</CountCommand>
<SelectParameters>
<mt:WhereParameter Name="SesCOID" SourceType="Session" Source="COID" DataType="Integer" Operation="And" Condition="Equal" SourceColumn="COID"/>
</SelectParameters>
</mt:MTDataSource><br>
|
 |
 |
|