Colt Kwong Blog
.NET is out there
-
List all tables and their row counts
Just find few useful tips/tool when I try to compare the schema and content of two SQL databases:
-
Grant SPROC Permission to an Application Account
With the principle of least privilege of application / database account, web app normally uses a DB account with limited permission to specific database objects in Connection String.
-
Back Pressure Problem in ASP.NET Emailing
I got an error message about "Back Pressure" when I was developing a ASP.NET emailing function recently. The code and configuration are good and I have no idea what is this issue, so I search MSDN and found this page about what is "Back Pressure" (for Exchange 2010 by the way).
-
Tips: Merge multiple CSV files into one
-
Set focus to a TextBox (in a ModalPopupExtender)
I have a web page where couple of ModalPopupExtender and Panel exist, and I want to set focus to TextBox inside the corresponding pop up window when user click the target button accordingly. I think it's a common requirement to set the focus to a specific TextBox immediately when user open up the window. However, I always get the error message "Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus".
-
Turn TextBox.Text to CAPITAL or small letter in CSS
I'm looking for a simple function that turn the text of a TextBox into capital or small letter, but most of the JavaScript I found are clumsy because of the incompatibility of script (including the inconsistent behavior of event.keyCode and event.which in different browser).
-
Preview a web page in different versions of IE
I used Multiple_IE in the past when I wanted to test and verify something of my developed web app across browsers.
-
JavaScript tips
I was writing a lot of jQuery and JavaScript this weekend, and two tips that I would like to jot down for future reference:
-
Register Schema Master in Active Directory
In order to view the complete schema in AD, I have to register the schmmgmt.dll and then open a snap in in MMC, the steps can be summarized as:
-
Expandable or Auto-Resize TextBox Height
Recently, I was asked to prepare a Facebook like expandable textbox in a ASP.NET web application, where user can input text and the textbox can be re-sized (more specifically the height) dynamically.