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 April 2007
.NET: A Significant Discovery On TortoiseSVN

I had very bad intermittent connection lately and this TortoiseSVN is really killing me. With my speaker system tuned on 60% volume playing jazz music to stimulate my mind, while I'm committing several files on our server, suddenly the SVN's error sound breaks my silence. This sound is really... Read More...

2 comment(s)

Filed under: how to, subversion

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

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

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

08 November 2006
L10N: The world is flat, start localization on your database

When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not... Read More...

no comments

Filed under: .NET, sql server , ASP.NET, usability and design, Development Process, how to, L10N, localization, scripts, stored procedures, user interface, sql, sequel server

23 October 2006
SQL Server: Copy query results including headers

Maybe some of us are used into copying results of our query and pasting it to Excel for further analysis or reporting, but we are also used into SQL 2000 behaviour. With Sql Server 2005 Management Studio, you can copy and paste the query results including the headers. Just goto, Query -> Query Options... Read More...

1 comment(s)

Filed under: .NET, sql server , tektips, how to