DataSets, Xml Schemas and Excel - Oh My!

• Using XML Schemas Using XML Schemas The simplest way to create an XMLType storage structure in Oracle XML DB is by registering an appropriate XML schema against the database. As a part of the registration process, Oracle automatically creates the storage for a particular set of XML documents, based on the information ...

• Using A Single Transaction With Multiple Typed DataSets Provides a detailed explanation of how to implement a single transaction across multiple Typed Data ...

• Using XML Schemas Using XML Schemas The simplest way to create an XMLType storage structure in Oracle XML DB is by registering an appropriate XML schema against the database. As a part of the registration process, Oracle automatically creates the storage for a particular set of XML documents, based on the... Visit h ...

• Using Crystal Reports in ASP.Net Making use of strongly typed datasets Using Crystal Reports in ASP.Net Making use of strongly typed data ...

• Designing N-Tiered Data Access Layer Using Datasets - Part 4 Part of the business logic encapsulated in the Typed DataSet is the ability to add specialized queries to the table adapters to retrieve the data with different filters. By manipulating the XML schema that defines the dataset and adding the correct XML metadata, Visual Studio will generate the adde ...

• Article :: Working Capital and Cash Flow Analysis in Excel This chapter describes the process of accounting for and analyzing cash fl ...

• Export data to Excel using Dataset only Export data from Dataset to Excel without using Datagrid/DataT ...

• Article :: Creating Excel 2007 Charts That Show Trends Bill Jelen walks you through your many choices for effectively displaying your Excel 2007 data in cha ...

• Article :: Building Basic Formulas in Excel 2007 Paul McFedries takes you through some formula basics in Excel 2 ...

• Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadshe...  Over the past four installments in this article series we have: created a SQL Server database for our web application; created an ASP.NET web page that enabled the visitor to upload an Excel spreadsheet and view its contents in a GridView; and created a Data Access Layer (DAL) using Typed DataSets ...