• Uncategorized
  • How to delete duplicate rows in sql server?


  • Get Active directory users info using UserPrincipal

    //Config ADFS as tutorial in the link below : http://www.dotnetcurry.com/windows-azure/1158/using-adfs-azure-single-signon-aspnet-mvc http://blogs.msdn.com/b/card/archive/2010/06/25/using-federation-metadata-to-establish-a-relying-party-trust-in-ad-fs-2-0.aspx //——————————————————// Please note : we pass Sam-Account Name as Name in Claim Rule setting //Get Property of user in AD for .Net 4.0 -4.5

    // Get groups

  • Uncategorized
  • Query and update an Excel 2010 spreadsheet via a linked server

    First  I downloaded and installed the ‘AccessDatabaseEngine_x64.exe’ file on the SQL Server from http://www.microsoft.com/download/en/details.aspx?id=13255. No restart was required. Next I started SQL Server Management Studio as ‘Administrator’.     Next I enabled the ‘Allow inprocess’ option for the Microsoft.ACE.OLEDB.12.0 provider.     The linked server was created with this script:

  • C#
  • FTPS with C#

    This post will show how to upload , download a file via FTPS protocol with C# Open Nuget manager , search for AlexFTPS package, then add it into your project . This function below demo how to use it :