Browse by Tags

21 June 2007
SqlServer: Return Random Records in T-Sql, the GUID way.

In one of the website I have developed, we feature random products displayed on a webpart. This can be done several ways either of the code behind or via t-sql but I think the simplest way to do it is via t-sql with the help of Guid columns. Globally Unique Identifier or GUID is a randomly generated... Read More...

no comments

Filed under: .NET, sql server , how to, stored procedures, sql, sequel server

21 June 2007
.NET: Updated: Simple and Stupid BackgroundWorker Example

I was very busy the past weeks, I cannot imagine I could make it not to code for several days, been a carpenter, janitor, messenger and everything hehe. But I'm here again now. Let me start this out with this stupid sample I just given to one of my junior developer. BackgroundWorker is a special... Read More...

7 comment(s)

Filed under: .NET, windows forms, C#, threading, backgroundworker

04 April 2007
ASP.NET: Url-Rewriting In Migrated Website

Wow, it was January since my last post! sorry guys I'm was very busy coding, monitoring our house' dev't in province, preparing my relocation and some business matters. Anyway, a fellow filipino developer at msforums.ph raised the question if its true that URl-Rewriting "damage"... Read More...

8 comment(s)

Filed under: .NET, ASP.NET, usability and design

23 January 2007
ASP.NET: Utility.TryParse() To Better Handle Parameters

In ASP.NET, one of the tedious things to do is to get values from query string parameters, cast/convert to proper types and assign to local variable for further processing. Initally most developers simply code like this: 1 int orderId = Request.QueryString[ "order_id" ]; 2 OrderBLL orderManager = new... Read More...

1 comment(s)

Filed under: .NET, ASP.NET, how to, resharper

20 January 2007
.NET: Build.Cancel = Ctrl + Break

If you're not using this shortcut you probobly be either using a build server or build script on your project OR you are suffering from waiting for your build to start and press Stop to continue working, because you have accidentally pressed the F5 while coding. Now that you're have 5+ web projects,... Read More...

2 comment(s)

Filed under: .NET, visual studio, ide

16 January 2007
.NET: Advanced Data Paging with Sorting In SqlServer 2005

dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check... Read More...

6 comment(s)

Filed under: .NET, sql server , ASP.NET, how to, scripts, stored procedures, sequel server

16 January 2007
L10N: Maintainable Resex Files

When you plan to make your project multi-language and you are nearing its completion it is not smart to put those resource strings on a .resex files and edit right from your IDE. Why? Simply because it is not maintainable and hard to track changes whenever you add new entries. Also, your translators... Read More...

3 comment(s)

Filed under: .NET, ASP.NET, L10N, localization, user interface, internationalization

15 January 2007
.NET: Redundant ToString() method

It is only when I used Resharper that I learned I have been redundantly calling ToString() method when concatenating other types with a string type and assign it into string variable. The code below work just fine despite different types involved in the expression. 1 int value1 = 100; 2 decimal value2... Read More...

6 comment(s)

Filed under: .NET, ASP.NET

04 January 2007
ASP.NET: Avoid name collisions and data loss, keep those keys out of code-behind

If you have developed ASP.NET applications you might share the same sentiment of forgetting session keys, cache item keys and query string variables. It is very important that you document each of them outside your code to avoid name collisions and accidental data loss. Sometimes you will forget those... Read More...

2 comment(s)

Filed under: .NET, ASP.NET

17 December 2006
L10N: Will your translators understand your RESEX files.

In few days I have to hire a Danes translator and I wanted it to be easy for her to encode[:) of course!] and be guided properly what to put in. Initially I thought a friendly naming on resource ids is sufficient, but I was wrong. It won't help her because different pages share the same resource strings... Read More...

2 comment(s)

Filed under: .NET, ASP.NET, tektips, how to, L10N, localization, internationalization

15 December 2006
.NET: Coderush addict sharpen by Resharper 2.5

I have been using coderush before in VS2003 but when I shifted to VS2005 I started to love its intelliesense, syntax support and refactoring. I must admit when I won the resharper license, Im hesitant to use it. Shame on me cozIm afraid it might mess up my IDE, slows its performance and override my shortcuts... Read More...

no comments

Filed under: .NET, tektips, developer tools, resharper

14 December 2006
.NET: Increase Application Perf with ViewState Persistence Tweaks and Optimizations

I was amazed most of us hate ASP.NET ViewState for its default poor implementation which if not taken into cosideration would kill our applications performance, client resources, and drive shoppers away. Its frutrating... If worst case you haven't heard of ViewState and I assume you are probably new... Read More...

3 comment(s)

Filed under: .NET, ASP.NET, usability and design, tektips, optimization, compression, viewstate, performance tuning

03 December 2006
.NET: In the midst of CSS browser incompatibilities, use conditional comment flags

I hope that one day I will wake up that all web-shoppers are using IE7, firefox and opera... and IE6 will be burned into forgetten in the e-commerce arena. I hate it when simple CSS rules never worked on IE but works fine on Firefox, Opera and Safari where 80% of our consumers uses IE6 and 20% users... Read More...

no comments

Filed under: .NET, ASP.NET, usability and design, user interface

25 November 2006
.NET: Unable to load one or more of the requested types exception in winforms

I have encoutered this very strange error when Im trying to modify one of my user controls on a winddows forms module. It's the first happened to me so I assume I can fix this just by cleaning up the bin folder, update references, reload or restart the project. To no avail, I have googled around and... Read More...

2 comment(s)

Filed under: .NET, windows forms, controls

24 November 2006
.NET: I think I, we, will be using TimeSnapper

Yes, you heard it right, I think we will be using TimeSnapper .This can be very helful to me and my team mate to collborate and share screens on what are doing or what actually happened in a period of time. I don't know if we can drag images from TimeSnapper into Yahoo Messenger conversation directlly... Read More...

3 comment(s)

Filed under: .NET, Development Process, independent consulting, developer tools