[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1159
  • Last Modified:

Alternative to datatable

I get rows from the database and store them in a datatable. Rows can be from 39 up to maybe 200 . I have 5 columns. I have at most 100 users. I save this datatable in a session and loop thru it to build a treeview and its nodes..

Is there an alternative to Datatable that I can keep in session that would be better for performance?
0
Camillia
Asked:
Camillia
  • 2
  • 2
1 Solution
 
zkeownCommented:
You could write them to an XML file (based on Session ID perhaps) and then just bind the TreeView to the XMLDataSource.
0
 
CamilliaAuthor Commented:
ah, didnt think about XML. Let me think.
0
 
zkeownCommented:
There's an example halfway down this page.  You'd need to modify it to actually create an XML file instead of just storing it in memory, but otherwise I've used it and it works great.

http://www.15seconds.com/issue/041117.htm
0
 
CamilliaAuthor Commented:
thanks, let me look.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now