10th November 2009

ASPAlliance Times

The industry newsletter for Active Software Professionals

Sponsor Advertisement

Is Your DBMS Slowing Down Your Applications?

Relational database servers (DBMS's) have proven their value as the repository for essential line of business data. However, DBMS storage can become a performance bottleneck for mission-critical applications running on server farms and compute grids.

To eliminate this bottleneck, ScaleOut StateServer® provides a distributed, memory-based cache that offloads your DBMS and dramatically reduces response times for repeatedly accessing cached data. Its award-winning architecture automatically provides scalable throughput as servers are added to the farm or grid, giving you fast response times and integrated high availability.

Download a free evaluation copy and get started today!

Featured Article

When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a SQLBulkCopy object available in .NET to send multiple rows of data to SQL Server at once, but this still cannot be passed to a stored procedure. SQL Server 2008 provides a new feature called "Table-Valued Parameters". This provides us the ability to easily pass a table to a stored procedure from T-SQL code or from an application as a parameter.

http://aspalliance.com/1891_Pass_Tables_to_Stored_Procedure__Table_Valued_Parameter

Editor's Comments

PDC is just one week away (and TechEd Europe is going on now)! Stay tuned for some big announcements in the next week surrounding new technologies coming from Microsoft. Look for a new Open Source CMS project called Orchard to be detailed tomorrow at TechEd Europe (search for orchard in session list). Expect some new announcements surrounding Azure and probably the next version of Silverlight in the next week as well. Your best source for news on this stuff if you’re not at the shows is probably ScottGu. You can track ScottGu’s latest blog posts and tweets here.

Stay tuned for more announcements once they’re public!

Steve's Blog

New Articles on ASPAlliance.com

View All Recent Articles »

In this sixth part of the series, Vince examines the creation of a sales forecast crystal report based on the AdventureWorks database in a series of steps. He initially provides a brief outline of creating a new solution in Visual Studio 2008 and database connectivity and then demonstrates the usage of parameter fields and formula fields in addition to building an ASP.NET web page to execute and preview the report with the help of exammple screenshots and code snippets.

Sponsor Advertisement

Custom Software Development. Delivered.

NimblePros is an agile software development company that specializes in offering a helpful hand to other developers. Contact us when you need:

• An experienced developer to help get your project over the hump
• An expert developer on call
• A review of your design or processes to help you ship better code, more quickly

Call us toll-free at 888-364-3364 or go to NimblePros.com to learn more.

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.

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

Crystal Alliance Recent Articles

Sponsored by BusinessObjects

More Crystal Reports Resources »

In this sixth part of the series, Vince examines the creation of a sales forecast crystal report based on the AdventureWorks database in a series of steps. He initially provides a brief outline of creating a new solution in Visual Studio 2008 and database connectivity and then demonstrates the usage of parameter fields and formula fields in addition to building an ASP.NET web page to execute and preview the report with the help of exammple screenshots and code snippets.

In this second part of the series, Eric examines the usage of caching in Crystal Reports. He makes use of Visual Studio Team System testing to compare performance between cached and non-cached pages. After providing a short introduction and outlining the system requirements, he examines the test strategy in detail and provides a comprehensive coverage of both the NonCached and Cached loads with a detailed analysis of the results with the help of screen shots and source codes.

In this article, Vince walks the user through the process of creating a Crystal Report as a web service and then creating a web site to consume the service. After providing a short introduction, he examines the relevant steps which includes the creation of a web service, adding crystal reports file, and establishing database connectivity using Visual Studio 2008. Towards the end of the article, he examines the creation of a web site with the help of relevant source code and screenshots.

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.

This article examines the steps the author took to make the local reports work using Microsoft SQL Server Reporting Services in ASP.NET.