How to get data from my DB on that way

Hi.

I know how 2 get data from a DB to an aspsite

but if i want to get all records where KAT = dvd and order them by VNR, then i have 2 use this:

SQL = "SELECT * FROM software where KAT ='dvd' or KAT='DVD' ORDER BY VNR"
    Set rs = Conn.Execute(SQL)

But how do my While Not rs.EOF, If rs.EOF Then an so on look like if I want to get alle records from my DB where KAT = DVD or KAT = dvd, and group BY PRONAME and ordre by VNR.

so I will get all records where KAT is dvd and just dvd and then group then after PRONAME and i PRONAME the records are ordre by VNR.

so i ville get something like this:

http://www.midtjyskwebdesign.dk/image.gif

I know how to get the records where KAT is dvd and then ordre them by VNR so i will get something link this:

http://www.midtjyskwebdesign.dk/image2.gif

but i want to group the product names.

can someone help me and give me an exampel.