PC Review


Reply
Thread Tools Rate Thread

Data View Sortation

 
 
=?Utf-8?B?Q2FybCBIb3dhcnRo?=
Guest
Posts: n/a
 
      11th Nov 2005
Hello there,

I am updating an asp.net application to implement caching - I have stored a
list of menu information that is diplayed in a dataset and filter it at
runtime using a dataview based on the area of the system the user is in.

I have done this by having the menu name, url and then a list of
hash-delimited IDs that is then filtered on at runtime to display the correct
menus for the area that the user is in:

Page 1, Page1.aspx, #1#5#8#7#
Page 2, Page2.aspx, #2#5#8#6#
Page 3, Page3.aspx, #2#4#8#6#

So, when somebody in area ID 5 views the menu they see pages 1 and 2,
through adding a filter to the dataview:

objDataView.RowFilter = "IDList LIKE '%#5#%'"

This works fine but now I need to add in some level of sortation dependant
upon the ID that is passed in, i.e. if ID 8 is passed I may want to see the
menu displayed in a different order to if, say 5 was passed in.

Would it be possible to add an order into my IDList (perhaps adding an ID
followed by a semicolon then the order number) and somehow have the dataview
order by part of a column rather than the whole column?

Cheers,
--
Carl Howarth
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recognising the user switch between Form view and Data sheet view Mike Turner Microsoft Access Form Coding 3 2nd Mar 2010 08:58 PM
Number sortation =?Utf-8?B?ZGFmZnkx?= Microsoft Excel Misc 12 12th Oct 2007 07:24 PM
How can the query default to pivot table view and not data view? =?Utf-8?B?QnJvbnd5bkFUaG9tYXM=?= Microsoft Access Queries 0 16th Jun 2006 02:33 AM
SharePoint calendar view in data view webpart jrefsnider Microsoft Frontpage 1 5th Feb 2004 05:41 PM
How to toggle between the datasheet view of a query & data entry view of a form Dave Dettman Microsoft Access Forms 2 13th Jan 2004 11:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:39 AM.