12th August 2008

ASPAlliance Times

The industry newsletter for Active Software Professionals

Sponsor Advertisement

Want to write your queries faster?

Some developers write SQL amazingly fast. Do you want to know their secret? It’s SQL Prompt. "This is a must-have tool for all T-SQL developers." Brian Brewder, Brian Online.

Download a free 14-day trial of Red Gate SQL Prompt

Featured Article

In this article, Xianzhong Zhu wraps up his three part series by providing a summary of some of the key techniques required to construct the sample blog system from the perspective of the clients. He examines some of the techniques which enhance the reading of blogs such as implementation of recommended articles section and modal dialog box. He also provides a detailed coverage of the integration of CAPTCHA control into the system to minimize unsolicited comments.

http://aspalliance.com/1698_Developing_an_ASPNET_AJAX_Server_Centric_Based_Mini_Blog_System__Part_3

Editor's Comments

Yesterday Visual Studio 2008 and .NET 3.5 SP1 was officially released. It’s now available here. This service pack includes a lot of bug fixes but also a bunch of new features. For instance, there have been some major performance increases for WPF applications, richer JavaScript support for Visual Studio, full support for SQL Server 2008, and performance improvements for Team Foundation Server integration. In addition, there’s a great new feature for the HttpRuntime.Cache object that will let you update items in the cache before they expire, allowing you to keep the cache fresh without requiring users to suffer through a cache-miss. I’ve been asking for this feature since .NET 1.0 so I’m very happy to see it included. SP1 is recommended for anybody doing work with VS 2008 and/or .NET 3.5.

Steve's Blog

New Articles on ASPAlliance.com

View All Recent Articles »

Billing is a critical factor for web hosting providers, ISPs, Consultants, and Independent Software Professionals. Normally, self hosted billing systems are used by web hosting providers. The providers should automate the billing system during the initial phase itself. Otherwise, they will find it difficult to manage the growing number of customers as time progresses. In this review, Anand put to test a PHP based billing application and demonstrates its working and usefulness. He also suggests improvements which he prefers to see in the next version of the product.

In this video Mohammad Azam demonstrates how to merge assemblies using PowerShell and ILMerge. He demonstrates this along with his reusable user control example. He takes his reusable user controls and merges them into one assembly. [6:01]

Nowadays, SQL injection is a big threat for websites. It is a technique by which hackers can execute dangerous SQL commands by taking advantage of un-sanitized input opportunities in web application. While there is a good amount of best practices to prevent SQL injection in ASP.NET, ASP has very little information. In this article, Ehsanul examines a quicker and easier way to sanitize input parameters as well as the design plan for a new website to protect from SQL Injection. After a brief introduction, he demonstrates the technique with the help of relevant source code and screenshots. Towards the end of the article, he provides some tips to avoid database related errors and a list of useful reference articles.

ASP Alliance Authors' Recent Blog Entries

More Blogs »

ASP Alliance Most Popular Articles

More Articles »

Sometimes you need to create reports quickly. You might not always have time to format fancy reports containing graphs. Or maybe you have to create reports that do not need graphs. Reusing one ASP.NET web page you can display many reports.

In this article the author presents a comprehensive solution to build a GridView with template fields generated at run time with in-place Insert, Delete and Edit operations with a full description of an effective implementation and usage of ITemplate interface.

Determine if a user's Session is still active.

In this article we will look into the __doPostBack function of JavaScript. Read the article to find some insights about the function.

A quick cheat sheet that highlights some key syntactical differences between C# and VB.NET. While this is not all inclusive this cheat sheet proves to be a handy reference.

Crystal Alliance Recent Articles

Sponsored by BusinessObjects

More Crystal Reports Resources »

This article demonstrates the creation of sub-reports using Crystal Reports. After providing a short overview of the database design, the author delves deeper into the report building process in a series of steps with associated screenshots. Towards the end of the article, he shows us how to display the report on a web page.

Many times beginning Crystal Reports authors overlook the powerful feature of cross tabs, in this article we discuss the basics of creating and formatting cross tabulations in Crystal Reports 2008.

In this video, Mohammad Azam demonstrates how to create sub-reports in crystal reports. He walks you through the steps required to display hierarchical data using crystal reports. [8:40]

SQL Server Reporting Services Recent Articles

Sponsored by SoftArtisans

More SQL Server Reporting Services Resources »

In this second part of the series, Eric shows the reader how to create a burndown chart using Reporting Services, Visual Studio 2008, and Team Foundation Server (TFS) 2008 for an agile project. After giving a short introduction and the requirements, he examines the creation of burndown reports with the help of relevant SQL statements and screen shots.

In this first part of the series, Eric shows the reader how to create two reports using Reporting Services, Visual Studio 2008, and Team Foundation Server (TFS) 2008 for an agile project. After giving a short introduction and the requirements, he examines the creation of scenario story report with the help of relevant SQL and screen shots.