C#

David Anton wrote:

Window win = DTE.Windows[EnvDTE.Constants.vsWindowKindCommandWindow];
CommandWindow CW = win.Object;

Mehmet Fatih Akbulut wrote:

the user may click on a button, or change a text field, or even click on an empty place on my form or just used tab key to visit each component on form etc ...?

Mehmet Fatih Akbulut wrote:

what is action ? how will i check if the user performs such an action above ?

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();
}