VB.NET 2008 EE + MS Access

[manil]

hey guys!

i'm not really sure where to post this..

i've got this vb.net program that gets all of its data from a database.. but i'm having problem sorting.. how do i do it..??

this is the code in my query:

SELECT *
FROM Student;

i need to sort the surname alphabetically & the given name.. if there are students who has the same surname, the given name should be sorted alphabetically as well...

the output is written in an html file..

[sotoasty]

SELECT * FROM Student ORDER BY SurName, GivenName;

[manil]

i was able to get it sorted.. but i'm having problem with my output..

i need to get something like this..



but i always get this..

[sotoasty]

You will need to post some of your code. Otherwise, we have no idea what you want or what your problem could be.