Webpart Overview
MSDN article for Webpart Overview: http://msdn.microsoft.com/en-us/library/ms432401.aspx
Posts
Get SQL Records using XQuery
- Get link
- X
- Other Apps
XML DataType Functions:
Function Description Query Gets a set of nodes from an XML document/fragment (returns XML) Value Gets a single value from an element or attribute of an XML document/fragment (returns scalar value) Exist Returns a Boolean value indicating if the XQuery expression returns values Modify Changes values in an XML document/fragment Nodes Gets a context to a node based upon the XQuery expression
The Following Query runs on AdventureWorks HumanResources.JobCandidate Table to get all Employee First Name & Last Name, Telephone Nos.
SELECT Resume . query ( 'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume"; data(/Resume/Name/Name.First)' ) FirstName , Resume . query ( 'declare default elemen...
Get User Info from Active Directory using LDAP
- Get link
- X
- Other Apps
using log4net; using System.DirectoryServices; public class ADUserInfo { public string ShortName { get ; set ; } public string DisplayName { get ; set ; } public string Email { get ; set ; } } The following method returns ADUser information:
[ Serializable ] [ DataObject ( true )] public class ADUtilities { private static readonly ILog log = LogManager .GetLogger( typeof ( ADUtilities ));
/// /// Returns UserInfo Object, /// Which contains User Display Name,Email Address /// /// User ShortName public static List ADUserInfo > GetCurrentUserInfo( string _userName) { if ( String .IsNullOrEmpty(_userName)) { log.Error( "UserName is null or Empty for GetCurrentUserInfo[_userName]: " + _userName); return null ; ...