Skip to main content

Posts

Showing posts from May, 2009

Limit the characters in a multi row textbox

The maxlength property to limit the number of characters does not work on a multi row text box. We have to rely on custom JavaScript to limit the MaxLength functionality. Here is a snippet that does that. function ValidateCharCount(txtBox, maxLength,controlName) { var input; var length; input = txtBox.value; length = input.length; var allowedLength = new Number(maxLength); if (length > allowedLength) { txtBox.value = txtBox.value.substring(0, allowedLength); alert(" Only " + maxLength + " characters are allowed in the field " + controlName); txtBox.focus(); } } The function above takes three parameters. The first parameter is reference to the textbox control,second parameter is the max length of characters, third one is the textbox field description. The function kicks in once the texbox loses focus, alerts the user if the character count exceeded the allowed length and then truncates the characters to the a

IF by Rudyard Kipling

I came across this beautiful poem by Rudyard Kipling which totally blew my mind away. The poem is simple to read and sums up the way one has carry himself in just a few stanzas. Here it is in its entirety. [IF] If you can keep your head when all about you Are losing theirs and blaming it on you, If you can trust yourself when all men doubt you But make allowance for their doubting too, If you can wait and not be tired by waiting, Or being lied about, don't deal in lies, Or being hated, don't give way to hating, And yet don't look too good, nor talk too wise: If you can dream--and not make dreams your master, If you can think--and not make thoughts your aim; If you can meet with Triumph and Disaster And treat those two impostors just the same; If you can bear to hear the truth you've spoken Twisted by knaves to make a trap for fools, Or watch the things you gave your life to, broken, And stoop and build 'em up with worn-out tools: If you can make one heap of all your

Debug classic ASP in Visual Studio 2008 with SP1

At work we still have some classic ASP applications. Visual Studio 2008 did not support classic ASP debugging until SP1. Once you installed VS 2008 SP1, follow these steps to debug classic ASP. 1) Enable ASP server side script debugging in IIS a. To do this, launch IIS, right click on the virtual directory of your application, and click on properties from the context menu. Select the virtual directory tab from the properties windows. Click on the Configuration button in the application settings section. b. In the application configuration window, select the debugging tab and make sure that enable ASP server-side script debugging is checked 2) From your visual studio 2008, launch the classic ASP application by pressing F5. Wait for the asp page to show up in the browser 3) Once the application is launched, go to Debug --> Attach to Process to launch the Attach to process window. In that window, click on the Show Processes for all users checkbox to show all processes. 4) In the lis

Adding custom client side validation to controls inside GridView

Some times we find it necessary to provide custom validation to controls inside a GridView. Recently I had to have a DropDownList for selecting a country inside a gridview, the country dropdownlist contains several items including an item with the text "Other". When "Other" is selected, a textbox should show up where in the user can provide the rationale for selecting "Other". Also, I had to make sure that the textbox is not left blank when "Other" is selected. To Recap Requirements: Make sure that a value is selected from the country dropdownlist. When "Other" is selected for country, show a textbox to show enter what the "Other" country is Make sure that a value is entered in the textbox when "Other" is selected First the GridView, for simplicity I'm just showing the country dropdownlist and the TextBox. Both those controls are included in a templatefield in the GridView Leaving out the databinding details. I a

Find the cause of poor performance in Sql Server

I found the following two part article by Gail Shaw on Simple-Talk really helpful in trouble shooting poorly performing queries in Sql Server. The articles talks about spotting poorly performing queries with the help of the Profiler, understand Sql Server Query plans and fine tune the peformance using proper indexes. Part 1: http://tinyurl.com/ccl6gj Part 2: http://tinyurl.com/okcuqg

Validating checkbox list in asp.net using JQuery

ASP.net does not provide in built support to validate a checkbox list. We have to rely on custom javascript to verify if at least one checkbox in the list is checked. Since we cannot add a validator to the checkbox list, I usually put a dummy textbox on the form and add a custom validator to that textbox. <asp:CheckBoxList ID="cblLostDescription" runat="server" RepeatDirection="Horizontal" TabIndex="14"> <asp:ListItem Value="L">Lost/Stolen</asp:ListItem> <asp:ListItem Value="D">Destroyed</asp:ListItem> <asp:ListItem Value="M">Damaged</asp:ListItem> <asp:ListItem Value="O">Other</asp:ListItem> </asp:CheckBoxList> <asp:CustomValidator ID="custValDescrption" runat="server" ErrorMessage="Property Description is required" Display="Dynamic" ControlToValidate="txt