Use a CTE along with ROW_NUMBER() to Paginate Records in SQL 2005(blog.troyd.net)

submitted by powerrush(3873) 4 years, 9 months ago

You may be familiar with ROW_NUMBER(), but did you know you'll also need to combine that with a Common Table Expression (CTE) to paginate through your records? read more...

add a comment |category: Database |Views: 15

tags: 2005 SQLServer SqlServer2005 .Net ASP.NET another

Banker's Rounding vs. Common Rounding in .NET (blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

Depending on your math background, .NET's rounding functionality MAY NOT work the way you expect!!! Check out the included code to implement an alternative (known as Common Rounding) in addition to .NET's built-in Math.Round() function. read more...

1 comment |category: C# |Views: 36

tags: .net2.0 Math C# another

ZIP or Address Radius Search Function for SQL Server 2000(blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

SQL Server 2000/2005 function to calculate distance in miles between 2 latitude/longitude points for zip or address proximity search, etc. read more...

add a comment |category: Database |Views: 177

tags: T-SQL Geocoding UDF SQL SQLServer another

Custom "All or Nothing" Required Validator web control in C# (blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

C# code for an ASP.NET required validator web control that requires a specified set of controls to be all populated, or all empty, as a group. It inherits from the RequiredFieldValidator ASP.NET class, so it essentially works the same way, it just treats the set of controls you specify as if they were one control (in the sense of requirement). read more...

add a comment |category: ASP.NET |Views: 5

tags: ASP.NET Validation C# Controls another

Credit Card Number Validation VB.Net Function (blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

This VB.Net code checks the validity of a credit card number. Pass a credit card number to the function and it returns true or false based upon the CC number's validity. read more...

add a comment |category: VB.NET |Views: 382

tags: Validation eCommerce VB.NET ASP.NET another

.NET code to convert an ArrayList to a comma delimited string (CSV)(blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

Free .NET code that converts the contents of an ArrayList to a comma delimited string (CSV) or other character delimited string. read more...

add a comment |category: Tips & Tricks |Views: 109

tags: ASP.NET VB.NET another

Six Custom .NET String Manipulation Functions for Everyday Use(blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

Six Custom .NET String Manipulation Functions / Methods for Everyday Use read more...

add a comment |category: C# |Views: 15

tags: ASP.NET C# another

.NET code to convert a SQL query to CSV format for output to file, etc(blog.troyd.net)

submitted by powerrush(3873) 4 years, 10 months ago

Free VB.NET code to convert a SQL query to CSV format for easy output to a file, the console, or via a HttpResponse (for you ASP.NETers out there looking for an easy way to dynamically output a CSV for real-time data download) read more...

add a comment |category: ADO.NET |Views: 214

tags: NUnit SQLServer HttpResponse DataReader VB.NET another

Regionerate Public Beta(rauchy.net)

submitted by rauchy(455) 4 years, 11 months ago

Regionerate is an open-source automatic layout enforcement tool for C#. I have just released its Public Beta. Enter the site for a quick screencast that explains all about it. read more...

3 comments |category: C# |Views: 11

tags: Formatting Code C# another

Why TDD Works For *Me*(knowledgebits.blogspot.com)

submitted by rauchy(455) 5 years, 2 months ago

A look at the advantages of Test Driven Development from the developer's point of view instead of the project's. read more...

add a comment |category: Unit Testing |Views: 5

tags: Unit Testing TDD another