C#

System.Data.SqlClient.SqlConnection conn = newSystem.Data.SqlClient.SqlConnection("server=pc1;database=northwind;trusted_connection=true");

System.Data.SqlClient.SqlCommand cmd = 
new System.Data.SqlClient.SqlCommand("SELECT * FROM Customers For XML Auto", conn);

            conn.Open();
            System.Xml.XmlReader reader = cmd.ExecuteXmlReader();

            while (reader.Read())
            {
                System.Xml.XmlDocument xmldoc = new System.Xml.XmlDocument();
                xmldoc.Load(reader);
                //do the required processing
            }

System.Data.SqlClient.SqlConnection conn = 
new System.Data.SqlClient.SqlConnection("server=pc1;database=northwind;trusted_connection=true");

System.Data.SqlClient.SqlCommand cmd = 
new System.Data.SqlClient.SqlCommand("SELECT * FROM Customers For XML Auto", conn);

conn.Open();

System.Xml.XmlReader reader = cmd.ExecuteXmlReader();

System.Xml.XmlDocument xmldoc = 
new System.Xml.XmlDocument();

xmldoc.Load(reader);
//do the required processing
//....

conn.Close();

// Open the StreamReader
using (StreamReader sr = new StreamReader(filename))
{
  // Loop until the EOF
  while(sr.Peek() != -1)
  {
    // Discard the odd lines
    sr.ReadLine();
    // Read in the even lines for processing
    string line = sr.ReadLine();
    // Process Line here
  }
  // Close stream
  sr.Close();
}

NeroToxic wrote:

I don't know how to execute commands with the console app

SELECT keyfield, field1, field2, field3 FROM ActivityReport