In my previous post, I discussed how to use TransactionScope to update DataTable objects in a transaction. The biggest shortcoming of using TransactionScope is that several security settings on the server need to be modified in order to make it work, and this may not be feasible for many companies because of the security concern. Today, I will discuss how to use XML and stored procedure to update DataTable objects in transaction. The basic idea […]
Tips & Tricks
146 posts
We all know that if you need to insert/update data in several database tables that have relationship with each other, then you will need to make sure the insert/update process is completed in a transaction to ensure the data integrity. With stored procedure, it is not hard to perform transaction, but what if you are using DataTable? In this post, I will show how to use TransactionScope to implement transaction for DataTable update. Suppose we […]
I suddenly got this error when I was working on a project in Visual Studio 2005 and trying to switch to the Designer view of a page: ‘asp:UpdatePanel’ could not be set on property ‘ContentTemplate’ The application rebuilds fine and even runs fine, but I just cannot switch to the Designer view. Here is what I did to solve the problem after some search: 1. Exit Visual Studio 2005 2. Go to Administrative Tools –>Services, […]
I noticed that many developers asked this question or similar: After a user clicks a button on a page, my application performs some check, then prompts user for confirmation, then based on user’s response, my application will either continue the process or cancel the process. How can I accomplish this? I wrote an article on Experts-Exchange.com regarding this question and here is the link to it: Display confirmation from code behind before continuing a process […]
If you have a PDF file with print protection, you will not be able to print it. To remove the print protection, you will have to know the protection password and then open the file with Acrobat Professional to make it printable. Here I show you an easy way to remove PDF file’s print protection. First, you will need a Linux system. I would suggest you to use Ubuntu. If you don’t have one and […]
In this article, I will show you how to use AJAX PopupControlExtender to build a multiple select DropDownList as this: Firstly, we need an image captured from a standard drop down list as this: I will use this image as the drop down list instead of the built-in ASP:DropDownList control, the reason is that when a drop down list is clicked, its own selections will be displayed and will overlap with the check box […]
My old WordPress blog is located at http://www.codingbeaver.com and I would like to move it to the new location at https://learningpenguin.net, also I would like to redirect user automatically to the same post on the new site. For example, if user comes to my old site through search engine for a post like this: http://www.myolddomain.com/index.php/2009/11/30/wordpress-won-2009-open-source-cms-award/, I would like to redirect them to my new site as this: https://learningpenguin.net/index.php/2009/11/30/wordpress-won-2009-open-source-cms-award/, here is how I did it: 1. […]
I was working on an ASP.NET project today, and suddenly this error came up after I click “Debug”: Unable to attach to ‘WebDev.WebServer.EXE’ (PID: xxxx) using ‘ComputerName’. A debugger is already attached. Do you want to continue anyway? If I click Yes, my browser becomes loading forever. The cause I believe is that the built-in ASP.NET development server in Visual Studio is crashed, but somehow the process is still attached to the debugger. I tried […]
As I mentioned in my previous post, Microsoft Office 2010 introduced many new features to help user to get their work done more quickly and more safely. Protected View is one of the new security features introduced to add another security layer to protect user when working with potentially harmful documents. The basic idea of the Protected View is to provide a sandbox environment to allow user to preview untrusted or potentially harmful documents, so […]
You probably already know that Microsoft released a 90-day trial version of Windows 7 Enterprise, which is a full version without any function limitation. After the trial period, you can re-arm the version to another 90 days (so you can use the trial version for a total of 180 days) by taking the following steps: 1. Start->All Programs->Accessories 2. Right-click Command Prompt, then choose Run as administrator 3. Type in slmgr -rearm, then hit Enter 4. Reboot your […]