Click here to Skip to main content
13,505,090 members
Click here to Skip to main content
Add your own
alternative version


24 bookmarked
Posted 16 Apr 2002

XmlClient Managed Provider

, 16 Apr 2002
Rate this:
Please Sign up or sign in to vote.
A Class Library that holds a Managed Provider to retreive Load DataSets from Xml sources.
<!-- Download Links --> <!-- Add the rest of your HTML here -->


This is my first attempt at writing a Managed Provider. The idea behind it was to allow users of the Managed Provider to be able to fill DataSets from XML in a homogeneous way. This way you could mix XML and database data together without having to know exactly which is from which.

Usage Notes

  • The Connection string for the XmlConnection class takes a URL or File path to an XML file.
  • The XmlCommand class takes an optional XPath expression to decide which subset of the XML file to include in the DataSet.


// call using: TestXml(@"c:\test.xml", "descendant::server[name='Kay']",
//                      "  ", "File Path with XPath Expression");

static void TestXml(string URL, string XPath, string indent, string Title)
  Console.WriteLine("Testing {0} \nwith XML Source: {1}", Title, URL);
  XmlDataAdapter da = new XmlDataAdapter(XPath, new XmlConnection(URL));

  DataSet ds = new DataSet();

  // Test Filling in with all data
  int rowsAffected = da.Fill(ds);
  Console.WriteLine(indent + "Filled DataSet with {0} rows", rowsAffected);
  string xml = ds.GetXml();

  // Test Filling with Schema only
  DataTable[] aTables = da.FillSchema(ds, SchemaType.Source);
  Console.WriteLine(indent + "Filled DataSet with {0} tables of Schema only",

  // Show XML if XPath is used
  if (XPath != "/") Console.WriteLine(indent + "XPath Results: \n{0}", xml);


  • The DataReader was never implemented.
  • This Managed Provider is read-only. If you need to write with it, please contact me as I might be able to get something working.
  • When using an XPath expression in the XmlCommand class, only the first Match is loaded into the DataSet.


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Shawn Wildermuth
United States United States
No Biography provided

You may also be interested in...


Comments and Discussions

Generallooking forward to more on this... Pin
tim mackey1-Nov-02 14:11
susstim mackey1-Nov-02 14:11 
QuestionWhat is the point of this article? Pin
pbible14-Jul-02 5:43
memberpbible14-Jul-02 5:43 
AnswerRe: What is the point of this article? Pin
Shawn Wildermuth14-Jul-02 8:16
memberShawn Wildermuth14-Jul-02 8:16 
GeneralRe: What is the point of this article? Pin
AKourkoumelis8-Mar-04 9:01
memberAKourkoumelis8-Mar-04 9:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180417.1 | Last Updated 17 Apr 2002
Article Copyright 2002 by Shawn Wildermuth
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid