Microsoft

Data Access with ADO.NET Data Services

by Jayaram Krishnaswamy | March 2009 | .NET Microsoft

ADO.NET Data Services leverages the ADO.NET Entity Framework to build data services for relational data sources. These include support for MySQL, DB2, and Oracle in addition to MS SQL Server. It can also be used with non-relational data using an add-on provider model. With ADO.NET Data Services, the developers can build dynamic internet applications (AJAX, Silverlight, etc) that works across intranets as well as the internet. With this in place data access by applications is made possible using URI Syntax and using HTTP verbs operating on the data.

In this article by Dr. Jayaram Krishnaswamy, you will learn how to create a ADO.NET Data Service from scratch. You will also learn how you may access data using the URI constructs. The backend data for this tutorial comes from a copy of Northwind database named TestNorthwind on a named instance of SQL Server 2008. In order to work through this tutorial you should have Visual Studio 2008 SP1 installed. You also need to have .NET Framework 3.5 installed.

Read Data Access with ADO.NET Data Services in full

Microsoft Office Outlook Programming Using VSTO 3.0 and C#: Part 2

by Vivek Thangaswamy | March 2009 | Microsoft

Primarily, the Microsoft Office Outlook serves as an email application for a wide range of users. In the previous part of the article, we took an Overview of the Outlook object model and its features in VSTO. We saw the extensibility of Microsoft Office Outlook 2007 using the object model. We also learned to customize Microsoft Office Outlook menus and toolbars using VSTO. In the last part, we worked with form regions in Outlook, how to manipulate folders, contact information, and mail items using VSTO programming.

In this article by Vivek Thangaswamy, we will take a look at the following topics:

  • Learning the concepts and seeing a demonstration of working with Outlook meetings and appointments
  • Working with Ribbons for Outlook 2007
  • Outlook applications and the Microsoft SQL Server 2008 database interaction
Read Microsoft Office Outlook Programming Using VSTO 3.0 and C#: Part 2 in full

Mixing ASP.NET Webforms and ASP.NET MVC

by Maarten Balliauw | March 2009 | Microsoft

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

Customizing and Extending the ASP.NET MVC Framework

by Maarten Balliauw | March 2009 | Microsoft

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

Programmatically Creating SSRS Report in Microsoft SQL Server 2008

by Jayaram Krishnaswamy | April 2009 | Microsoft

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

Migrating from MS SQL Server 2008 to EnterpriseDB

by Dr. Jayaram Krishnaswamy | April 2009 | Microsoft

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

Using ASP.NET Controls in SharePoint

by Mike Poole | July 2009 | Microsoft

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

Microsoft Office Excel Programming Using VSTO 3.0

by Vivek Thangaswamy | March 2009 | Microsoft

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
Read Microsoft Office Excel Programming Using VSTO 3.0 in full

Transferring Data from MS Access 2003 to SQL Server 2008

by Dr. Jayaram Krishnaswamy | July 2009 | Microsoft

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
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software