---
title: "sortera en repeteater"
type: "forum-thread"
url: "https://www.webforum.nu/amne/dotnet/145360-sortera-en-repeteater"
topic: ".NET"
topic_url: "https://www.webforum.nu/amne/dotnet"
author: "voigtann1"
published: "2006-04-11T09:13:47.000Z"
updated: "2006-04-11T09:13:47.000Z"
replies: 0
views: 345
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/dotnet/145360-sortera-en-repeteater"
---

# sortera en repeteater

## #1 — voigtann1, 2006-04-11T09:13Z

```
        Dim SQL As String
        Dim qs As String = Request.QueryString("sort")
        SQL = "SELECT " & _
        "tblforum.fID, tblforum.ForumName, tblPosts.pID, tblPosts.postTopic, tblposts.postText, tblPosts.postDatePosted, tblUser.uID, tblUser.userName " & _
        "FROM tblUser " & _
        "INNER JOIN (tblforum INNER JOIN tblPosts ON tblforum.fID = tblPosts.postForum) ON tblUser.uID = tblPosts.postUser"
        If qs = "ner" Then
            SQL &= " ORDER BY tblPosts.postDatePosted DESC"
        ElseIf Request.QueryString("sort") = "upp" Then
            SQL &= " ORDER BY tblPosts.postDatePosted"
        End If
        SQL &= ";"

        listforum.DataSource = sqltest(SQL, "tblUser").Tables("tblUser")
        Me.DataBind
```

gör jag nu... men det är inte direkt smart va? med Datalist kan man ju sortera realtivt lätt(vad jag vet)...

Permalänk: https://www.webforum.nu/p/145360

---

Tråden på webben: https://www.webforum.nu/amne/dotnet/145360-sortera-en-repeteater