C#

Keviniano Gayo wrote:

The device should able to connect AD to validate the user.

using (var context = new PrincipalContext(ContextType.Domain, credentials.ServerName, credentials.UserName, credentials.Password))
{
    validated = context.ValidateCredentials(userName, password);
}

Quote:

The System Volume Information folder is a hidden system folder that the System Restore tool uses to store its information and restore points. There is a System Volume Information folder on every partition on your computer.

// folder names you do not want to search
private static List<string> BadNames = new List<string>{"Adobe","CPMigrator","ServicePack","Symantec", "Server", "TumbleWeed"};
// folder name you're looking for
private static string targetFolder = "Common7";

static void Main(string[] args)
{
    // start searching in the specified path, and get all of the subfolders therein
    List<string> folders = GetFolders(@"C:\Program Files\");
    // find the first path that ends with the target folder name
    // (of course, you can use pretty much any process for finding the path you're 
    // interested in, so the code I use below should be seen as merely an example).
    string found = folders.FirstOrDefault(x=>x.ToUpper().EndsWith(targetFolder.ToUpper()));
}

// recursive method to build a list of folders
public static List<string> GetFolders(string path)
{
    List<string> folders = new List<string>();
    foreach(string bad in BadNames)
    {
        if (path.ToUpper().Contains(bad.ToUpper())) 
        {
            return folders;
        }
    }

    try
    {
        folders = Directory.GetDirectories(path, "*.*", SearchOption.TopDirectoryOnly).ToList();
        for (int i = 0; i <folders.Count; i++)
        {
            folders.AddRange(GetFolders(folders[i]));
        }
    }
    // this catch block allows you to bypass folders that you don't have access to
    catch (Exception)
    {
    }
    return folders;
}

"Exception de HRESULT : 0x800A03EC"

range.Value2 = result;

public static void LoadData(object[] args)
{
    int rowPosition = Convert.ToInt32(args[0]);
    int columnPosition = Convert.ToInt32(args[1]);
    string sheetName = (string)args[2];
    var application = (Microsoft.Office.Interop.Excel.Application)ExcelDnaUtil.Application;

    var sheet = application.Sheets[Regex.Replace(sheetName, @"\[[^]]*\]", string.Empty)];

    object[,] result = LoadFromDbData();
    var startcell = sheet.Cells[rowPosition + 1, columnPosition + 1];          
    int rowCount = result.GetUpperBound(0)-result.GetLowerBound(0)+1;
    int colCount = result.GetUpperBound(1)-result.GetLowerBound(1)+1;
    var endcell = sheet.Cells[rowPosition+ rowCount, columnPosition+colCount];           
    try
    {
        Range range = (Range)sheet.Range(startcell, endcell);
        range.Value2 = result; 
    }
    catch (COMException e)
    {
        MessageBox.Show(e.Message);
    }        
}