Archive for October, 2008
Overview CAPTCHA stands for "completely automated public Turing test to tell computers and humans apart." It is used to distinguish human end users from machines (including software). This implementation is posted on CodeProject by BrainJar. A zip files containing the source code is attached with the post too. Reference CAPTCHA [...]
Overview Apart from Paging Support, one of the features that Repeater lacks is the "Empty Data Template" that will be shown when there is no result too display. MONA blogged a very simple method to implement a "Empty Data Template" for Repeater, and this implementation does not include writing anything in code behind. [...]
Overview Repeater is very useful in displaying data with a fully customized layout. However, repeater does not have built-in paging support. I found an article in "4GuysFromRolla" by "Harrison Enholm", talking about how to add paging support to the Repeater or DataList, with the use of "PagedDataSource" Class. Reference Adding Paging Support [...]
Overview In my previous blog post Globalization of ASP.NET with Resources File, I talk about my experience in providing multi-language support for an ASP.NET web app. In that example, the web app get the cultures from preference of user’s browser. If a user wants to change the preferred culture, he/she has to change it [...]
Overview Microsoft Query does provide the "CONTAINS" criteria to check whether a field contains a value, the SQL ‘WHERE’ clause for this is "WHERE criteria_field LIKE ‘%value_to_check%’". The problem is how to use parameter with "CONTAINS" criteria? Steps With the ‘&’ operator we can easily concatenate the parameter in the "LIKE ‘%%’" [...]
Overview Let’s consider this scenario: I have a Access DB and want to retrieve the data in Excel. In Excel 2007, the easiest way to do it (as far as I know) is to use built-in Access connect ("Data" tab => "Get External Data" group => "From Access"). However, in this way I [...]
Overview In making dynamic Excel spreadsheet, sometimes we may have a function with result "#REF" or "#DIV/0". Some of these error messages are avoidable, but some of them aren’t. In this case we have to conceal (hide) the error message. In Excel 2003 or before, we were using the "IF" function to check whether [...]