DATA BIND ACCORDION MENU

AJAX TOOL KIT , ASPNET , VWD 2010 United States
  • 8 years ago

    I am writing a Ajax Accordion Menu bind to a Database with columns: TYPE MODEL ID (unique identifier)

    Multiple MODELS can have the same TYPE. I am creating a SQL binded to the accordion that returns a list of MODELS but I want distinct TYPES only,

    What I have today:

    TYPE
    Apt - Model 1 room Apt - Model 2 room Apt - Model 3 room

    What I want is:

    TYPE Apt Model 1 room Model 2 room Model 3 room

    Here is the code I have:

    " ProviderName="System.Data.SqlClient" SelectCommand="SELECT PZSMMODEL, PZTYPE FROM (SELECT PZSMMODEL, PZTYPE, Rownumber() OVER(PARTITION BY PZTYPE ORDER BY PZTYPE) rn FROM PIEZO) t WHERE rn = 1" /> <%#DataBinder.Eval(Container.DataItem, "PZ

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.” - Tom Cargill