.NET (Core and Framework)

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