Email Password Remember me?  Lost your password?

• Download source files - 11 Kb
• Download demo project - 9 Kb

Introduction

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.

Example

    // 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));

      da.SelectCommand.Connection.Open();
      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", 
                        aTables.GetLength(0));

      // Show XML if XPath is used

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

Caveats

• 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.

You must Sign In to use this message board.

Per page 102550

FirstPrevNext

looking forward to more on this... tim mackey 15:11 1 Nov '02   hi, this is a fine idea that i would be very interested in seeing fully implemented. i don't know why they didn't include it in the .net framework already. hope you get time to put more work into it. i would certainly use it. thanks, tim. Sign In·View Thread·PermaLink 1.00/5 What is the point of this article? pbible 6:43 14 Jul '02   What is the point of posting an article with classes that throw Not Implemented exceptions. While the idea is a good one, you project example does absolutely nothing to help anyone!! Sign In·View Thread·PermaLink Re: What is the point of this article? Shawn Wildermuth 9:16 14 Jul '02   I appreciate your comment, but the Caveat section clearly states what is not implemented. I only implemented the parts of hte provider I needed for my project. I've been meaning to get back to it, but it'll be a while before I can get to it. Sign In·View Thread·PermaLink Re: What is the point of this article? AKourkoumelis 10:01 8 Mar '04   Shawn, Did you ever get a chance to add to this. Here's what I'm trying to do...I want to load a dataset from an xml file. Then I need to make some changes to the dataset then insert those changes into a brand new datasource...will any of this code do that? Sign In·View Thread·PermaLink

Last Visit: 21:25 21 Nov '09     Last Update: 21:25 21 Nov '09 1