Advertisement

05.16.2008 at 12:43PM PDT, ID: 23409571
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

TreeView not working in production

Tags: ASP.NET (VB)
I've got a treeview control that works perfectly on my development server when debugging in VS 2005. I moved it over to my production environment just like I do with all of my other websites.  The page itself pulls up fine, but the parent nodes in the tree view are displayed as text. The plus/minus icons are not present either. How do I fix this?
Start your free trial to view this solution
Question Stats
Zone: Programming
Question Asked By: mwmiller78
Solution Provided By: ajax2cle
Participating Experts: 2
Solution Grade: A
Views: 0
Translate:
Loading Advertisement...
05.16.2008 at 12:52PM PDT, ID: 21585884

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 12:59PM PDT, ID: 21585944

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 01:07PM PDT, ID: 21586009

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 01:11PM PDT, ID: 21586031

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 01:25PM PDT, ID: 21586163

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 01:35PM PDT, ID: 21586241

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 01:40PM PDT, ID: 21586281

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 02:00PM PDT, ID: 21586398

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.16.2008 at 03:09PM PDT, ID: 21586831

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.18.2008 at 10:23AM PDT, ID: 21593332

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.19.2008 at 07:28AM PDT, ID: 21598068

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
05.16.2008 at 12:52PM PDT, ID: 21585884
check to see if ur image urls or CSS files are missing or mis spelt. If we can get the URL where it has issues we can help.
 
05.16.2008 at 12:59PM PDT, ID: 21585944
All I have on this page is the treeview. I haven't referenced any images or CSS.
Are there images or CSS files created by default using a treeview control that I'm not aware of?

This is on an Intranet.
 
05.16.2008 at 01:07PM PDT, ID: 21586009
it sounds as though you connected the treeview control to a datasource, as opposed to populating the nodes in the IDE. Have you checked that?
 
05.16.2008 at 01:11PM PDT, ID: 21586031
That's correct. I am populating them from an SQL DB instead of populating them in the IDE. It's dynamic data, I can't populate the nodes/leafs in the IDE.

Why would this cause the tree view not to work in production? I guess I'm not understanding what I need to check for.
 
05.16.2008 at 01:25PM PDT, ID: 21586163
You are not connecting to your datasource or, the table/datacolumn you are pulling from in the production environment has no data.

You are not getting any errors?

This could be a location issue(ie, you are pointing to a development SQL server thats not accessible), or possibly a permission issue where you need to modify your connection string in the code for the production environment. but i would not think so if you are not getting errors.

Accepted Solution
 
05.16.2008 at 01:35PM PDT, ID: 21586241
Below is how I run the query. The connection string does not change from dev to production.

No, no errors at all.

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
        Dim ConnectionString As String = "server=ussrm-netsql\netdata;Trusted_Connection=true;DATABASE=TempMike"
 
        Dim DBConnection As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection(ConnectionString)
        Dim DBAdapter As Data.SqlClient.SqlDataAdapter
        Dim ResultsDataSet As Data.DataSet = New Data.DataSet
 
        Try
 
            DBAdapter = New Data.SqlClient.SqlDataAdapter(QueryString, DBConnection)
            DBAdapter.Fill(ResultsDataSet)
 
            DBConnection.Close()
 
        Catch ex As Exception
 
            If DBConnection.State = ConnectionState.Open Then
 
                DBConnection.Close()
 
            End If
 
        End Try
 
        Return ResultsDataSet
Open in New Window
 
05.16.2008 at 01:40PM PDT, ID: 21586281
there is nothing in your "Querystring"

dim QueryString="Select * From TempMike/Table"
DBAdapter = New Data.SqlClient.SqlDataAdapter(QueryString, DBConnection)
 
05.16.2008 at 02:00PM PDT, ID: 21586398
lol...sorry I figured you would assume I called this from somewhere else. here's an example below:

like i said man, this does exactly what I want it to do in production. it's not going to be something like having an empty query string.
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
  Sub PopulateTables(ByVal node As TreeNode)
 
        Dim strQuer As String
        strQuer = "SELECT table_name from " & node.Value & ".information_schema.tables"
        Dim ResultSet As Data.DataSet = RunQuery(strQuer)
 
        If ResultSet.Tables.Count > 0 Then
 
            Dim row As Data.DataRow
 
            For Each row In ResultSet.Tables(0).Rows
 
TreeNode(row("table_name").ToString())
                Dim newNode As TreeNode = New TreeNode()
                newNode.Text = "<a target=_blank href =fields.aspx?" & Replace(row("table_name") & "~" & node.Value & "^" & "NSND", " ", "%20") & ">" & row("table_name") & "</a>"
                'newNode.Text = row("table_name").ToString()
                newNode.Value = row("table_name").ToString()
 
                newNode.PopulateOnDemand = False
 
 
                newNode.SelectAction = TreeNodeSelectAction.None
 
                node.ChildNodes.Add(newNode)
 
            Next
 
 
        End If
 
    End Sub
Open in New Window
 
05.16.2008 at 03:09PM PDT, ID: 21586831
sorry dude, i cant assume anything.

what you are doing for intents and purposes looks like it should work.

you got to test points of failure to get this one solved, unless there is a funky reason i have not heard that your treeview wont render.

put a dataview control on the page and point the resultset as the datasource.  if no joy change that query from a referenced value to known value for testing and create one complete string. see what happens then.

if you do get data in your dataview, look at your for/next loop and get that as plain vanilla as possible(ie for now change to newnode.text=row("table_name"))

good luck
 
05.18.2008 at 10:23AM PDT, ID: 21593332
one other thing i noticed you throwing "strQuer" to your query function. You have to replace "QueryString" with that variable
 
05.19.2008 at 07:28AM PDT, ID: 21598068
It may be something funky. I've been doing a little research and found quite a few other people experiencing the same thing, though I haven't found a clear cut  resolution. I set up a new app, placed a tree view on a page and just added a couple leaves to a parent node (no data connection) and got the same result. It still just renders the parent node as plain text with no functionality...weird.

 
 
20080236-EE-VQP-29 / EE_QW_2_20070628