C#

DataSet InstrumentsDS = new DataSet();

public void AnalyseTheFilePath(string pathtoanalyse)
{
    Regex wordsplitter = new Regex("\\b\\w+\\b",RegexOptions.IgnoreCase);
    DataSet InstrumentsDS = new DataSet();

    foreach (Match pathword in wordsplitter.Matches(pathtoanalyse))
    {
        foreach (DataRow ThisRow in InstrumentsDS.Tables["instrument_lookup"].Rows)
        {
            if (pathword.ToString() == ThisRow[0].ToString().Trim())
            {
                // do stuff with the dictionary.
            }
        }
    }
}

Jammer

Going where everyone here has gone before!

private static DataSet dsInstruments;
private static DataSet InstrumentsDS
{
    get
    {
        if (dsInstruments == null)
        {
            dsInstruments = BuildLookups.LoadXmlFile(@"LookUpXML\instrument_lookup.xml");
        }
        return dsInstruments;
    }
}

Jammer

Going where everyone here has gone before!

hiraa wrote:

... i havee to use time series for forecastig

foreach (DataRow dr in ds.Tables["table1"].Rows)
{
   if ( (string)dr[1] == "f" )
   {
      dr[1] = "finish";
   }
   else
   {
      dr[1] = "not finish";
   }
}