Parsing Database content to an array then to TABLE ASP/Javascript

[jacknbey]

Hi,

I need help in getting the following result displayed:-

-------------------------------------------------
No Username Mobile Address Gender Email DOB (Sorting)
-------------------------------------------------
1 aaa 12345 xxxxxxx Male xxxxx xxx
2 bbb 23456 yyyyyyy Female yyyyy yyy
3 ccc 34567 zzzzzzz Female zzzzz zzz
.
.
.
10 jjj 99999 eeeeeee Male eeeee eee
-------------------------------------------------
<< Previous Page 1 2 3 4 5 6 . . . Next >>
-------------------------------------------------

The source is from SQL, attributes are fixed and values are random.

What I am thinking here is to use the SQL SELECT command to parse the database into an array structure then write the array content as a TABLE.

I wish to do this in ASP, can any kind soul point me to some efficient codings to do so?

At the same time I am thinking I should be able to display the TABLE in a nice format (such as 10 rows per pagee, with optional PREVIOUS and NEXT page link). By doing so it make more sense to build-in the attribute sorting features which could be javascript.

I have seen quite a lot of website using the same technique for content display. Can someone help me please?

Thanks a million...

Regards.

[lmf232s]

http://www.asp101.com/samples/db_paging.asp

Take a look at this example.