Using TreeView inside AJAX UpdatePanel

Microsoft does not support TreeView Control inside AJAX:UpdatePanel. So there are lots of issues if one need to do the same. One of my teams needed to use the TreeView inside the UpdatePanel. The core of the application is around some hierarchical documentation. As the user interaction with the system mostly through this hierarchical data, TreeView with check boxes is the most obvious selection. However, the pain began as the development progressed and changes in requirements started pouring in. One option was for clientside population of treeview. But some dynamic changes happening to the underlying hierarchical data (by concurrent users),

Continue reading

TreeView inside UpdatePanel issue – postbacks on check and uncheck of the node’s Checkbox

Problem: In ASP.NET TreeView control, user wish to select one or many treenodes and wish to have options for further working depending upon the selection. The selection is done using a checkbox. On checking, the server side code need to know what has been checked and provides further options for the same. The checkbox check/uncheck does not fire a postback. Though we tried to imitate the same using javascript, the page gets refreshed. We used AJAX and put the TreeView control inside an UpdatePanel Findings: Microsoft does not support this. An issue/request for the feature was put on Microsoft feedback

Continue reading

Version Conflict of .NET Framework in IIS

Another point to share. Of course I delayed the publishing. While I was migrating the YAFNET forum from my machine (WinXP with SQL Server 2005 Express), to a machine with Win2K3 and SQL Server 2000, I faced another issue. The first issue was of migrating SQL Server 2005 Express database to SQL Server 2000 database. The next issue is of conflict of versions of .NET in IIS. The target machine was hosting few web applications developed on .NET 1.1 and was running fine. I created a site for the YAFNET application and in the properties, set the .NET version as

Continue reading

Moving SQL Server 2005 Express databases to SQL Server 2000

Beyond general concept of upgrading, I faced a challenge of downgrade. I needed to migrate a database in SQL Server 2005 Express edition to SQL Server 2000 standard edition. I thought of how to do the same. Time permitted was just few hours.   I scratched on my head and thought of possible ways:  1. Detach from 2005 and attach in SQL 2000: Can not be done. It is not allowed, even if you set the compatibility level of the database to SQL server 2000. This just sets the way how sql queries are parsed and processed.  2. Import from

Continue reading

State Management Best Practices

  The following table highlights the main state management issues:   State Management Issues Implications Stateful components Holds server resources and can cause server affinity, which reduces scalability options. Use of an in-memory state store Limits scalability due to server affinity. Storing state in the database or server when the client is a better choice Increased server resource utilization; limited server scalability. Storing state on the server when a database is a better choice In-process and local state stored on the Web server limits the ability of the Web application to run in a Web farm. Large amounts of state

Continue reading

HTTP Compression – A faster way to improve web site performance – At minimal cost

  HTTP compression – is a simple way to improve site performance and decrease bandwidth, with no configuration required on the client side. – is a capability built into both web servers and web browsers, to make better use of available bandwidth. – HTTP protocol data is compressed before it is sent from the server. How HTTP Compression Works When IIS receives a request, it checks whether the browser that sent the request is compression-enabled. (Recent versions of Microsoft® Internet Explorer and most other browsers typically send the following header if they are compression-enabled: Accept-Encoding: gzip, deflate.) IIS then determines

Continue reading

schema.ini file to interpret column attributres while reading a CSV using MS Text Driver

Problem – While reading a CSV file using Microsoft Text Driver, It interprets CSV file columns in it’s own way like if one the column contains data specific to a date, then it only keep data which is in proper format otherwise it put null against that. Solution – Create a schema.ini file which defines the structure of a CSV file in turn gets interpreted automatically by driver itself in a desired format. Details – Schema.ini files provide schema information about the records in a text file. If you create a DSN, the schema.ini file gets created automatically in the

Continue reading

ASP.NET webdomain recycle on subfolder changes

While working on a web application, one of my team presented some weird behaviour on ASP.NET FIrst observation: Session times out randomly while working on the application. So we started observing the application closely to see what might be causing this. We came out with some more observations: Detailed observation: Session times out when any of the user participates in certain scenario. Also, not only the specific session expires, but all the use sessions are expired. Further study shown that actually the app domain itself recycles. We studied the activities in these specific scenario. We found that a certain implementation

Continue reading