Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

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.CommandType = CommandType.Text;                 com.CommandText = "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();     } }