Csharp/CSharp Tutorial/ADO.Net/ResultSet to Xml — различия между версиями

Материал из .Net Framework эксперт
Перейти к: навигация, поиск
м (1 версия)
 
м (1 версия)
 
(нет различий)

Текущая версия на 12:19, 26 мая 2010

Convert the result from a query to XML and output

using System;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
class MainClass {
    public static void Main(string[] args)
    {
        using (SqlConnection con = new SqlConnection()) {
            con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";
            using (SqlCommand com = con.CreateCommand()) {
                com.rumandType = CommandType.Text;
                com.rumandText = "SELECT ID, FirstName" +
                    " FROM Employee FOR XML AUTO";
                con.Open();
                using (XmlReader reader = com.ExecuteXmlReader())
                {
                    while (reader.Read())
                    {
                        Console.Write("Element: " + reader.Name);
                        if (reader.HasAttributes)
                        {
                            for (int i = 0; i < reader.AttributeCount; i++)
                            {
                                reader.MoveToAttribute(i);
                                Console.Write("  {0}: {1}",
                                    reader.Name, reader.Value);
                            }
                            reader.MoveToElement();
                            Console.WriteLine(Environment.NewLine);
                        }
                    }
                }
            }
        }
    }
}

Convert the result from a query to XML and output (Disconnected mode)

using System;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
class MainClass {
    public static void Main(string[] args)
    {
        XmlDocument doc = new XmlDocument();
        using (SqlConnection con = new SqlConnection())
        {
            con.ConnectionString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;";
            SqlCommand com = con.CreateCommand();
            com.rumandType = CommandType.Text;
            com.rumandText = "SELECT ID, FirstName FROM Employee FOR XML AUTO";
            con.Open();
            XmlReader reader = com.ExecuteXmlReader();
            doc.LoadXml("<results></results>");
            XmlNode newNode = doc.ReadNode(reader);
            while (newNode != null)
            {
                doc.DocumentElement.AppendChild(newNode);
                newNode = doc.ReadNode(reader);
            }
        }
        Console.WriteLine(doc.OuterXml);
    }
}

Save data stored in table to xml file

using System;
using System.Data;
using System.Data.SqlClient;
class MainClass
{
   static void Main(string[] args)
   {
      string connString = @"server = .\sqlexpress;integrated security = true;database = northwind";
      string qry = @"select productname,unitprice from products";
      SqlConnection conn = new SqlConnection(connString);
      try
      {
         SqlDataAdapter da = new SqlDataAdapter();
         da.SelectCommand = new SqlCommand(qry, conn);
         conn.Open();
         DataSet ds = new DataSet();
         da.Fill(ds, "products");
         ds.WriteXml(@"c:\productstable.xml");
      }
      catch(Exception e)
      {
         Console.WriteLine("Error: " + e);
      }
      finally
      {
         conn.Close();
      }
   }
}

SqlCommand.ExecuteXmlReader

using System;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
class MainClass {
    public static void ConnectedExample() {
        using (SqlConnection con = new SqlConnection()) {
            con.ConnectionString = @"Data Source = .\sqlexpress;Database = Northwind; Integrated Security=SSPI";
            using (SqlCommand com = con.CreateCommand()) {
                com.rumandType = CommandType.Text;
                com.rumandText = "SELECT CustomerID, CompanyName FROM Customers FOR XML AUTO";
                con.Open();
                using (XmlReader reader = com.ExecuteXmlReader()) {
                    while (reader.Read()) {
                        Console.Write("Element: " + reader.Name);
                        if (reader.HasAttributes) {
                            for (int i = 0; i < reader.AttributeCount; i++) {
                                reader.MoveToAttribute(i);
                                Console.Write("  {0}: {1}",reader.Name, reader.Value);
                            }
                            reader.MoveToElement();
                        }
                    }
                }
            }
        }
    }

    public static void Main(string[] args) {
        ConnectedExample();
    }
}