selecting 15 records in vb.net

Question

User-1578974752 posted

Below is my code. I want to check only first 15  records in the select statement.

select TOP 15 * FROM Detail where TestID ='1209' ORDERBY ASC 

working in sql but not working in my code

cmd.CommandText = "select * FROM Detail where TestID = '" + qusetid.Text + "'"

            drd = cmd.ExecuteReader

            If drd.HasRows = True Then

                While drd.Read
                                   End While
            End If

Answer 1

User753101303 posted

Hi,

Doesn't work that is ? Always tell what actually happens rather than just that "it doesn't work".

It seems your code doesn't include the TOP 15 option ???? Is this intended ? If you get more than 15 rows, start by updating your SQL statement with the one you actually want !!! If drd.HasRows is not even entered, it is rather that the criteria is wrong.

Not directly related but do a search for "SQL parameters". You shouldn't build SQL strings this way.

Answer 2

User1120430333 posted

You are using a datareader So how are you planning to get  data so that you can use it? 

Answer 3

User-1716253493 posted

Your post title is selecting 15 records in vb.net, but select top 15 only in sql, not in vb

Answer 4

User283571144 posted

Hi shsu,

shsu

working in sql but not working in my code

According to your description, I couldn't understand your issue clearly.

Do you mean if you use this query "select TOP 15 * FROM Detail where TestID ='1209' ORDERBY ASC ", it doesn't return the right data. 

If you don't know how to get the data by using ado.net, I suggest you could refer to below codes:

        Dim conxnString As String = "YOUR CONNECTION STRING"
        Dim cmdString As String = "select TOP 15 * FROM Detail where TestID ='1209' ORDERBY ASC "
        Using conxn As New SqlConnection(conxnString)
            Using cmd As New SqlCommand(cmdString, conxn)
                 Dim reader As SqlDataReader = cmd.ExecuteReader()
                While reader.Read()
                    Console.WriteLine("\t{0}\t{1}\t{2}",
                       reader(0), reader(1), reader(2))
                End While
            End Using
        End Using

Best Regards,

Brando