.NET (Core and Framework)

public static void TestFactors()
{
    List<string> nodes = GetFactors(160, new int[] { 2, 3, 4, 5, 6, 7, 8, 10, 15, 20, 25, 30, 40, 50, 100, 500 });
    foreach (string n in nodes)
    {
        Console.WriteLine(n);
    }
    Console.ReadKey();
}


private static List<string> GetFactors(int number, int[] possValues)
{
    List<string> nodes = new List<string>();
    for (int j = 0; j < possValues.Count(); j++)
    {
        GetFactorsInner(nodes, number, possValues, j, possValues[j], possValues[j].ToString());

    }
    return nodes;
}

private static void GetFactorsInner(List<string> nodes, int number, int[] possValues, int currIndex, int currTot, string currStr)
{
    for (int i = currIndex + 1; i < possValues.Count(); i++)
    {
        int thisTot = currTot;
        string thisStr = currStr;
        if (thisTot * possValues[i] > number)
        {
            break;
        }
        else if (thisTot * possValues[i] == number)
        {
            thisStr += thisStr == null ? possValues[i].ToString() : ", " + possValues[i].ToString();
            nodes.Add(thisStr);
            break;
        }
        else if (number % (thisTot * possValues[i]) == 0)
        {
            thisStr += thisStr == null ? possValues[i].ToString() : ", " + possValues[i].ToString();
            thisTot *= possValues[i];
            GetFactorsInner(nodes, number, possValues, i, thisTot, thisStr);
        }
    }

}

private static List<string> GetFactors(int number, int[] possValues)
{
    int[] possValuesNew = possValues.Where(i => number % i == 0).ToArray();
    List<string> nodes = new List<string>();
    for (int j = 0; j < possValuesNew.Count(); j++)
    {
        GetFactorsInner(nodes, number, possValuesNew, j, possValuesNew[j], possValuesNew[j].ToString());

    }
    return nodes;
}

byka wrote:

How can I check on start if My.Settings.PathToWatch had any files and then call for each file File_Created event?

Protected Overrides Sub OnStart(ByVal args() As String)<br />
               Try                      <br />
            fw = New StreamWriter(LogPathFile)<br />
              fsw = New FileSystemWatcher<br />
<br />
            If args.Length > 0 Then<br />
                ' the path to monitor has been specified in the argument passed in at Start<br />
                fsw.Path = args(0)<br />
            Else<br />
                fsw.Path = My.Settings.PathToWatch' My monitor path<br />
            End If<br />
            fsw.IncludeSubdirectories = False<br />
            fsw.Filter = "*.*"<br />
            fsw.NotifyFilter = NotifyFilters.LastWrite<br />
            AddHandler fsw.Created, New FileSystemEventHandler(AddressOf File_Created) ' File created

byka wrote:

How to I process those files ?

I are Troll

foreach (string filename in Directory.GetFiles(fsw.Path))
{
    FileSystemEventArgs e = new FileSystemEventArgs(WatcherChangeTypes.Created, fsw.Path, filename);
    File_Created(this, e);
}

Roger Wright wrote:

Why would you want to?

MahaKh wrote:

how can i connect visual studio 2008 application to sql server 2008 using ODBC?

using (OdbcConnection con = new OdbcConnection(
    "DRIVER={SQL Server};SERVER=.;Trusted_connection=yes;DATABASE=AdventureWorks;"))
using (OdbcCommand cmd = con.CreateCommand())
{
    con.Open();
    cmd.CommandText = @"
             SELECT FirstName  
               FROM Person.Contact 
              WHERE ContactID = 20";

    string 结果 = (string)cmd.ExecuteScalar();

    MessageBox.Show(String.Format(
        "The FirstName of Person.Contact is '{0}'.", 结果));
}

using System.Data.Odbc;

I are Troll

MahaKh wrote:

but my requirement is to use OLEDB instead of ODBC

using (OleDbConnection con = new OleDbConnection(
    "Provider=SQLNCLI;Server=.;Database=AdventureWorks;Trusted_Connection=yes;"))
using (OleDbCommand cmd = con.CreateCommand())
{
    con.Open();
    cmd.CommandText = @"
             SELECT FirstName  
               FROM Person.Contact 
              WHERE ContactID = 20";

    string result = (string)cmd.ExecuteScalar();

    MessageBox.Show(String.Format(
        "The FirstName of Person.Contact is '{0}'.", 
        result
    ));
}

I are Troll