classic asp recordset paging

Webboy2008
Webboy2008 used Ask the Experts™
on
9-2-2011-8-26-41-AM.pdf

Hi I have classic asp and use recordset to show the data from sql server database. and have two question.

1. Please view attached, when the mouse over on particular row. Is it possible to do something like that attached?

2. how to do the alternative color. the row color is different.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
LZ1
Top Expert 2011

Commented:
I actually am working on the exact same type of project.  I found this jquery plugin to be extremely helpful

http://www.datatables.net/index 

Author

Commented:
look good but i don't have time to learn this.
Top Expert 2011
Commented:
Not really a whole lot to learn. You basically already have your table with your repeat-region right?

Give your table an ID, then you can basically do something like this, after you've included the Jquery library of course:
<script type="text/javascript">
		$(document).ready(function() {
			$('#admin').dataTable( {
				"aaSorting": [[ 4, "desc" ]],
				"sDom": 'Rlfrtip',
				"bStateSave":true,
				"sPaginationType": "full_numbers"
			} );
		} );
		</script>

Open in new window


If you still don't want to do something like that then for highlighting and clicking you can use something like this:  
<script type="text/javascript">
		    $(document).ready(function() {
			 $('#admin tr')
			   .addClass('highlight')
			   .end()
			 .click(function(event) {
			   $(this).toggleClass('highlight');
			 });
		    });
		</script>

Open in new window


Just make sure to give your CSS a class of .highlight.  Mine looks like this:
table#admin .highlight td,
table#admin tr.alt.highlight td{background:#FF6;}

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial