.NET (Core and Framework)

Johnkokk wrote:

Do you really think, that the problem is to multiply 2 numbers ?

Johnkokk wrote:

he problem is to find the algorithm ...

int[] factors=new int[factorList.Length];

// This method should return true if number can be factored using some factors from factorList
// we assume factorList items are all different, positive, non-zero, and ordered numerically ascending.

// call this method with minimum=0 and nesting=0; when it returns true read factors array till the product matches.

public bool CanBeFactoredWithSomeOfThese(int number, List<int> factorList, int minimum, int nesting) {
    foreach(int factor in factorList) {
        if (factor<=minimum) continue;
        if (number%factor!=0) continue;
        factors[nesting]=factor;
        bool OK=true;
        if (number>factor) OK=CanBeFactoredWithSomeOfThese(number/factor, largerFactors, factor, nesting+1);
        if (OK) return true;
    }
    return false;
}

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