11th November 2008

ASPAlliance Times

The industry newsletter for Active Software Professionals

Sponsor Advertisement

SQL code completion for with Red Gate SQL Prompt

Red Gate SQL Prompt lets you write SQL more quickly by providing intellisense, code formatting, snippets for commonly used fragments of code, automatic suggestions for the most likely join conditions, and quick access to schema details and database documentation. SQL Prompt works seamlessly with both Management Studio and Visual Studio.

"I use SQL Prompt whenever I write any SQL, simple or complex, because it's such a powerful programming aid." Brian Finkel, Advanced Solutions Group

Download a fully-functional 14 day trial of SQL Prompt today.

Featured Article

In this video Mohammad Azam demonstrates how to draw 3D graphics in Windows Presentation Foundation. He walks through how to create a simple 3D object explaining important information as he types the required code. [8:57]

http://aspalliance.com/1766_Video_Introduction_to_3D_Graphics_in_Windows_Presentation_Foundation

Editor's Comments

Announcing AzureFeeds

VB MVP Serge Baranovsky created VBFeeds.com a few years ago, and shortly afterward he helped me create CSharpFeeds.com using a fork of the source code. I’ve had some interns working on that code off and on and we launched a new and improved version of CSharpFeeds around the end of the summer. The purpose of both of these sites is to provide very focused information about the topic at hand, with minimal noise. This is achieved via moderation, not algorithm, with real volunteers choosing whether something makes sense to include or not.

With the improvements in the source code, we’ve made it pretty simple to create additional technology-focused sites, with the latest one being AzureFeeds.com. We finished up development on the site last week, which only took a couple of days including all of the IIS hosting set up and creation of the new database, etc.

AzureFeeds is a community moderated site, and we’re looking for volunteers who are actively using Windows Azure to help us find the most important feeds to consume and help approve/reject individual posts for inclusion on the site. If you’re interested, email me and I’ll send you an invite.

Steve's Blog

New Articles on ASPAlliance.com

View All Recent Articles »

In this video Mohammad Azam demonstrates how to draw 3D graphics in Windows Presentation Foundation. He walks through how to create a simple 3D object explaining important information as he types the required code. [8:57]

In this second part of the series, Xianzhong delves deeper into the system design and implementation of the web tag application, which involves all the web tag related functions with the help of relevant source code and screenshots. He examines the different ways of web tag manipulation, such as displaying and moving the web tag category list, moving and removing a web tag, as well as adding, removing and modifying a web tag Category. Towards the end of the article he also examines how to add and modify a new web tag.

In this article, Anuj demonstrates the procedures involved with the creation of a plug-in for Microsoft Outlook using Visual Studio Tools for Office (VSTO). After a brief introduction, he examines the steps with the help of relevant explanation, source code and screenshots. At the end he also provides a short description involved with the deployment of the plug-in with links to useful references.

The Teradata syntax does not allow any time interval (i.e. Hr/Min/Sec) to be selected through a local variable to be added to a Timestamp value. It only permits the exact interval literal being put through a pair of quotation marks. This creates some serious limitations where the interval to be added is used through a local variable for manipulation. The aim of this Code Snippet is to provide a workaround for the use of local variables. Deepankar provides a short description of the problem followed by the suggested solution with the help of the source code. He also provides a snapshot of the final output with relevant analysis.

In this video Mohammad Azam demonstrates how to create and use User Controls in Windows Presentation Foundation. He shows how to use and interact with user controls in WPF applications. [6:03]

In this video Mohammad Azam demonstrates how to use IDataErrorInfo to perform validation in Windows Presentation Foundation. [6:06]

In this video Mohammad Azam introduces the style templates in Windows Presentation Foundation. Style Templates are used to give complex and consistent looks to the WPF controls. [4:35]

Sponsor Advertisement

Stay connected to the experts you trust with DevMavens.

Visit the ALL-NEW community and philanthropic site - DevMavens.com to learn what the most trusted community leaders like Scott Guthrie, Rick Strahl, Jeffrey Palermo, Jeff Atwood and more are saying every day.

http://devmavens.com

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.

Crystal Alliance Recent Articles

Sponsored by BusinessObjects

More Crystal Reports Resources »

Eric continues the series on how to format your Crystal reports programmatically. This can be very helpful when deploying the same reports for different customers who want a different look. He demonstrates the different formatting methods, such as custom formatting a WinForm application, and also that of Crystal objects with the help of relevant source code.

Moving reports in a sizable application from Crystal Reports for Visual Studio 2005 to Crystal Reports 2008 is a time consuming and frustrating transition - mostly because of some missing key information. This article helps you to avoid this pain by providing guidance based on the lessons the author has learned from her development experience. After providing a brief history and comparison of different versions of Crystal Reports, she examines the development of applications using Crystal Reports under Windows Vista 64 bit and gives some tips to avoid potential problems along with a brief outline of Redistribution of Reports.

In this article, Eric shows us how to give the same report a different style for your different customers with minimal involvement from the developer. After providing a brief overview and requirements specification, he outlines the formatting options with the help of source code and screenshots. Toward the end of the article, Eric demonstrates how to set different styles for your application and also provides the relevant project which you can download and work on.

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.

Sponsor Advertisement

GEMINI PROJECT ISSUE TRACKING -- FREE 5 USER LICENSE!

CounterSoft Gemini: a leading .NET based issue management platform used worldwide to manage and support software development projects. Web, Windows, Visual Studio IDE clients with MS Outlook integration.

FREE download or host with us! Special licensing for qualifying Open Source projects and Not-for-profit organizations.

http://www.countersoft.com