Skip to main content

Welcome to Tips dotnet

A great selection of dotnet tips and articles, and SQL Server tips. Content 100 % applied to real life projects. Material selected / categorized / commented by developers like you.

Office .net document generation
Generating Excel files using .net

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


Generating Ms Word files using .net

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


Comparing Excel Generation techniques on ASP .net

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.


Excel 2007 + Excel Services perfect combination for Ad Hoc reporting on BI

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.

ASP .net
GridView

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


ViewState

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.


Diet plan for ASP .net pages� LOOSE WEIGHT NOW !!

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.


RIA
AJAX Asp .net

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�


Tips from the trenches: Better ASP .net AJAX enabled sites

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.


Silverlight

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�


BI
SSRS

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


SSAS

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


Other .net areas
LINQ

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


Basic Sample: Generate RSS Feed using LINQ To SQL and LINQ To XML

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.


Mobile / Compact Framework

User interface standards for Mobile Development, Active Sync and .net Framework / C#, development basics, what's new on Mobile 6 / Visual Studio 2008. The mobile development also offers you to discover some extra tips at freenodeposits.com to learn how to find no deposit casino bonuses and free spins at the top-ranked online casinos.


TFS

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, �


SMTP

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


Tipsdotnet en español

Comparativa: Tecnicas de exportación / generación Excel sobre ASP .net

Excel 2007 + Excel services la combinación perfecta para hacer Ad Hoc reporting sobre BI

Plan de choque para páginas ASP .net, � A DIETA ESTRICTA !

Trucos de guerrilla: Como mejorar sitios desarrollados con ASP .net AJAX

Ejemplo simple: Generar una fuente RSS usando LINQ To SQL y LINQ To XML

Silverlight Textblock: Como hacer para que el texto se ajuste a una region dada

Configurando un timer desde code-behind con Silverlight 2.0