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:

    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).


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