C#

            string[] thePaths = Directory.GetFiles("c:\\My Folder");    //replace with the path of your folder<br />
<br />
            //go through each of the files<br />
            foreach (string filePath in thePaths)<br />
            {<br />
                if (Path.GetExtension(filePath) == ".txt")<br />
                {<br />
                    //Do you work here <br />
                }<br />
            }

string[] thePaths = System.IO.Directory.GetFiles("c:\\My Folder", "*.txt");

string strConn = "Provider=SQLOLEDB;Data Source=(local)\\NetSDK;" +
                 "Initial Catalog=Northwind;Trusted_Connection=Yes;";
OleDbConnection cn = new OleDbConnection(strConn);
string strSQL = "SELECT CustomerID, CompanyName FROM Customers";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);

<br />
using System;<br />
using System.Xml;<br />
<br />
namespace DomNodeList<br />
{<br />
  class Program<br />
  {<br />
    static void Main(string[] args)<br />
    {<br />
      XmlDocument doc = new XmlDocument();<br />
      doc.Load(@"D:\workjjf\scripts\xml\MajorKeys.xml"); //<path to XML here><br />
      XmlNodeList majorKeyList = doc.SelectNodes(@"/Root/MajorKey");<br />
      foreach (XmlNode majorKeyNode in majorKeyList)<br />
      {<br />
        XmlElement majorElement = majorKeyNode as XmlElement;<br />
        string majorAttValue = "<null>";<br />
        if (majorElement != null)<br />
        {<br />
          string attValue = majorElement.GetAttribute("att");<br />
          if (attValue != null)<br />
          {<br />
            majorAttValue = attValue;<br />
          }<br />
        }<br />
        Console.WriteLine(majorAttValue);<br />
        XmlNodeList minorKeyList = majorKeyNode.SelectNodes(@"MinorKey");<br />
        foreach (XmlNode minorKeyNode in minorKeyList)<br />
        {<br />
          XmlElement minorElement = minorKeyNode as XmlElement;<br />
          string minorAttValue = "<null>";<br />
          if (minorElement != null)<br />
          {<br />
            string attValue2 = minorElement.GetAttribute("att");<br />
            if (attValue2 != null)<br />
            {<br />
              minorAttValue = attValue2;<br />
            }<br />
          }<br />
          Console.WriteLine("\t" + minorAttValue);<br />
          XmlNodeList valueList = minorElement.SelectNodes("Value");<br />
          foreach (XmlNode valueNode in valueList)<br />
          {<br />
            Console.WriteLine("\t\t" + valueNode.InnerText);<br />
          }<br />
        }<br />
      }<br />
      Console.ReadLine();<br />
    }<br />
  }<br />
}<br />