Welcome to Tips dotnet

Compilation of articles about how to generate Excel docs using .net: XMLSS, CSV, direct GridViewExport techniques, Open XML, Office Web Components, SSRS.

Guide to combine XML data with Office 2007 docx files (Open XML), WorML reference, generating files combining rtf+XSL.

There are a lot of different approaches available for Excel Generation on ASP .net, and none of them seems to be a silver bullet� (some of them are limited, some others have an associated license cost, or pay a penaly on performance, ...).

This post tries to shed some light in this area and easy the process of selecting which approach to follow in your web application.

There are many tools available in the market for Ad Hoc reporting, for instance Ms offers tools like Report Builder (SSRS) and Performance Point Analytics (former Proclarity Analytics). But... Excel 2007 and Excel Services seems to be the best set of tools for ad hoc reporting... let's see why.

Custom paging and ObjectDataSource, exporting a GridView to Excel, combining AJAX and GridView to show additional information on selected rows, alternatives to GridView�

Since the inception of ViewState if has had a love-hate relation with developers, in one hand in simplifies the development of your pages, in some other it can be a serious performance killers, any ASP.net developer should understand the inners and secrets of the viewstate, when and how to remove it to avoid performance issues. In this section you will find articles that will help you on understanding how it works, how to measure the impact on your pages and how to eliminate it control by control.

If we don�t take care about how we feed our ASP .net pages� we will find that they will tend rapidly to gain too much weight, this can provide us a lot of headaches. Let's see how to reduce the size of our pages.

Partial Rendering vs Script Services, how to combine AJAX with Silverlight, ViewState and impact on AJAX applications, conditional mode on update panels, consuming json webservices using AJAX ASP .net�

Since the inception of ViewState if has had a love-hate relation with developers, in one hand in simplifies the development of your pages, in some other it can be a serious performance killers, any ASP.net developer should understand the inners of the viewstate, when and how to remove it to avoid performance issues. In this section you will find articles that will help you on understanding how it works, how to measure the impact on your pages and how to eliminate it control by control.

How to start developing / tutorials, how to call a javascript method from silverlight and the other way around, using a DataGrid, free open source charting engine�

Consuming reports from ASP .net applications, Subscriptions API, Office Writer extensions for SSRS, �

How to read data from a cube using C# and ADOMD, OWC and Cubes, MDX Performance analyzer, SSAS Performance guide.

Tutorials, LinqDataSource and caching, LINQ To SQL Showstoppers, LINQ To XML intro.

Learn LINQ To SQL and LINQ to XML by example

Simple, step by step, sample about how to generate an RSSFeed using LINQ and LINQ TO SQL in only five lines of code.

User interface standards for Mobile Development, Active Sync and .net Framework / C#, development basics, what's new on Mobile 6 / Visual Studio 2008.

How to move your TFS from one network or machine to another, get lastest vs check out issue solved, guide to learn TFS for VSS users, �

Troubleshooting guide, is the problem on the code or is a permissions / network issue?, system.web.mail and system.netmail FAQ, MIME format.