.NET XML, System.XML

1 of 206 | XML Content Parts in the OpenXML SDK DocumentReflector - [Source: http://geekswithblogs.net/EltonStoneman] The latest release of the OpenXML SDK (v2.0 September 2008 CTP) comes with the DocumentReflector tool which can load an OpenXML document and reverse engineer the code for generating that document with the SDK. It's very handy but there's an issue with it when you have a Word document with content parts that contain XML. In this scenario, DocumentReflector will build the XML content for the part like this: public static void GenerateCustomXmlPart1(OpenXmlPart part) { System.IO.StreamWriter writer = new System.IO.StreamWriter(part.GetStream()); writer.Write("<?xml version=\"1.0\" encodin......

2 of 206 | Code smell – many usings - Normal 0 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:" "; mso-padding-alt:0cm 5.4......

3 of 206 | A DataGrid sample using XML data - I love LINQ, so I'm on a mission to use it in as many samples as possible.  This one is pretty trivial but it took me a bit to put together all the pieces of loading up the xml file to getting the binding to recognize the correct attributes.  Finally I stylized the DataGrid a bit by using a HeaderStyle. A few notes: You need the WPF Toolkit.  I'm using Visual Studio 2008 SP1. Add the WPF Toolkit dlls as resources. Add the xml file as an embedded resource. Here's the code: XAML <Window x:Class="DataGridXML.Window1"     xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"     xmlns:x="http://schemas.microsoft.com/winfx/20......

4 of 206 | Large XML files processing and indexing - Index large XML file for fast access. Use IO and XMLReader for parsing with Regex...

5 of 206 | Getting Document Values from Repeating Nodes in BizTalk - To access a variable in a document in BizTalk is quite easy. First you go to the schema of the document and right click on the value you want to promote. Select Promote -> Show Promotions. To promote the variable as a distinguished property simply click the add button. If you messages are in a separate project make sure you build the solution before continuing. Accessing the promoted property in the orchestration is a simple process. Typing the message name, that represents the schema, in an expression shape. Intellisense will then guide you the rest of the way. Now try that if the document variable that you require can have multiple values. As soon as you try to promote the field BizTa......

6 of 206 | I Didn't Appreciate that TinyURL had an API - When I created my PowerShell script I opted for SnipUrl as it has a nice API that returns a POX response with your shiny new shortened link (Digsby uses SnipUrl and as I use Digsby for most of my Twittering, most of my URLs are SnipUrls). However, Duncan mentioned he was having trouble accessing my shortened URLs and it was then I discovered that TinyURL has an API that would significantly simplify my PowerShell script. The TinyUrl API looks like this: http://tinyurl.com/api-create.php?url=http://mikeo.co.uk and it returns the shortened URL in the response. This means I can do away with my XmlReader and the response parsing code. I also tidied up the SubmitWebRequest function so that the ......

7 of 206 | Remove Rsid Attributes and Elements before Comparing Documents - [Blog Map]  A convenient way to explore Open XML markup is to create a small document, modify the document slightly in the Word user interface, save it, and then compare it with the Open XML Diff utility that comes with the Open XML SDK V2.  However, Word adds extraneous elements and attributes that enable merging of two documents that have forked.  These elements and attributes show up as changed, and obscure the differences that we’re looking for.  An easy way to deal with this is to remove these elements and attributes before comparing documents.  We can safely do so without changing the content of the document.  This post presents a bit of code that uses t......

8 of 206 | PDC 2008 (10/30) - ???????????????????????8????????????????(???15?)???????????????????? Microsoft .NET Framework: Declarative Programming Using XAML Windows 7 Presentation Vitalization: Graphics Remoting ( RDP) Today and Tomorrow Windows 7: Unlocking the GPU with Direct3D WPF: Extensible BitmapEffects, Pixel Shaders, and WPF Graphics Futures Microsoft .NET Framework: Declarative Programming Using XAMLXAML?????????????XAML?(WF?WCF???)???????????????????????????????????????2????????????? XAML 2009 System.Xaml.dll ? .NET 4.0??? (November 2008 CTP) XAML 2009 XAML 2009 ????????????????? ???????(x:Reference) generics???????(x:TypeArguments) ??????? ?????????? ???(x:Key) ?????????????????? ??????????(x:......

9 of 206 | How to Use altChunk for Document Assembly - [Blog Map]  Merging multiple word processing documents into a single document is something that many people want to do.  An application built for attorneys might assemble selected standard clauses into a contract.  An application built for book publishers can assemble chapters of a book into a single document.  This post explains the semantics of the altChunk element, and provides some code using the Open XML SDK that shows how to use altChunk. Instead of using altChunk, you could write a program to merge the Open XML markup for documents.  You would need to deal with a number of issues, including merging style sheets and resolving conflicting styles, merging the ......

10 of 206 | Writers are like Streams - I recently saw some application code that misused XmlWriter and which happened not to work all the time as a result. What they were doing was using XmlWriter to write to an underlying stream and then flushing that stream without having flushed the writer. Depending on the intervening code and the specific document being written in the application code, this might work if all of the content happens to have been committed to the stream prior to it being flushed. It's possible that they picked this error up by copying code from partial samples that don't show what to do with the writer after completing the content. This example is an extreme demonstration of the problem that should r......

11 of 206 | Creating Data-Bound Content Controls using the Open XML SDK and LINQ to XML - Data-bound content controls are a powerful and convenient way to separate the semantic business data from the markup of an Open XML document.  After binding content controls to custom XML, you can query the document for the business data by looking in the custom XML part rather than examining the markup.  Querying custom XML is much simpler than querying the document body.  However, it’s a little bit involved to create data-bound content controls (but only a little bit).  But there is a trick we can do – we can take a document that has un-bound content controls, generate a custom XML part automatically (inferring the elements of the custom XML from the content controls),......

12 of 206 | Open XML SDK 2.0 Architecture - In my first post on the Open XML SDK, I talked about the overall design of the SDK with respect to goals and scenarios. Today, I am going to talk about the architecture of the SDK in terms of its different components. The SDK Architecture The Open XML SDK is designed and implemented in a layered approach, starting from a base layer moving towards higher level functionality, such as validation. The following diagram illustrates an overview of the Open XML SDK components. The System Support layer contains the fundamental components that the SDK is built upon. The Open XML File Format Base Level layer is the core foundation of the SDK. This layer provides you functionality to create Op......

13 of 206 | Mono 2.0 Released - For those Linux devs who don’t have something adamantly against Microsoft, Mono 2.0 has been released!   From the release notes: Mono 2.0 is a portable and open source implementation of the .NET framework for Unix, Windows, MacOS and other operating systems. Release Date: October 6th, 2008 Major Highlights Mono 2.0 is a major milestone in the Mono project, and it supports the following features: Microsoft Compatible APIs ADO.NET 2.0 API for accessing databases. ASP.NET 2.0 API for developing Web-based applications. Windows.Forms 2.0 API to create desktop applications. System.XML 2.0: An API to manipulate XML documents. System.Core: Provides support ......

14 of 206 | Frequently Asked Questions on XML in .NET - Part 1 - As part of a separate task, the XML team came up with a list of frequently encountered issues in System.XML; mainly points that we felt were interesting because they were the source of a lot of difficulty for our users. These questions ranged from rarely used (or misused) methods to difficult XML constructs.  We focused specifically on scenarios that were particularly difficult to debug. When we had completed the exercise, it occurred to the team that we should publish the list. So what follows is the first in a multi-part series in which we will outline each of the questions we defined and provide an explanation of the correct usage, along with some sample code. However, our motives ......

15 of 206 | Frequently Asked Questions on XML in .NET - Part 2 - This is the next post in our ongoing FAQ series. See the original post here. Q2: Conformance Level – Fragment There are times when you want to work with a piece of XML that is not a fully conformant xml document; an example of this is when the XML does not have one root element. This type of XML is called an XML fragment. Here is an example of an XML fragment: “<foo></foo><bar></bar>” If this snippet of XML is used as the source for to the XmlReader, the following exception will occur: “There are multiple root elements. Line X, position Y.” This is a good exception message and tells the user exactly what the problem is: more than o......

16 of 206 | OEM Ready Test Case 1 Incorrectly Fails with a UTF-8 manifest - I haven't posted in a while.  I've been helping out with a couple other programs we have going on in the labs these days.  OEM Ready is a subset of Certified for Windows Vista targeted at applications that ship on new PC's. If you are using the automation in the OEM Ready Certification Test Tool, you can get a false failure if your application has a UTF-8 embedded manifest that has the byte order mark (BOM) included.  Visual Studio 2008 includes the BOM if you use it to embed the manifest.  The error in the log looks something like this: 2008-09-06T01:56:32.4030000Z Information INFO: Embedded manifest exists: <?xml versi......

17 of 206 | OpenXmlCodeTester: Validating Code in Open XML Documents - Many types of documents contain code, including API documentation, tutorials, specifications, technical books, and magazine articles.  Too often, there is no way to automate testing and validation of this code.  This post presents a small example program that shows how to use content controls in Open XML word documents to delineate code snippets so that you can automate validation of the snippets. This scenario was my first use of Open XML – it was the killer application (for me) that prompted me to crack open an Open XML document.  I wrote some code to extract the paragraphs that contain code, compile the code, run it, and validate the output.  Because I had a system i......

18 of 206 | Implementing a News Aggregator in Silverlight and VB.Net #2 Accessing our database from VB.Net - In the years since the .Net runtime was first released I've seen a number of ways of accessing a SQL database from within VB.Net (or C#). One person I worked with had a nifty utility which would take any database and generate all the code to access it. It has been on my list of jobs to do to implement my own such tool but like other jobs, such as winning the National Lottery or a high stakes poker game. OK the poker game is something my wife will have to do - she is better at poker than me. What I do have is a class which encapsulates the functions I need to execute stored procedures on the database. All my database access is executed by inheriting from the following class; Imports Micros......

19 of 206 | How it works: Windows SDK Documentation Part 2 - Many Windows SDK users have questions about the system behind the documentation provided with the SDK.  Part 1 of this series explained the basic structure behind the Windows SDK help system.  It also looked at how ms-help:// URLs can be used to learn about the organization of the documentation “behind the scenes”.  Knowledge of the information in that post is assumed for this post. In this post, the mechanism behind the table of contents (TOC) will be explained.  I will include a couple of easy ways to customize the TOC. TOC Manipulation Topics that appear in the documentation all belong to an HXS file.  Every HXS file is a compressed collection of topic files ga......

20 of 206 | Duplicate InternalName of the Site column - A duplicate name "<string>" was found. at Microsoft.SharePoint.SPFieldCollection.AddFieldToWeb(String strXml, Boolean checkDisplayName) at Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op) at Microsoft.SharePoint.Deployment.FieldTemplateSerializer.CreateField(SPWeb web, SerializationInfoHelper infoHelper) at Microsoft.SharePoint.Deployment.FieldTemplateSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector) at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject) at Microsoft.SharePoint.Depl......

21 of 206 | Debugging business logic in AX 2009 SSRS reports - Background With AX2009 you are now able to do SSRS reports in Visual Studio. The typical process for designing a report consist in creating a query and bind to it, code some business logic (BL) specific to the report and design the visual part. This post will focus on debugging the report business logic. For more information on designing reports in general, see the msdn documentation There is also an excellent post on Channel 9 from my friend Manoj here. Debugging Let say you've designed a fancy report in VS and in order to make it do cool stuff, you had to write some pretty complex business logic. Unfortunately, your business logic does not do what you think it should be doing. You kn......

22 of 206 | Customizing IntermediateSerializer, part 2 - What can you do when serialization helper properties just aren't enough? Bring out the big guns and write your own ContentTypeSerializer. If you have ever written a ContentTypeWriter or ContentTypeReader, this should seem familiar. To customize the XML serialization for this test class: class TestClass { public int elf = 23; } We create this helper: [ContentTypeSerializer] class TestClassSerializer : ContentTypeSerializer<TestClass> { protected override void Serialize(IntermediateWriter output, TestClass value, ContentSerializerAttribute format) { int hundreds = value.elf / 100; int tens......

23 of 206 | XslCompiledTransform.Transform Whitespace - Came across an error when I was using XslCompiledTransfrom.  The error is White space cannot be stripped from input documents that have already been loaded. Provide the input document as an XmlReader instead. Mmm OK.  My VB Code was xsl.Transform(xmlDoc, xw2) and I modified it to xsl.Transform( The xsl includes the xsl xsl:preserve-space elements="*"/> < The white space is not stripped but whatever. If you googled and found this I hope it helps you out.  I wish I had found it hours ago.  I like to post things in my blog that take me a while to figure out in the hopes it helps someone else. New XmlNodeReader(xmlDoc), xw2) ...

24 of 206 | Introducing the XmlPreloadedResolver - The XmlPreloadedResolver is a new type that we’ve been working on in SilverLight that provides the ability to load a DTD without a call to the network. The new type can act as a manually maintainable cache of DTD’s and XML Streams. Let’s look at two examples of how the XmlPreloadedResolver can be used. Example 1: The  XmlPreloadedResolver can be used to pre-load an external DTD. In the following example, a user-defined DTD is pre-loaded into the resolver. The resolver is then used when loading the XML file. String strDtd = "<!ENTITY entity 'Replacement text'>"; String strXml = @"<!DOCTYPE doc SYSTEM 'myDtd.dtd'> <doc>&entity;</doc>";   Syste......

25 of 206 | indent xml with .NET - Original Article: http://bytes.com/forum/thread176986.html Is there a simple way to indent xml with dotnet? SQL Server returns a long xml string that is hard > to read.[/color] XmlReader r = new XmlTextReader(new StringReader(myXML)); StringWriter sw = new StringWriter(); XmlTextWriter w = new XmlTextWriter(sw); w.Formatting = Formatting.Indented; while (r.Read()) w.WriteNode(r, false); w.Close(); r.Close(); Console.WriteLine(sw.ToString()); -- Oleg Tkachenko [XML MVP] http://blog.tkachenko.com ...

26 of 206 | XmlWriterSettings Encoding Being Ignored? - I had an interesting exchange in an internal mailing list today, and thought that my readers could possibly benefit from this clarification as well.  Scenario You are working with the XmlWriter class and trying to write the contents to something.  You are expecting the XML declaration to look like:<?xml version="1.0" encoding="utf-8"?> However, when you inspect the generated XML, it instead looks like:<?xml version="1.0" encoding="utf-16"?> Background The XmlWriter method has an overloaded Create method that accepts an XmlWriterSettings object.  The XmlWriterSettings allows you to specify if the output XML will be indented, what the indentation character will......

27 of 206 | Parsing/Loading/Searching xml document of size ~ 1GB - The Console application which provide efficent way to parse large xml files using xmlReader and DOM object in hand...

28 of 206 | Consume an RSS Feed with .NET 3.5 - .NET 3.5 added some new classes that really help when dealing with RSS/ATOM feeds.  These classes are located in the System.ServiceModel.Syndication namespace in the System.ServiceModel.Web.dll library.  The SyndicationFeed class in this namespace can be used to both expose and consume a feed. Today I was attempting to create a clone of my feed on a website that I am toying around with.  After doing some research on the System.ServiceModel.Syndication namespace, I found that this is extremely simple to do in 3.5.  The following code illustrates just how simple it can be by using the static Load method of SyndicationFeed: 1: // Blog feed 2: Syndicat......

29 of 206 | Setting .NET breakpoints in Windbg for applications that crash on startup - I recently received a question from a reader who wanted to know how to set breakpoints in code for applications that crash on startup. The email went like this: I have a .NET app which is crashing upon startup (it even causes DW20.exe to make an appearance). When I open the .NET app in Windbg, I can see exactly what the exception is and where it happens. What I would like to do is put a breakpoint on the method where the exception is being raised so that I can step through it. This is where I'm stuck. I'm familiar with commands such as !name2ee and !bpmd., however, when I load the .NET app, I don't get a chance to set the breakpoint since the exception happens so early in startup......

30 of 206 | Writing to .Net Config Files - I've been working with config files for quite some time.  I was recently reminded that I needed to finish my original article and share my final findings on my personal best practices for working with config files. One of the coolest and most useful features in config files is the file attribute as displayed below (see my other article for a more detailed explaination, preferred-method-for-read-only-config-files). <configuration>   <configSections>     <section name="MyCustomSection" type="System.Configuration.NameValueFileSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>   </configSections>   ......

31 of 206 | MOSS : How to pass the FBA authenticated user to a PageViewer Web Part? - f you creates a Form based authenticated site and you were not able to get the authenticated login user token at client site. You can user the following resolution when you are working with PageViwer Web Part. using System; using System.Runtime.InteropServices; using System.Web.UI; using System.Web.UI.WebControls.WebParts; using System.Xml.Serialization; using System.Xml; using Microsoft.SharePoint; using Microsoft.SharePoint.WebControls; using Microsoft.SharePoint.WebPartPages; using System.ComponentModel; namespace FBALoginUser { [Guid("2ea076de-3536-4d20-b5d2-365dfd098da6")]   public class FBALoginUser : System.Web.UI.WebControls.WebParts.WebPart { public FBALogin......

32 of 206 | A quick walk-through of CLR Integration with SQL Server - This blog post is inspired by a project I've been working on recently. One of the project requirements is writing all the stored procedures and user-defined functions in CLR integration. Although I don't intent to give you the overview of CLR integration in this article, it's not a bad idea to go over the benefits you get from using CLR integration. Stored procedures and user-defined functions/types/aggregates authored in managed code compiles into native code prior to execution, and you can achieve significant performance increases in scenarios where complex computations or business logics are involved. When you create these CLR objects, you can leverage various functions and services CLR ......

33 of 206 | I have a dream! C# Code Completion in Emacs (csense, dabbrev, etc) - No good options here. I know, dabbrev does some neat things. But it pales in comparison to real code completion as you get in Visual Studio, or, I think, even SharpDevelop. I checked out a module called csense that a lone developer hacked together last year. The goal of the project looked simple, focused, valuable: real code completion in Emacs for C# !!! Whoohoo!!!!! but The implementation looks incomplete  There are no docs  I couldn't even figure out how to initially install it nobody is using it; there were 33 downloads and I think I was about 8 of them. I couldn't figure out how to configure it or what the various vars did, without wading in knee deep in......

34 of 206 | Email router doesn't start (Microsoft.Crm.Tools.EmailAgent.SystemState.xml is empty) - Suddenly my email router stopped working in my VPC. A look in the event viewer showed #16192 - The E-mail Router service could not run the service main background thread. The E-mail Router service cannot continue and will now shut down. System.Configuration.ConfigurationErrorsException: The E-mail router service cannot access system state file Microsoft.Crm.Tools.EmailAgent.SystemState.xml. The file may be missing or may not be accessible. The E-mail Router service cannot continue and will now shut down. ---> System.Xml.XmlException: Root element is missing.   at System.Xml.XmlTextReaderImpl.Throw(Exception e)   at System.Xml.XmlTextReaderImpl.ThrowWithoutLineIn......

35 of 206 | By Popular Demand... More HttpModule Sample Code - Several folks have asked for this, so here it is... the two other pieces of the ResourceRedirect solution from my LAYOUTS branding post. They're also the least interesting, which is why I didn't post them before. :)  Enjoy... review this post for the full context. Redirect.cs using System; using System.Collections.Generic; using System.Text; namespace MOSS.Branding { public struct Redirect { public string pattern; public string masterPageUrl; public string originalMaster; public string destinationPageUrl; public Redirect(string _pattern, string _masterPageUrl, string _originalMaster, string _destinationPageUrl) { pattern = _pattern; masterPageUrl = _masterPageUrl; orig......

36 of 206 | LINQ to SQL - Implementing the Repository pattern - I have been working for the past few days to try and figure out how to get LINQ to SQL integrated into my normal nTier environment. I have also been trying to follow along with the general principles of Domain Driven Design but am finding that there are some deficiencies in the current LINQ to SQL implementation that force a few restrictions on how I do things. Let's first look at some of the restrictions Disconnected DataContext My understanding of the LINQ to SQL DataContext is that it prefers to remain open.  The primary reason for this is that its sole purpose in life is to track the state of it's objects.  As you add new objects into your collections, modify existing objects, or del......

37 of 206 | Graffiti CMS | User Entry - We're using Graffiti CMS as our CMS for Coders 4 Charities, a site that we built to spread the word about our charity event coming late April 2008. We needed to implement a registration page, so that developers and charities can register for the event. Graffiti is obviously very powerful and easy to use, but I had a hard time figuring out how to get user entry to work. Here is my fundamental understanding of how things kinda work: When you create a post, Graffiti will create a folder for your post, and create a default.aspx page. If you categorize the post, it will put your new page under the category sub-dir. When your default.aspx page renders, Graffiti will look for a .view file that ......

38 of 206 | Reading Messages for Validation - How do I perform XML validation against an entire message? There is a method to read the body of the message but it's only possible to read headers one at a time. Although it sounds more complicated than it really is, a straightforward way to read an entire message is to write it instead. With the Message interface, you have more flexibility when writing a message to an XmlWriter than when reading from a generated XmlReader. Exchanging the roles of readers and writers is a common trick used in XML processing. Here's a really short example of using an XmlWriter with some seekable storage. I've replaced the validation step with dumping out the contents of the message. Message mes......

39 of 206 | .NET Framework ????? ???? ??(2008/01) - .NET Framework Library Source Code now available - ScottGu's Blog ??? ????? ?????? ?? ??? ???????. ??? ??? ??? ??? ????: .NET Base Class Libraries (including System, System.CodeDom, System.Collections, System.ComponentModel, System.Diagnostics, System.Drawing, System.Globalization, System.IO, System.Net, System.Reflection, System.Runtime, System.Security, System.Text, System.Threading, etc). ASP.NET (System.Web, System.Web.Extensions) Windows Forms (System.Windows.Forms) Windows Presentation Foundation (System.Windows) ADO.NET and XML (System.Data and System.Xml) ?? ??? ??? ?? ??? ?? ??? ??? ?? ? ?? ??? ??? ?? ???? ?? ???? ??? ??? ??? ???? ???? ???? ?????. ?? ? ??? ?????, ????? ?......

40 of 206 | Debugging the .NET Framework Library Source Code - A while ago, I talked about Microsoft releasing the source code for the .NET Framework in order for you to debug it through Visual Studio 2008. Just a few days ago, it was finally released. Shawn Burke has an excellent and detailed post explaining how to set this up and also has a trouble shooting section. Currently, the following libraries have been released: NET Base Class Libraries (including System, System.CodeDom, System.Collections, System.ComponentModel, System.Diagnostics, System.Drawing, System.Globalization, System.IO, System.Net, System.Reflection, System.Runtime, System.Security, System.Text, System.Threading, etc). ASP.NET (System.Web, System.Web.Extensions) Windows Forms (S......

41 of 206 | Microsoft releases .Net Framework Library Source - Yup, you heard it right, Microsoft has released the source code of the .NET Framework libraries .. they haven’t gone all the way and open sourced it but they have made the source available for debugging and reference, this is very exciting because I’m sure there is a lot in there to learn. The libraries open sourced include … NET Base Class Libraries (including System, System.CodeDom, System.Collections, System.ComponentModel, System.Diagnostics, System.Drawing, System.Globalization, System.IO, System.Net, System.Reflection, System.Runtime, System.Security, System.Text, System.Threading, etc). ASP.NET (System.Web, System.Web.Extensions) Windows Forms (System.Windows.Forms) Windows Presentat......

42 of 206 | XML namespace declarations in SyndicationFeed objects - Following on the heels of Steve Maine's post about namespaces in Syndication objects (Feeds, items, etc.), I thought it wise to plug the new stuff in PictureServices. At the moment, PictureServices implements SLE (Simple List Extensions), and does a pretty crude job of it at that. Time permitting, I will add more support for field and group customization. For now, it serves as an example more than a carrier grade implementation. In any event, I used extension methods in the following type definition to make it easy to insert the right namespace declarations in the feed:using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.ServiceModel.Syndic......