Ever since Microsoft started working on the ASP.NET MVC framework, one of the primary concerns was the framework's ability to re-use as many features as possible from ASP.NET Webforms. In this article by Maarten Balliauw, we will see how we can mix ASP.NET Webforms and ASP.NET MVC in one application and how data is shared between both these technologies.Read Mixing ASP.NET Webforms and ASP.NET MVC in full
One of the driving goals for the ASP.NET MVC framework has been to create a flexible framework in which every component can be extended or replaced by a custom solution, whether developed by you or obtained from a third-party vendor. In this article by Maarten Balliauw, you will learn how you can customize and extend the ASP.NET MVC framework.Read Customizing and Extending the ASP.NET MVC Framework in full
In this article by Dr. Jayaram Krishnaswamy, the process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the provided code. The approach is to introduce the programming by creating the three parts of a report: connection, dataset, and layout.Read Programmatically Creating SSRS Report in Microsoft SQL Server 2008 in full
In this article by Dr. Jayaram Krishnaswamy, we will learn about migration of data from MS SQL Server 2008 to EnterpriseDB. Migration Studio bundled with the EnterpriseDB download is a collection of tools to migrate automatically the data and business logic into Postgres from a variety of vendor products that include SQL Server, Oracle, MySQL to mention a few. This article shows you step by step how you may migrate a SQL Server 2008 table to Postgres Plus. You can only migrate tables and schemas but not database as a whole.Read Migrating from MS SQL Server 2008 to EnterpriseDB in full
As SharePoint and the underlying .NET Framework developed over the years, more readymade controls have become available for us to use in our applications. Such controls allow us to drop common, and often complex, features into our site. For example, if we would like to add user registration and login features (often referred to as personalization and membership) to our site, it is a chore to build everything we require (registration form with validation, login box, password reminder, change password, etc.) each time we build a site. Microsoft has built these controls for us so that we can easily add them to our site. In this article by Mike Poole, we will examine the use of these controls.
Very occasionally, we find that we are not able to do what we would like to do with the SharePoint configuration that comes "out of the box". A common example of this is using forms authentication in our site. Later on in the article, we will also make some configuration changes to SharePoint and associated products, such as Internet Information Services (IIS), SQL Server, and Visual Studio, to demonstrate how forms authentication can be enabled.Read Using ASP.NET Controls in SharePoint in full
Beginning with programming in Excel 2007 using VSTO 3.0 and proceeding with programming concepts, we are going to learn how to manipulate data inside Excel. Later, you will learn the concepts of workbook manipulation and worksheet manipulation, with code samples. When programming in the Excel 2007, the object model plays an important role. You will learn the most important and widely used objects, with the help of demonstrations.
In this article by Vivek Thangaswamy, we will take a look at the following:
- Excel 2007 in Visual Studio 2008, including how to start an Excel solution in Visual Studio 2008
- Excel 2007 solution: the object model, and the object model functional area
- Data and worksheet manipulation in Excel 2007
- Data processing with Microsoft SQL Server 2008
The Export and Import Wizard is an extremely useful tool for transferring data. In fact it is the simplest tool to copy over data from one database to another and to create data transfer packages that can be persisted. Data can be transferred between SQL Servers (between versions of SQL Servers for example) as well as between even two non-Microsoft databases. Both Microsoft and proprietary data source providers are available to connect to many different database products.
In this article by Dr. Jayaram Krishnaswamy, we will be transferring data from an MS Access database to a database on SQLServer 2008. Both the source of data and the destination database are on the same machine, in this case a computer box running Windows XP Pro. There are two versions of the Import and Export Wizard and in this example the 32 bit version is used.Read Transferring Data from MS Access 2003 to SQL Server 2008 in full
Hardly any standard business management application can fit the needs of a business out of the box. Either the customer must shape their processes to match the system, or the consultant must shape the system to match the processes. Usually, the latter prevails. This article will explain the process of modifying the system without programming and describe the tools we have at our disposal to do it.
In this article by David Roys and Vjekoslav Babić you will learn:
- How a non-programmer can develop killer applications
- How to customize data model, user interface, and reporting components
- What kind of changes can be made without breaking the whole thing
- And a few tricks from old dogs that got new bones ahead of everybody else