[vennesschan]

Hi, I am trying to get the last 20 rows data from the sql db to the ListView from individual Name which i input to the txtbox. However it doesn't work out on the following way. Can someone tell me what did i do wrong. Thank you.

 
            Dim ID As String
            ID = Inputtxt.Text

            If ID = "" Then
                MsgBox("Please enter a Name")
            End If
           
            Dim SelectCmd As String
            SelectCmd = "Select Distinct Top 20 Name, Date, High, Low from Report where Name='  Order By Date ASC" & ID & "'"

[CharlieMay]

Using the same concept you did in your prior post you would just specify And Name = 'somename'

SelectCmd = "Select Id, Date, High, Low from Report WHERE Name = '" & ID & "' AND Date BETWEEN '" & startDate & "' AND '" & endDate & "' ORDER BY Date"

[vennesschan]

you are the best, thank you Charlie

[motcom]

The way ChalieMay showed you will not get you the last 20 rows, it will only get you what is in the WHERE clause, to get the last 20 rows, you can still use the WHERE clause but you add TOP 20 and ORDER descending on what ever column you want.

eg.

SELECT TOP 20 Surname FROM Individuals ORDER BY Surname DESC

If it's the Surname column, the result will be in alphabetical order but in reverse, so sort it again, you can use the following

eg.

WITH Results AS (
SELECT TOP 20 Surname FROM Individuals ORDER BY Surname DESC
) SELECT * FROM Results ORDER BY Surname

You fill a Temp Table called "Results" then querry the Temp Table and sort it again...

[CharlieMay]

Motcom, He's actually wanting only data from the last 20 days (See Previous Topic) Now he's just wanting to know how to only pull the last 20 days for a given name and sort it.

[motcom]

Haven't seen the last topic, been in angola for 2 weeks of fishing... sorry.

[CharlieMay]

Hope you didn't take that the wrong way, I was just pointed it out because it wasn't as clear in this current topic.
What kind of fish were you catching? Can't really tell in the picture on your profile. Actually after zooming in, it looks like you just sitting in the current drinking a beer

This post has been edited by CharlieMay: 23 April 2010 - 02:38 PM