Browse by Tags

All Tags » T-SQL (RSS)
Wednesday, April 04, 2007 12:04 PM

T-SQL - Enabling Dynamic Sorting using CASE

Let’s visualize you have a database table as below: Column Name EmployeeID Name IC DateOfBirth Data Type Numeric(28,2) Varchar(100) Varchar(50) DateTime Then you want to have a GridView in the user interface that looks like this: Header Name No...
Posted by chuawenching | with no comments
Filed under: ,
Friday, March 09, 2007 4:33 PM

Transact-SQL – Input Search in a Filter selection

This is some basic thing, but I think it will be cool to blog about. Assuming you has this scenario: Search Criteria : [DropDownList] Item[0] – New IC Item[1] – Old IC Item[2] – Passport Search Now : [TextBox] Normally what people will...
Posted by chuawenching | 2 comment(s)
Filed under: ,