September 2007 - Posts

3
Comments

Using IValueConverter to format binding values in WPF by marianor

First we need implement the value converter, to accomplish this we need to create a new class that implements System.Windows.Data.IValueConverter, this interface works only for simple binding. If you need to use multi binding you will need implement System...
Filed under:

Comments

How to do virtual paging with ASP.NET, AJAX and SQL Server 2005 by marianor

This sample provides a way to avoid full postback of the page, just updating the grid that contains the data. The first step is create the stored procedure, for that I will use CTE (Common Table Expressions), which is a new feature of SQL Server 2005...
Filed under: , ,
2
Comments

Parsing SQL Like to avoid overloads SQL Server by marianor

When using Stored Procedures or embeds SQL in a query generally we forget about parse the parameters where a Like condition is present. The are two possible wildcards for the LIKE function in SQL Server, that are _ (underscored), that replaces a character...
Filed under:
More Posts