Wednesday, June 20, 2007

Using the PayPal Payment System in ASP.NET

Those who create commercial sites are faced with the question: "How do I receive payments?" One of the most popular payment systems in the world is PayPal. This system is often chosen because it is reliable, easy to use, and allows an account to be opened easily. Click title to learn more...

Thursday, April 26, 2007

Using the EXCEPT operator, new in SQL Server 2005

The linked article shows how you can use the new EXCEPT operator in SQL Server 2005 using an example. Click here to learn more...

Tuesday, April 17, 2007

Email messages with embedded images in ASP.NET 2.0

Creating email messages with embedded images in ASP.NET 2.0. Read more here...

Thursday, April 05, 2007

CSS 101: Locate and style Web elements with selectors

This is second of the 101 series of article presented by Tony Patton on CSS. This goes about discussing Locating and styling Web elements with selectors. Click to learn more...

CSS 101: Handling multiple rules for the same element

This is first of the 101 series of article presented by Tony Patton on CSS. The first top goes about discussing Handling multiple rules for the same element. Click to learn more...

Wednesday, April 04, 2007

Common Table Expressions in SQL Server 2005

Common Table Expressions, or CTE, are a new construct introduced in Microsoft SQL Server 2005 that offer a more readable form of the derived table that can be declared once and referenced multiple times in a query. Read more...

Friday, March 30, 2007

Optimizing ASP.NET 2.0 Web Project Build Performance with VS 2005

The linked posts covers how to best optimize the build performance with Visual Studio 2005 when using web projects. If you are experiencing slow builds or want to learn how to speed them up please read on...

Deployment problems and their solutions of web application Asp.Net 2.0

Deploying ASP.NET 2 web site is the first issue facing the developer after finishing to create a web site is how to deploy the web site to a remote/Production server. Learn more...

Deploying a Crystal Reports Application to a Remote Server

When deploying a Crystal Reports application written in ASP.NET, must the remote server have the Crystal Reports .NET server components installed? Well.......know more from here...

Wednesday, March 28, 2007

VS 2005 Web Deployment Projects

Microsoft is shipping on the web a new free add-on to Visual Studio that enables what we call “Visual Studio 2005 Web Deployment Projects”. This add-on provides a lot of additional deployment features and capabilities that complement the built-in web project support in the product. Learn more...

How To: Write a MSBuild Task

Tasks provide the code that runs during the build process and are contained in targets. A library of common tasks is provided with MSBuild and you can also create your own tasks. Learn more...

Using Web Deployment Projects with Visual Studio 2005

Visual Studio 2005 provides deployment support through its Copy Web Site and Publish Web Site features. While these are ideal for many scenarios, there are other, more advanced scenarios where developers need the following capabilities:
  • More control over assembly naming and output.
  • Custom pre-processing and post-processing for the build.
  • The ability to exclude, add, and transform files and directories during builds.
  • The ability to modify the Web.config file to change database connection strings, application settings, or the URLs for Web references, depending on the build configuration. (For example, it might be necessary to use different values for development, test, staging, and release settings). Learn more...

Tuesday, March 27, 2007

Design Patterns for ASP.NET Developers, Part 2: Custom Controller Patterns

"Controller patterns," are also suitable for use in ASP.NET. These patterns extend the capability for displaying a single view by allowing applications to choose which view to display at runtime depending (usually) on user interaction. Learn more...

Design Patterns for ASP.NET Developers, Part 1: Basic Patterns

"Fundamental to any science or engineering discipline is a common vocabulary for expressing its concepts, and a language for relating them together."
"... a body of literature to help software developers resolve recurring problems encountered throughout all of software development."
"... a shared language for communicating insight and experience about these problems and their solutions."
"A pattern is a named nugget of insight that conveys the essence of a proven solution to a recurring problem within a certain context amidst competing concerns."

Learn more...

Monday, March 26, 2007

Working with ReportViewer control of ASP.NET 2.0

Reporting is one of the common requirement of any data driven business application. Since version 1.x ASP.NET was lacking this important feature. In spite of add ons such as Crystal Report Viewer the .NET framework always lacked native support for reporting engine. Fortunately, .NET 2.0 comes with a ReportViewer control that meets your basic reporting needs. Though it lacks some of the fancy frills provided by some other third party vendors it certainly fills the gap. More...

Friday, March 23, 2007

Common Web Project Conversion Issues and Solutions

As you convert your Visual Studio 2002/2003 Web projects to Visual Studio 2005, you may encounter issues with the changes made in the Web project system. In the linked article, we will look at both the conversion process and some of the common issues you may encounter during a conversion. Read more here...

ASP.NET 2.0 Tips, Tricks, Recipes and Gotchas

The linked page lists some of the more popular “ASP.NET 2.0 Tips, Tricks, Recipes and Gotchas” posts Scott Guthrie have done over the last year.

To learn more about ASP.NET, also make sure to watch all of the great “ASP.NET: How Do I?” videos (each week a new video is posted).

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2005

Is it still possible to build web projects that encapsulate common libraries of .ascx web user controls or .aspx pages with VS 2005 that can then be easily re-used across multiple other web projects (note: the quick answer is “yes"). find out how...

Upgrade from ASP.NET 1.x

ASP.NET 2.0 contains a wealth of new features and capabilities for ASP.NET developers. Learn how to best use the new features and explore the changes to the architecture in ASP.NET 2.0.
Using Visual Studio 2005 Web Application Projects is the recommended model for converting an existing ASP.NET 1.x Web application created using Visual Studio .NET 2002/2003 to ASP.NET 2.0 for editing with Visual Studio 2005. Migration using Web Site Projects is available to developers who are interested in converting their Visual Studio .NET 2002/2003 Web applications to the new Visual Studio 2005 project model. Upgrading using Web Site Projects can result in major modifications to an existing Web application whereas upgrading using Web Application Projects requires minimal code and project modifications. Learn more...

Top 10 SQL Server indexing tips to improve performance

Significantly improve your SQL Server performance through proper indexing choices. We've tallied our most popular tips on the topic of indexes so you'll be able to quickly get the answers to your indexing questions. Learn how to weed out valueless indexes, design high performing indexes and query your existing SQL Server indexes.

#1 -SQL Server 2000 indexing dos and don'ts

In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec outlines best and worst practices for indexing in SQL Server 2000.

#2 -Indexes made handy in SQL Server

Indexes should be reviewed to ensure prime performance. Weed out valueless indexes in SQL Server, while identifying the best indexes for your application.

#3 -Partition indexes for improved SQL Server 2005 performance

SQL Server 2005 index partitioning allows you to distribute the load for a given index across multiple files. Learn how to create an index with partitioned data.

#4 -Stored procedures: Create and delete constraints and indexes

This collection of six stored procedures will help you create and delete constraints and indexes.

#5 -Tricks for using the Index Tuning Wizard

Learn how to improve overall SQL Server 2000 performance with these Indexing Tuning Wizard tricks from Edgewood Solutions' Jeremy Kadlec.

#6 -Undocumented stored procedure: Repair table indexes with sp_fixindex

One undocumented stored procedure in SQL Server 2000 can be used to repair a corrupted table index. This tip explains how to use sp_fixindex to keep SQL Server running smooth.

#7 -Undocumented stored procedure: Find space occupied by all tables and indexes

Here's a quick way to find the space occupied by all tables and indexes in a SQL Server 2000 database.

#8 -Solving SQL Server 2000 index fragmentation

Edgewood Solutions' Jeremy Kadlec explains how indexes become fragmented and how to maintain beneficial indexes to ensure high performance.

#9 -Indexing Q&A: Answers to your common indexing questions

Know how to choose proper indexes for your business situation. In part one of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers common indexing questions.

#10 -Clustered and non-clustered indexes in SQL Server

Rules for using a clustered vs. a non-clustered index are tough to decipher. In this tip, you'll see the fundamentals to consider when making your choice, along with some best practice techniques. Get an overview of tradeoffs and proper index implementation, as well as other areas involved in your decision, including partitioning and storage arrays.

Note: This article is brought to you by searchsqlserver.techtarget.com