//Microsoft Public License (Ms-PL) //http://dbmlmanager.codeplex.com/license #region using using System; using System.Xml; #endregion namespace DbmlManager.Lib.Utility { #region Class Docs /// <summary> /// Summary description for XmlUtil. /// </summary> #endregion public class XmlUtil { #region GetAttrib(XmlNode node, string attrib, string defVal) public static string GetAttrib(XmlNode node, string attrib, string defVal) { XmlAttribute xmlAttrib = node.Attributes[attrib]; if (xmlAttrib == null) return defVal; string val = xmlAttrib.Value; return (val == null) ? defVal : val; } #endregion } }
Author: coder
Get Int value from xml attribute
//Microsoft Public License (Ms-PL) //http://dbmlmanager.codeplex.com/license #region using using System; using System.Xml; #endregion namespace DbmlManager.Lib.Utility { #region Class Docs /// <summary> /// Summary description for XmlUtil. /// </summary> #endregion public class XmlUtil { #region GetIntAttrib(XmlNode node, string name, out bool found, out bool valid, ref int result) public static void GetIntAttrib(XmlNode node, string name, out bool found, out bool valid, ref int result) { if (node.Attributes == null || node.Attributes[name] == null) { found = false; valid = false; return; } found = true; valid = Int32.TryParse(node.Attributes[name].InnerText, out result); } #endregion } }
Get Attribute Value
//Microsoft Public License (Ms-PL) //http://dbmlmanager.codeplex.com/license #region using using System; using System.Xml; #endregion namespace DbmlManager.Lib.Utility { #region Class Docs /// <summary> /// Summary description for XmlUtil. /// </summary> #endregion public class XmlUtil { #region GetAttrib(XmlNode node, string attrib, string defVal) public static string GetAttrib(XmlNode node, string attrib, string defVal) { XmlAttribute xmlAttrib = node.Attributes[attrib]; if (xmlAttrib == null) return defVal; string val = xmlAttrib.Value; return (val == null) ? defVal : val; } #endregion #region GetAttribOrThrow(XmlNode node, string attrib) public static string GetAttribOrThrow(XmlNode node, string attrib) { string val = GetAttrib(node, attrib, null); if (val == null) throw new Exception(String.Format("Attribute '{0}' not specified in node '{1}'", attrib, node.Name)); return val; } #endregion } }
Set Attribute Value
using System; using System.Text; using System.Xml; //GNU General Public License version 2 (GPLv2) //http://cbasetest.codeplex.com/license class MainClass{ public static void SetAttributeValue(XmlNode xmlne, string name, object value) { SetAttributeValue(xmlne, name, value, null); } public static void SetAttributeValue(XmlNode xmlne, string name, string value) { XmlAttribute node = xmlne.OwnerDocument.CreateAttribute(name); xmlne.Attributes.Append(node); node.Value = value; } public static void SetAttributeValue(XmlNode xmlne, string name, object value, string defaultStr) { string str = defaultStr; if (value != null) { str = value.ToString(); } if (str != null) { SetAttributeValue(xmlne, name, str); } } }
Reading An XML File Into A Dataset
/* * C# Programmers Pocket Consultant * Author: Gregory S. MacBeth * Email: gmacbeth@comporium.net * Create Date: June 27, 2003 * Last Modified Date: * Version: 1 */ using System; using System.IO; using System.Data; namespace Client.Chapter_13___ADO.NET { public class ReadingAnXMLFileIntoADataset { static void Main(string[] args) { string MyXMLDoc = @"<?xml version='1.0'>? <title> MyExample</title>"; StringReader MyStringReader = new StringReader(MyXMLDoc); DataSet MyDataSet = new DataSet(); MyDataSet.ReadXml(MyStringReader); } } }
Persisting A Dataset To An XML File
/* * C# Programmers Pocket Consultant * Author: Gregory S. MacBeth * Email: gmacbeth@comporium.net * Create Date: June 27, 2003 * Last Modified Date: * Version: 1 */ using System; using System.Data; using System.Data.OleDb; namespace Client.Chapter_13___ADO.NET { public class PersistingADatasetToAnXMLFile { static void Main(string[] args) { OleDbConnection MyConnection = new OleDbConnection(@"Provider=Microsft.Jet.OLEDB.4.0; Data Source = c:MyAccessDB.mdb"); OleDbDataAdapter MyAdapter = new OleDbDataAdapter("SELECT Column1, Column2, Column3 FROM MyTable", MyConnection); DataSet MyDataSet = new DataSet(); MyAdapter.Fill(MyDataSet, "MyTable"); MyDataSet.WriteXml(@"c:MyDatSet.xml"); } } }
illustrates how to write and read XML files
/* Mastering Visual C# .NET by Jason Price, Mike Gunderloy Publisher: Sybex; ISBN: 0782129110 */ /* Example23_8.cs illustrates how to write and read XML files */ using System; using System.Data; using System.Data.SqlClient; public class Example23_8 { public static void Main() { // formulate a string containing the details of the // database connection string connectionString = "server=localhost;database=Northwind;uid=sa;pwd=sa"; // create a SqlConnection object to connect to the // database, passing the connection string to the constructor SqlConnection mySqlConnection = new SqlConnection(connectionString); // formulate a SELECT statement to retrieve the // CustomerID, CompanyName, ContactName, and Address // columns for the first two rows from the Customers table string selectString = "SELECT CustomerID, CompanyName, ContactName, Address " + "FROM Customers " + "WHERE CustomerID IN ('ALFKI', 'ANATR')"; // create a SqlCommand object to hold the SELECT statement SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); // set the CommandText property of the SqlCommand object to // the SELECT string mySqlCommand.CommandText = selectString; // create a SqlDataAdapter object SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(); // set the SelectCommand property of the SqlAdapter object // to the SqlCommand object mySqlDataAdapter.SelectCommand = mySqlCommand; // create a DataSet object to store the results of // the SELECT statement DataSet myDataSet = new DataSet(); // open the database connection using the // Open() method of the SqlConnection object mySqlConnection.Open(); // use the Fill() method of the SqlDataAdapter object to // retrieve the rows from the table, storing the rows locally // in a DataTable of the DataSet object Console.WriteLine("Retrieving rows from the Customers table"); mySqlDataAdapter.Fill(myDataSet, "Customers"); // get the DataTable object from the DataSet object DataTable myDataTable = myDataSet.Tables["Customers"]; // use the WriteXml() method to write the DataSet out to an // XML file Console.WriteLine("Writing rows out to an XML file named " + "myXmlFile.xml"); myDataSet.WriteXml("myXmlFile.xml"); // use the WriteXmlSchema() method to write the schema of the // DataSet out to an XML file Console.WriteLine("Writing schema out to an XML file named " + "myXmlSchemaFile.xml"); myDataSet.WriteXmlSchema("myXmlSchemaFile.xml"); // use the Clear() method to clear the current rows in the DataSet myDataSet.Clear(); // use the ReadXml() method to read the contents of the XML file // into the DataSet myDataSet.ReadXml("myXmlFile.xml"); // display the columns for each row in the DataTable, // using a DataRow object to access each row in the DataTable foreach (DataRow myDataRow in myDataTable.Rows) { Console.WriteLine("CustomerID = " + myDataRow["CustomerID"]); Console.WriteLine("CompanyName = " + myDataRow["CompanyName"]); Console.WriteLine("ContactName = " + myDataRow["ContactName"]); Console.WriteLine("Address = " + myDataRow["Address"]); } // close the database connection using the Close() method // of the SqlConnection object mySqlConnection.Close(); } }