| Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET |
| MSDN |
| Discover how to generate XML from a dataset, format the XML using a Stylesheet, and then use code to open the transformed XML. |
|
| ASP.NET & Databases : Part 5 |
| ASP Alliance |
| In Parts 1 - 4 we have talked about connecting, storing, viewing and in this part we take a break and look at some XML. XML in .NET is a very important part, XML is used in nearly anything in .NET, from web services, to datasets. Even SQL Server 2000 supports XML. XML has taken a good foothold in data storage. |
|
| BETA-HOWTO: Transfer XML Data to Microsoft Excel 2002 Using Visual C# .NET (Q307029) |
| Microsoft Support |
| Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 by using either the user interface or code. With Visual C# .NET, you can take advantage of Excel's XML functionality to seamlessly transfer data to a workbook to present the data with formatting and an arrangement of your choice. This article demonstrates how to accomplish this task. |
|
| BUG: A Typed DataSet That Imports a Secondary Schema Cannot be Used As a Method Parameter or As a Return Type with ASP.NET Web Services |
| http://www.kbalertz.com/ |
| (317340) - You cannot create a Web service proxy when the Typed DataSet that imports a secondary schema is used as a parameter or as a return type from the WebMethod . If you try to do this, the following symptoms may occur: When you generate the Web service... |
|
| BUG: Data Loss When You Recursively Navigate an XmlDataDocument (Q325690) |
| http://www.kbalertz.com/ |
| When you try to recursively navigate an XmlDataDocument that has been synchronized with a filled ADO.NET DataSet, all of the data is not returned. |
|
| C# XML Directory Lister |
| The Code Project |
| I was looking for a useful little project to start learning C# and the .NET framework. In my job we do a lot of things with XML so I was interested in exercising some of the XML classes. In particular I wanted to see how XML and ADO+ fit together. The result is the code in this project. This code generates a list of entries in a directory as XML. The XML can be returned to the caller as an XML string, a W3C DOM document, or an ADO+ DataSet.
|
|
| Data Relations and Relatives |
| MSDN |
| A large number of applications need to render data that is somehow related to other data. A well-known example that illustrates this is given by the very popular Customers table that needs to link to an equally famous Orders table. What do they have in common? An even more famous CustID field, of course. How do you typically solve the problem of rendering all the orders for a given customer? According to the constraints and the requirements of your application, you might be applying a number of feasible solutions. |
|
| DataCalendar |
| The Code Project |
| A data-driven, templated sub-class of the ASP.NET Calendar control |
|
| DOC: Clear() Method Throws an Exception When DataSet Is Bound to XmlDataDocument (Q307511) |
| http://www.kbalertz.com/ |
| The "DataSet.Clear Method" topic in the Microsoft .NET Framework Class Library documentation specifies that the |
|
| Exposing Proprietary Data the .NET Way |
| MSDN |
| The .NET Framework comes with the OLE DB managed provider, which is meant to be a bridge that gives you immediate access to all the existing OLE DB providers. This component saves your current investments, as applications can continue successfully calling into existing OLE DB providers. The point, though, is another. In .NET, exposing proprietary data requires a more thoughtful choice, mostly because you have multiple and equally powerful options from which to choose.
|
|
| How to use XML in connected and disconnected ADO.NET applications in Visual C++ .NET 2003 |
| http://www.kbalertz.com/ |
| (815671) - XML is a fundamental part of Microsoft ADO.NET and XML Web Services. This article describes how to use XML in connected and disconnected ADO.NET applications: Connected ADO.NET applications can query Microsoft SQL Server to return an XML result and... |
|
| How to use XML in connected and disconnected ADO.NET applications in Visual C++ .NET 2003 |
| http://www.kbalertz.com/ |
| (815671) - XML is a fundamental part of Microsoft ADO.NET and XML Web Services. This article describes how to use XML in connected and disconnected ADO.NET applications: Connected ADO.NET applications can query Microsoft SQL Server to return an XML result and... |
|
| HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET |
| Microsoft Support |
| (307021) - Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual Basic... |
|
| HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual Basic .NET |
| http://www.kbalertz.com/ |
| (307021) - Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual Basic... |
|
| HOW TO: Transform a DataSet to Spreadsheet XML for Excel by Using Visual Basic .NET and ASP .NET |
| http://www.kbalertz.com/ |
| (319180) - This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and... |
|
| HOW TO: Transform a DataSet to Spreadsheet XML for Excel by Using Visual Basic .NET and ASP .NET |
| Microsoft Support |
| (319180) - This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and... |
|
| HOW TO: Use XML in Connected and Disconnected ADO.NET Applications (Q307224) |
| Microsoft Support |
| This article demonstrates how to use XML in connected and disconnected ADO.NET applications. Connected ADO.NET applications can query SQL Server to return an XML result and then use the XmlReader class to iterate through the rows of XML data. Disconnected ADO.NET applications can use a DataSet object to pass data in XML format between the different tiers in a distributed system. |
|
| INFO: Roadmap for ADO.NET |
| http://www.kbalertz.com/ |
| (313590) - This article provides a way to learn about ADO.NET. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers to help you learn about a Microsoft product or... |
|
| PRB: Slow Performance When Transforming an ADO.NET DataSet with Non-Nested DataRelations |
| Microsoft Support |
|
(325693) - Performance of your computer system slows when you try to transform the XML representation of a DataSet that has multiple related DataTable objects whose DataRelation objects are not nested to reflect a hierarchical structure.
|
|
| Reading and Writing XML Documents |
| C# Corner |
| In this article you will see how to read and write XML documents in Microsoft .NET using C# language. First I will discuss XML .NET Framework Library namespace and classes in brief. Then we will read and write XML documents. At the end of this article, I will show you how to take advantage of ADO.NET and XML .NET model to read and write XML documents from relational databases and vice versa. |
|
| Use ASP.NET or Visual Basic .NET to Transform XML to RTF and Display in Word |
| MSDN |
| Create useful documents quickly (and easily) from a wide variety of data sources when you convert XML data to RTF. Frank Rice shows how in this new article. |
|
| Working with XML as an Object Model |
| C#Today |
| In this article, Salim Naim explores XML, and how we can work with it as an object model. He shows that XML is truly a core technology layer in .NET, while manipulating and working with XML documents with .NET is a natural method built into the .NET Framework, and not an after thought. He covers various techniques, including how to make use of the core functionality provided by the Base Class Libraries in the .NET Framework classes relevant to XML, and also looks at the two abstract base classed XMLReader and XMLWriter, which the XML classes are built upon. |
|
| XML Document Fidelity & Relational Views Using the XmlDataDocument Class |
| ASPToday |
| There are quite a few examples floating around the Internet of how to perform tasks using XML documents. Theres just as many, if not more, that deal with solutions involving DataSets. However, one of the commonly neglected scenarios is writing code that not only uses a DataSet, but also utilizes an XML document to represent the same data. In this article Kevin Hoffman, firstly, gives you some background information on synchronizing DataSets and XML Documents via the XmlDataDocument class. He then explains how you can provide a relational view of a subset of an XML document, by adding an XML Schema into the equation. He then gives several fully functional examples using practical data and scenarios. |
|
| XML Features in ADO.NET |
| MSDN |
| XML and some of its related technologies, including XPath, XSL Transformation, and XML Schema, are unquestionably at the foundation of ADO.NET. As a matter of fact, XML constitutes the key element for the greatly improved interoperability of the ADO.NET object model when compared to ADO. In ADO, XML was merely an (non-default) I/O format used to persist the content of a disconnected recordset. The participation of XML in the building and in the inter-workings of ADO.NET is much deeper. |
|
| XML Programming using VB.NET: Part 1 |
| C# Corner |
| In this article we will explore XML classes and namespaces of .NET Framework Class Library and how to use them in VB.NET to read, write and navigate XML documents. |
|
